Symptom
On SAP application system, you find ST22 dump about runtime error DBSQL_SQL_ERROR as follows :
=====================================================================
----------------------------------------------------------------------------------------------------
Category ABAP programming error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Date and Time 15.08.2023 09:52:20 (UTC)
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|Short Text |
| SQL error "SQL code: 465" occurred while accessing table "<Table_name>". |
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
|What happened? |
Database error text: "SQL message: Cannot execute trigger, was invalidated by object change: failure in revalidating check for trigger (<Schema_name>.<Trigger_name>)
----------------------------------------------------------------------------------------------------
=====================================================================
On HANA DB, you can check the trigger with the SQL command below and the returned result is FALSE:
SELECT IS_VALID FROM TRIGGERS WHERE TRIGGER_NAME = '<Trigger_name>';
IS_VALID
FALSE
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
- SAP HANA, Platform Edition 1.0
- SAP HANA, Platform Edition 2.0
Product
Keywords
SQL code: 465, Invalid database trigger, Cannot execute trigger, Replace Trigger, trigger is invalidated, ST22, SQL code: 465 , KBA , HAN-DB , SAP HANA Database , CA-DI-IS-ABA , ABAP Integration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.