SAP Knowledge Base Article - Public

3348374 - System error in program CL_RSPLS_SESSION_STORE_MANAGER and form IF_RSPLS_SQL_SCRIPT~EXECUTE_SQL_SCRIPT04 when a planning sequence is triggered from SAC using BPC live connection(BPC embedded)

Symptom

  • Using Live Connection to BPC embedded model. 
  • Triggering a planning sequence from a story. 
  • The error is generated System error in program CL_RSPLS_SESSION_STORE_MANAGER and form IF_RSPLS_SQL_SCRIPT~EXECUTE_SQL_SCRIPT04
  • When the same planning sequence is executed from the backend(tcode RSPLAN) using the same user account(used in BPC live connection in SAC), the result is success. 

Environment

SAP Analytics Cloud (Enterprise) 2023.8.12

Reproducing the Issue

  • Trigger a planning sequence from a story connecting to BPC embedded live model. 
  • System error in program CL_RSPLS_SESSION_STORE_MANAGER and form IF_RSPLS_SQL_SCRIPT~EXECUTE_SQL_SCRIPT04-
  • Log on to the backend and test from tcode RSPLAN to execute the same planning sequence using the user account used in BPC live connection in SAC. No error and the planning sequence returns the result. 

Cause

Missing authorization.

Executing RSPLAN in BPC environment context, the error occurs as well(configure according to SAP note 2476459 )

While the SAC reports the error message, it terminates directly in RSPLAN because the exception is not handled. 

It was identified there was an InfoCube which was used in the query, and it had not been added to BPC model validation.

Resolution

Add the InfoCube used in the query to BPC model validation. 

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, 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 , KBA , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem

Product

SAP Analytics Cloud 1.0