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

• 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

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

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 1: 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.
• Cause 2: The select item is not BW Query but Virtual Data Model InfoProvider, for which previously automatically created standard queries have been deactivated bydefault after updating as per SAP Note 2745251.

• Restart Tomcat server hosting SAC agent.
  Note: It is always recommended to update your SAC agent to latest version if it is older than 6 month ago (See SAP Note 2658835).
• Make sure that the standard queries for Virtual Data Model InfoProviders has been activated as per SAP Note 2745251.

• SAP Analytics Cloud Best Practices and Troubleshooting Community expert page
• 2630653 - How to Troubleshoot and Trace SAP Analytics Cloud connecting to on-premise / acquired / imported data sources
• SAP Analytics Cloud – Authentication and Data Connectivity openSAP course (free!)
• 2540886 - How to export data from models in SAP Analytics Cloud?
• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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

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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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-AQU-BW , Data Acquisition from BW , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem