SAP HANA: How to identify what are the failed sql statment has been ran in schema
3
0
385
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.
Alerting is not available for unauthorized users
Assigned Tags
3 Comments
You must be Logged on to comment or reply to a post.
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
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
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
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