Skip to Content

SAP HANA: How to identify what are the failed sql statment has been ran in schema

Hi Team,

How to identify what are the sql statement ran in hana database in last 2 Hour, and what are the sql statement not ran successfully and what are successfully sql statement.

3 Comments
You must be Logged on to comment or reply to a post.
    • Hi ,

      Could please let me know the error code of runtime dump triggered statements in the monitoring view "m_expensive_statements" of SYS schema.

      Thanks in advance

      • Anything other than ERROR_CODE=0 is a failed statement . For OOM and composite limit it is 2048. there are also other codes like 129,4 etc and we will have a details explanation of the respective column in ERROR_DETAILS in the expensive statement table