SAP Knowledge Base Article - Public

3339377 - The SAC Data Export Service - "Start subscriptions failed" when the SAC model is changed

Symptom

Please be advised that this KBA is only for situations where the SAC model is changed (for example, adding a new dimension to the SAC model).

You use the Data Export Service (DES) API in SAP Analytics Cloud (SAC) to transfer data from SAC to a target system.
When you change the SAC model (for example, adding a new dimension to the SAC model), you find the subscription does not work anymore.
For example, if you transfer data using the SAP HANA Smart Data Access, you may see the following error:

  • Error while altering remote subscription
    xxxxxxx
    sql processing error: xxxxxx

In the DP Agent log, the following error is logged:

  • Start subscriptions failed: RS[SACDES]: Failed to start subscription because subscription FactData_xxxxxxxxxxx is not found in CDI provider!

Environment

  • SAP Analytics Cloud (Enterprise)

Cause

As documented in the SAP Analytics Cloud REST API help page, 
When accessing data via the initial subscription delta link, it’s important that the underlying data in the model for the initial replication does not change during the extraction process.

Data Export Service and specifically the Delta Load feature rely on the model metadata information.
When the underlying structure of the model is changed (such as adding/removing dimensions or columns, changing the date granularity), the Subscriptions for that model are invalidated and automatically deleted. In that case, a complete initialization is recommended after the reset.

Resolution

Please reset the subscription and reinitiate the task.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software, DES, API, exporting, loading, delta loading, real-time replication, FactData_* is not found in CDI provider!, FactData_ is not found in CDI provider, FactData is not found in CDI provider,  etc. for example , KBA , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud 1.0