SAP Knowledge Base Article - Public

3351332 - Error " Access was denied.,status:403 " occurs during export:in SAP Analytics Cloud for Planning (SAC)

Symptom

The following error occurs in SAP Analytics Cloud for Planning (SAC) when you export data from SAC to BW using the Odata service:

  • Access was denied.
    status:403

The odata connection behind this export job is using Authentication Type = No Authentication.
If you try to change it to other authentication type, you get error "Authentication is not required. Please use the No Authentication option."

Environment

  • SAP Analytics Cloud (Enterprise)
  • SAP Business Warehouse

Reproducing the Issue

  1. Create an odata connection with Authentication Type = No Authentication.
  2. Create an export job using this odata connection.
  3. Run the export job.

Cause

A  fixed credential is maintained under the Logon Data tab of the SICF note /sap/opu/odata/sap/RSBPC_ODATA_EXPORT_SRV.

Resolution

  1. remove the fixed credential of SICF node /sap/opu/odata/sap/RSBPC_ODATA_EXPORT_SRV
  2. update the existing odata connection or create a new odata connection with other Authentication Type options than No Authentication
    (if you use the old odata connection, you will see error "The request is unauthorized, please check data service url and credentials." when running the export job)
  3. create an export job with the new odata connection
  4. run the new export job

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, Authentication is not required. Please use the No Authentication option, The request is unauthorized, please check data service url and credentials. , KBA , EPM-BPC-NW-INT , Integration , EPM-BPC-BW4-INF , BPC/4 - Infrastructure , LOD-ANA-ML-DI , Data Integration, Data Export API, Data Import API , Problem

Product

SAP Analytics Cloud 1.0