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

Workato error
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

  1. Preferably, create a new ODP service for the data source by exposing it as an OData service again.
  2. Or release the existing subscription. This invalidates delta pointers, and the next pipeline starts with a new initial load.
  3. Run /WKTO/ODP_SUBS.
  4. Enter the ODP data source in ODP Name and the service in Service, then execute the report.
  5. Select the subscription row, click the delete row icon and click Yes to confirm.
  6. Save, then run the pipeline again.

04Official documentation

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.