SAP Knowledge Base Article - Public

2966843 - Error "Sorry, we couldn't access the datasource. Please contact your administrator" in received PDF file when schedule publication based on live connection in SAP Analytics Cloud (SAC)

Symptom

Error "Sorry, we couldn't access the datasource. Please contact your administrator" in received PDF file when schedule publication based on live connection in SAP Analytics Cloud (SAC).

Environment

SAP Analytics Cloud (Enterprise) 2020.14.11

Reproducing the Issue

  1. Open the story and click Schedule Publication.
  2. Add recipient.
  3. When publication arrives to mailbox, the structure of the story is visible, but datapoints are missing and replaced with error message:"Sorry, we couldn't access the datasource. Please contact your administrator".
    Though story export to PDF works fine.

Cause

In BW the certificate rule Issuer Filter does not match the one the the Cloud Connector.

Resolution

  • IDP Sync on the Cloud Connector should be configured. To confirm this, go to the Cloud Connector -> Cloud To On-Premise -> Principal Propagation, there should be 2 lines under Trust Configuration. If there is not, you can click on the Synchronize button and they should appear.
  • In BW, it is only CN=scc_dbp.
  • You can find this information under Configuration -> On Premise, under CA Certificate, the Issuer line. This should match the Issuer Filter in your BW system exactly.

See Also

Your feedback is important to help us improve our knowledge base.

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, Data,,Unable, Access, Connection, Sac, Connector, Live,BW, Story,Failed, Using, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure,PDF, schedule. scheduled, data missing, Sorry, we couldn't access the datasource. Please contact your administrator, datasource, live connection, publishing , KBA , LOD-ANA-SCH , SAC Story Scheduling and Publication , Problem

Product

SAP Analytics Cloud 1.0