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 (SAC)?

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. Execute this SQL statement to enable minimal trace: ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'System' ) SET ('trace', 'mds') =  'info' 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 tab, extract the instance ID:
    • OrcaMDSTrace.png 
  11. In SAP HANA Studio or SAP HANA Web IDE search the indexserver trace for the instance ID
  12. Execute 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. Execute 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 the instance ID is found in the indexserver trace, please download and attach the indexserver trace to the Support Incident and send it 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.

Keywords

query, InA, SAP Cloud for Planning, live, remote, sc4p, c4p, cforp, cloudforplanning,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