SAP Knowledge Base Article - Public

2525191 - How to use SAP HANA MDS tracing with SAP Analytics Cloud (SAC)

Symptom

How to use SAP HANA MDS tracing with SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)

Environment

  • SAP Analytics Cloud
  • SAP HANA

Resolution

  1. Open SAP HANA SQL Editor in SAP HANA Studio or SAP HANA Web IDE
  2. Connect to the SAP HANA System in the SQL Editor
  3. Issue this SQL Statement to enable minimal trace: ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'System' ) SET ('trace', 'mds') = WITH RECONFIGURE;
  4. Connect to SAP Analytics Cloud tenant using Google Chrome
  5. Open the Story which causes the SAP HANA issue
  6. Open the Google Chrome Developer Tools using the F12 key
  7. Click the Network tab in the Google Chrome Developer Tools
  8. Filter on GetResponse in the Network window
  9. In the SAP Analytics Cloud Story under "Data" choose "Refresh"
  10. In the Google Chrome Developer Tools Network extract the instance ID
    • OrcaMDSTrace.png 
  11. In SAP HANA Studio or SAP HANA Wed IDE search the indexserver trace for the instance ID
  12. Issue this SQL Statement to enable full trace: ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'System' ) SET ('trace', 'mds') = 'debug' , ('trace', 'mds_ce') = 'debug' , ('trace', 'mds_metadata') = 'debug' , ('trace', 'mds_cube') = 'debug' , ('trace', 'mds_cube_write_1') = 'debug' , ('trace', 'mds_cube_write_2') = 'debug' , ('trace', 'mds_cube_write_3') = 'debug' , ('trace', 'mds_cube_write_4') = 'debug' , ('trace', 'mds_blending') = 'debug' , ('trace', 'mds_sc') = 'debug' , ('trace', 'mds_sc_ce') = 'debug' , ('trace', 'mds_sc_cube') = 'debug' , ('trace', 'mds_sc_cube_sort') = 'debug' , ('trace', 'mds_sc_cegp') = 'debug' , ('trace', 'mds_mdenhancer') = 'debug' , ('trace', 'mds_calcmem') = 'debug' , ('trace', 'mds_calcentities') = 'debug' , ('trace', 'mds_expression') = 'debug' , ('trace', 'mds_sql') = 'debug' , ('trace', 'mds_rs') = 'debug' , ('trace', 'mds_caches') = 'debug' , ('trace', 'mds_var') = 'debug'  WITH RECONFIGURE;
  13. In the SAP Analytics Cloud Story under "Data" choose "Refresh"
  14. Issue this SQL Statement to disable tracing: ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'System' ) SET ('trace', 'mds') = 'error' , ('trace', 'mds_ce') = 'error' , ('trace', 'mds_metadata') = 'error' , ('trace', 'mds_cube') = 'error' , ('trace', 'mds_cube_write_1') = 'error' , ('trace', 'mds_cube_write_2') = 'error' , ('trace', 'mds_cube_write_3') = 'error' , ('trace', 'mds_cube_write_4') = 'error' , ('trace', 'mds_blending') = 'error' , ('trace', 'mds_sc') = 'error' , ('trace', 'mds_sc_ce') = 'error' , ('trace', 'mds_sc_cube') = 'error' , ('trace', 'mds_sc_cube_sort') = 'error' , ('trace', 'mds_sc_cegp') = 'error' , ('trace', 'mds_mdenhancer') = 'error' , ('trace', 'mds_calcmem') = 'error' , ('trace', 'mds_calcentities') = 'error' , ('trace', 'mds_expression') = 'error' , ('trace', 'mds_sql') = 'error' , ('trace', 'mds_rs') = 'error' , ('trace', 'mds_caches') = 'error' , ('trace', 'mds_var') = 'error'  WITH RECONFIGURE;
  15. In the Google Chrome Developer Tools Network extract the instance ID
  16. In SAP HANA Studio or SAP HANA Wed IDE search the indexserver trace for the instance ID
    • OrcaMDSTrace.png
  17. When instance ID is found in the indexserver trace please download and attach the indexserver trace to the Support Incident and send to SAP and include the instance ID from steps 10 and 16 in the Support Incident notes

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

query, InA, SAP Cloud for Planning, live, remote, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, trace, mds, ina, CORS, debug , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To

Product

SAP Analytics Cloud 1.0