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 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 the GetResponse request 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, download and attach the indexserver trace to the Support Incident and include the instance ID from steps 10 and 16 in the Support Incident description.

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-LDC-HAN , SAC Live Data Connection HANA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , How To

Product

SAP Analytics Cloud 1.0