SAP Knowledge Base Article - Public

2757519 - "Query view instantiation failed" error when trying to create new model in SAP Analytics Cloud

Symptom

  • The following error message occurs in SAP Analytics Cloud when trying to create a new model from a BW import data connection:
    Query view instantiation failed"
  • Error message in the google developer tool network panel:
    {"status":"Error","error":{"code":"ERROR_CONNECT_TO_C4A","rawError":"","params":[]},"httpStatus":503}"
  • This happens after a BW outage or update.
  • Errors in Tomcat logs:
    SEVERE: Error while processing BW request: com.sap.fpa.cloud.rest.bw.QueryException: QUERYVIEW_INSTANTIATE_FAILED null

Environment

  • SAP Analytics Cloud
  • Import data connections
    • SAP Business Warehouse
  • Apache Tomcat

Reproducing the Issue

  1. Logon to SAP Analytics Cloud
  2. Create a new Model >> Get Data from a Datasource >> Acquire Data >> SAP BW
  3. Select the connection and create new query option
  4. Select a BW Query
  5. Notice the error

Cause

  • During the BW back-end system downtime a schedule was running and a "Query view instantiation failed" error appeared.
  • This error is cached to the tomcat and comes up when trying to reach the same system, even if it is up and running.

Resolution

  • Restarting the tomcat server resolves the issue.

See Also

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

Keywords

Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Acquire, Acquired, QUERYVIEW_INSTANTIATE_FAILED, EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Import, Acquired, Acquire, 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, Troubleshoot, Troubleshooting, bp, bps, T-shooting 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 epm, business intelligence, , KBA , sap sac load failures , loading dataloads data loads , load failures , import connection , sactroubleshooting saw sactroubleshootin , sactroubleshooting sac troubleshooting , sac model creation failing intermittentl , checking , bw note checkig tool sac , failing intermittently , best practices bp bps , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-PL , Planning , LOD-ANA-PR , SAC Predictive , LOD-ANA-ADM , SAC Administration , Problem , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0