Symptom
- 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.
Environment
- SAP Analytics Cloud (Enterprise)
Resolution
In the workflow of importing data from on-premise data sources into SAC, the following applications/products are involved where different traces could be collected:
- SAP Analytics Cloud (SAC)
- SAP BTP Cloud Connector (SCC)
- SAP Analytics Cloud Agent (SAC Agent)
- On-Premise Data sources
Trace on SAP Analytics Cloud (SAC)
- Leverage browser-side tracing (Chrome Developer Tools / HTTP Archive Files (HAR)) for troubleshooting page loading performance and obtaining request / response information.
- Refer to SAP KBA 2280022 - How to collect HAR files in SAP Analytics Cloud
- 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.
- Also refer to SAP KBA: 2413393 - How to record timelines in Chrome Developer Tools in case of SAP Analytics Cloud performance issues
Trace on SAP BTP Cloud Connector (SCC)
- The folllowing trace files are required to be collected from SCC:
- Cloud Connector Loggers: ljs_trace.log
- Paylod trace (or calling Traffic trace): traffic_trace_<account id>_on_<landscapehost>.trc
=> Note: <Subaccount_ID> and <Region> would be customer specific. - 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.
- Note: Once you enable the payload trace, please let the issue happen a few times and provide the trace file for further troubleshooting.
Trace on SAP Analytics Cloud Agent (SAC Agent)
- SAP Analytics Cloud Agent is a web application (C4A_AGENT) which is deployed in the Apache Tomcat webserver to handle the connectivity between SAP Analytics Cloud and on-premise data sources after the Cloud Connector has successfully established the secure tunnel.
- SAC Agent is only required for non-HTTP-based data source like BW, ERP, SQL databased, etc.
- For HTTP-based data source like S/4HANA, OData, etc., the HTTP request from SAC could be transferred to data source directly via Cloud Connector, so SAC agent is not required.
- The following trace/log information could be collected with SAC Agent and used to troubleshoot errors between SAP Analytics Cloud Agent and Data Source
- The Tomcat error log: <Tomcat_Install_Dir>/logs/tomcat-stderr.<DATE>.log (for example "tomcat7-stderr.2018-04-09.log")
- The Tomcat catalina log <Tomcat_Install_Dir>/logs/catalina.<DATE>.log (for example "catalina.2018-04-09.log")
- See detail from SAP KBA 3406144 - HOW-TO: Collecting Trace on SAP Analytics Cloud Agent when importing data from on-premise data sources in SAP Analytics Cloud (SAC)
- Note: please let the issue happen a few times and provide the trace files for further troubleshooting.
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 import 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)
- SAP S/4HANA (OData): 2960901 - How to capture OData query when using import data connection to acquire data from S/4HANA On-Premise system in SAP Analytics Cloud
Required Traces for different scenaiors
Check Configuration | Create/Edit Connection | Create model/dataset | Run Import Jobs | |
Trace on SAC | 〇 | 〇 | 〇 | |
Trace on SCC | 〇 | 〇 | 〇 | 〇 |
Trace on SAC Agent | 〇 | △ | △ | △ |
Trace on Data source | 〇 | 〇 | 〇 |
〇: Reuqired
△: Trace on SAC agent are only required for non-HTTP-based data source like BW and ERP, but not required for HTTP-based data source like S/4HANA and OData.
See Also
- 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 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 Support - Search - SAP for Me
Your feedback is important to help us improve our knowledge base.
Keywords
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-ML-DI , Data Integration, Data Export API, Data Import API , LOD-ANA-PL-PLI , Planning Integration (BPC import/export/writeback) , Problem