If so, you need SAP Universal ID. In a few months, SAP Universal ID will be the only option to login to SAP Community. Without it, you will lose your content and badges. If you have multiple accounts, use the Consolidation Tool to merge your content.
SAP HANA: How to identify what are the failed sql statment has been ran in schema
3
0
674
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