Skip to Content
Author's profile photo Former Member

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.

Assigned tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rajarajeswari Kaliyaperuumal
      Rajarajeswari Kaliyaperuumal

      I know this is an old one, but yet you can use enable expensive statement trace and use m_expensive_statements  and where clause on schema_name and if yiy wan successful statement you have to give error_code is zero

      Author's profile photo Daniel basis
      Daniel basis

      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

      Author's profile photo Rajarajeswari Kaliyaperuumal
      Rajarajeswari Kaliyaperuumal

      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