Workato · SAP Data Agent
SAP ODP2 subscription is already held by another pipeline
Short answer
This error means incremental sync was started for an ODP service that another pipeline already uses for incremental sync. Each ODP service supports incremental sync in one pipeline only, so create a new ODP service or release the existing subscription.
VerifiedLast verified
01Error text
SAP ODP2 subscription for service '<ServiceName>' is already held by another pipeline: This OData service is already used by Pipeline ID: <PipelineID>...02Likely causes
- Incremental sync started for a data source whose service is already used for incremental sync by another pipeline.
03How to fix it
- Preferably, create a new ODP service for the data source by exposing it as an OData service again.
- Or release the existing subscription. This invalidates delta pointers, and the next pipeline starts with a new initial load.
- Run
/WKTO/ODP_SUBS. - Enter the ODP data source in ODP Name and the service in Service, then execute the report.
- Select the subscription row, click the delete row icon and click Yes to confirm.
- Save, then run the pipeline again.
04Official documentation
→Related errors
- SAP ODP2 data source subscribed for a fresh initial load, but its DeltaLinks history is not emptyThis error means an initial load started while delta entries still exist in SAP, usually just after an earlier pipeline's subscription was deleted. Wait about 5 minutes and run again, and if it persists delete the orphaned subscription.
- SAP ODP2 data source is now driven by another subscriptionThis error means the pipeline's subscription was terminated manually in SAP and another pipeline then started incremental sync on the same data source. Delete this pipeline, decide which pipeline to keep, and recreate if needed.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer