2630653 - How to Troubleshoot and Trace SAP Analytics Cloud connecting to on-premise / acquired / imported data sources

• You are using SAP Analytics Cloud (SAC) and want to connect to data stored on your network and import that data into a model or dataset in SAP Analytics Cloud.
• SAP Business Warehouse (BW),
• SAP BW/4HANA,
• SAP S/4HANA,
• SAP HANA,
• Universes,
• SQL Server databases etc.
• Note: All supported data sources are listed here: Data Connectivity – Import.
• What tracing and logging information is needed to help troubleshoot errors and issues?
• For live connections, see 2589761 and the product documentation: Live Data Connection.

• SAP Analytics Cloud (Enterprise)

Trace the Cloud Connector:

• Logging and Tracing on Cloud Connector documentation can be found at: Cloud Connector > Administration > Troubleshooting.
• See also SAP KBA 2452568 - Log and Trace files for SAP Cloud Connector.

Trace the SAP Analytics Cloud Agent:

• SAP Analytics Cloud Agent is a web application (C4A_AGENT) and is deployed in the Apache Tomcat webserver.

• Tomcat Access Logger can be used to determine if communication from the SAP CP Cloud Connector is reaching the SAP Analytics Cloud Agent:
  See http://www.techstacks.com/howto/configure-access-logging-in-tomcat.html
• This log should contain a similar entry when the SAP CP Cloud Connector contacts the SAP Analytics Cloud Agent.

10.165.19.90 - orca [09/Apr/2019:12:36:30 -0700] "GET /C4A_AGENT//deploymentInfo HTTP/1.1" 200 19

• Tomcat Error Logger can be used to troubleshoot errors between SAP Analytics Cloud Agent and Data Source such as SAP Universe.
• The Tomcat error log can be found at <Tomcat_Install_Dir>/logs/tomcat-stderr.<DATE>.log   (for example "tomcat7-stderr.2018-04-09.log").
• Inside this log file you should see an entry for the error.
  Here are some examples:
• April 09, 2018 11:29:48 AM com.sap.fpa.cloud.internal.DAException logException
• SEVERE: Could not reach CMS '10.165.28.118'. Specify the correct host and port and check for network issues. (FWM 20030)
• Could not reach CMS '10.165.28.118'. Specify the correct host and port and check for network issues. (FWM 20030)
• The Tomcat catalina log can be found at <Tomcat_Install_Dir>/logs/catalina.<DATE>.log   (for example "catalina.2018-04-09.log")
• Inside this log file you should see an entry for the error. Here are some examples:
• SEVERE [http-nio-8080-exec-4] com.sap.fpa.logging.CoreLogger.log Enterprise authentication could not log you on. Please make sure your logon information is correct. (FWB 00008)
  com.crystaldecisions.sdk.exception.SDKServerException: Enterprise authentication could not log you on. Please make sure your logon information is correct. (FWB 00008)
  cause:com.crystaldecisions.enterprise.ocaframework.idl.OCA.oca_abuse: IDL:img.seagatesoftware.com/OCA/oca_abuse:3.2
  detail:Enterprise authentication could not log you on. Please make sure your logon information is correct. (FWB 00008)
  The server supplied the following details: OCA_Abuse exception 10496 at [exceptionmapper.cpp : 67] 42040 {}
  ...Enterprise authentication could not log you on. Please make sure your logon information is correct. (FWB 00008)

Traces on various data sources:

• SAP Universe: 2531819 - Troubleshooting errors importing SAP Universe (UNX) in SAP Analytics Cloud
• SAP HANA and SAP BW and SAP BW/4HANA and SAP ERP: 3131525 - How to enable SAP JCO trace to troubleshoot data importing issues in SAP Analytics Cloud (SAC) 
• SAP BW and SAP BW/4HANA: 2834064 - How to enable RSTT Trace in SAP BW for import BW scenario on specific query or CDS View in SAP Analytics Cloud (SAC) 

Browser side tracing (Chrome Developer Tools / HTTP Archive Files (HAR)):

• Article 2280022 - How to collect HAR files in SAP Analytics Cloud
• The Chrome Developer Tools network panel is useful for troubleshooting page loading performance and obtaining request / response information.
• In the network panel, detailed action log and resource information for each request can be seen by reviewing the Header, Preview, Response, Cookies, and Timing sections.

• Header: The Request Payload is important to get the detail action log and resource information
• Preview: In preview tab, we can also find the detail data source information.
• Response: In response tab, we can find the status information for the request resource data.
• Timing: Timing information is helpful when troubleshooting the performance issue. In the timing tab, we can know how the time is distributed for each request, especially for the request time and waiting time.

• Article 2413393 - How to record timelines in Chrome Developer Tools in case of SAP Analytics Cloud performance issues

• SAP Analytics Cloud Best Practices and Troubleshooting Community expert page
• 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 incident 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.

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 , checking , bw note checkig tool sac , failing intermittently , sac model creation failing intermittentl , sactroubleshooting saw sactroubleshootin , sactroubleshooting sac troubleshooting , 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