Symptom
You have been requested by the support team to capture an End to End Trace for log analysis to troubleshoot issues with the following connection types;
- Live Data Connection (Tunnel) to SAP BW using SAML SSO
- Live Data Connection (Direct) to SAP BW using SAML SSO with Advanced Features enabled
- Scheduling issues based on Live Data Connections (Tunnel or Advanced Features) to SAP BW using SAML SSO
The steps below will guide you on how to obtain the required traces, required for further analysis
Environment
- SAP Analytics Cloud
- SAP BTP Cloud Connector
- SAP Web Dispatcher & SAP ICM
- SAP NetWeaver & SAP Business Warehouse
Resolution
To investigate the complete authentication workflow between SAP Analytics Cloud and the BW backend, when Principal Propagation is involved, the following traces will be required;
Product Name | Required Trace (s) | Additional Help Resources |
SAP Analytics Cloud (End User's Browser, where the Connection is created) |
|
2280022 - How to collect HTTP archive files (HAR) files in SAP Analytics Cloud |
SAP BTP Cloud Connector |
|
2452568 - Log and Trace files for SAP Cloud Connector |
Optional: Web Dispatcher (Only required if Web Dispatcher is used as Load Balancer) |
| https://wiki.scn.sap.com/wiki/display/SI/How+to+download+Web+Dispatcher+trace+file+-+dev_webdisp |
SAP Internet Communication Manager (ICM) |
| https://wiki.scn.sap.com/wiki/display/ABAPConn/How+to+create+a+Level+3+ICM+Trace |
BW Logon Procedure |
| https://blogs.sap.com/2016/04/08/sm50-logon-trace-how-to-configure-it-correctly/ |
Step 1: Configuring the required trace levels
Note: Prior to making these changes, please take a note of the current trace levels, and remember to repeat the below steps to change back to default setting after the traces have been captured
SAP BTP Cloud Connector
- Log in to Cloud Connector Cockpit
- Navigate to Log and Trace Files
- Set "Cloud Connector Loggers" to All
- Set "Other Loggers" to All
- Set Payload Trace to "Yes"
For more assistance, refer to KBA 2452568 - Log and Trace files for SAP Cloud Connector, or contact the BC-MID-SCC Support Team
ICM
- Log on to BW System via SAP Logon / SAP GUI
- Go to SMICM Transaction
- Click Goto > Trace > Level > Set to 3
For more information please refer to wiki - https://wiki.scn.sap.com/wiki/display/ABAPConn/How+to+create+a+Level+3+ICM+Trace or contact the BC-CST-IC Support Team
SM50
- Log on to BW System via SAP Logon / SAP GUI
- Go to transaction SM50 (process list)
- Press F5 on your keyboard (select all),
- Press CTRL-Shift-F7 to open Dialog box;
- Set Trace Level = 3 and check the "Security","ICF" and "Crypto Lib" components
For more information please refer to blog - https://blogs.sap.com/2016/04/08/sm50-logon-trace-how-to-configure-it-correctly/ or contact the BC-SEC-LGN Support Team
Network Trace
- Open SAP Analytics Cloud on your browser (Microsoft Edge or Google Chrome)
- Open Developer Tools (Top right Vertical Dots > More Tools > Developer Tools)
- Click "Network Tab"
- Click "Preserve Log" and "Disable Cache"
For more information please refer to KBA 2280022 - How to collect HTTP archive files (HAR) files in SAP Analytics Cloud or contact the LOD-ANA-LDC-HAN Support Team
Step 2: Reproducing the workflow in SAP Analytics Cloud
Now that the required trace levels have been set, please reproduce the issue eg. Create the Connection from SAC and receive the error
Step 3: Capturing and saving the traces
Now that the issue has been reproduced, you can capture the following files, ready to be attached to the SAP Case
Network Trace
- Right Click the failing request (usually shown as a GetServerInfo request) in red under the "Name" column of Developer Tools
- Click "Save all as HAR with Content"
SM50
- On SAP Logon / SAP GUI go to transaction SE38;
- Execute the program RSMON000_DOWNLOAD_TRACES;
- Select the option to provide only "dialog work processes";
- Select the option to compress first (as .SAR);
- Select the save/download button
ICM
- On SAP Logon / SAP GUI go to transaction SMICM
- Click Goto > Trace file > Display All
- Save as Local File > unconverted
SAP BTP Cloud Connector
- Go to Cloud Connector "Log and Trace Files" Menu
- Select ljs_trace.log and traffic.trc rows
- Click Download
Step 4: Attach End to End trace to the SAP Case
See Also
- 2987799 - [Best Practice] How to troubleshoot advanced features based on Live Data Connection to SAP BW in SAP Analytics Cloud (SAC)
- 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 a 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.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.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.
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, 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 , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem