Symptom
In Dbacockpit while executing transaction code DB01 you observe the following SQL error SQL0420N reported.
=============================================================================
Exception CX_DBA_ADBC in class CL_DB6_RDI method GET_LOCK_OVERVIEW line 210
Kernel Error ID:
SYSID: ERP
SY-SUBRC: 1208
Message: ADBC error
SQL statement: WITH LW AS ( SELECT AGENT_ID AID, LOCK_MODE LM, LOCK_OBJECT_TYPE LO, AGENT_ID_HOLDING_LK AID_HL, SUBSTR(REPLACE(REPLACE(SUBSTR(VARCHAR(LOCK_WAIT_START_TIME),1,19),'.',''),'-',''),1,14) AS START_TIME, TIMESTAMPDIFF( 2, CAST( (CURRENT TIMESTAMP - LOCK_WAIT_START_TIME) AS CHAR(22) )) WAIT_TIME, LOCK_MODE_REQUESTED LM_R, LOCK_ESCALATION ESCAL, TABNAME TABLE, TABSCHEMA SCHEMA, TBSP_NAME TBSPACE FROM SYSIBM.SYSDUMMY1, SYSIBMADM.SNAPLOCKWAIT AS X ) SELECT AGENTS.AID, AGENTS.LM, AGENTS.LM_R, AGENTS.LO, AGENTS.AID_HL, AI.APPL_STATUS, AI.CLIENT_PID, AGENTS.START_TIME, AGENTS.WAIT_TIME, AI.COORD_NODE_NUM, AGENTS.ESCAL, AGENTS.TABLE, AGENTS.SCHEMA, AGENTS.TBSNAME, AI.APPL_NAME, AI.APPL_ID, AI.TPMON_CLIENT_USERID, AI.TPMON_CLIENT_WKSTN, AI.TPMON_CLIENT_APP, AI.TPMON_ACC_STR, ST.STMT_TEXT FROM SYSIBM.SYSDUMMY1, ( SELECT * FROM LW UNION SELECT AID_HL, -1, -1, -1, SUBSTR(REPLACE(REPLACE(SUBSTR(VARCHAR(CURRENT TIMESTAMP),1,19),'.',''),'-',''),1,14) , 0, -1, -1, '', '', '' FROM LW WHERE AID_HL NOT IN ( SELECT AID FROM LW ) ) AS AGENTS ( AID, LM, LO, AID_HL, START_TIME, WAIT_TIME, LM_R, ESCAL, TABLE, SCHEMA, TBSNAME ) LEFT OUTER JOIN ( SYSIBMADM.SNAPAPPL_INFO AS AI INNER JOIN SYSIBMADM.SNAPSTMT AS ST ON AI.AGENT_ID = ST.AGENT_ID ) ON AGENTS.AID = AI.AGENT_ID WITH UR
Database:
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET
SQL Code: 420-
SQL Message: SQL0420N Invalid character found in a character string argument of the function "DECFLOAT". SQLSTATE=22018
=============================================================================
Read more...
Environment
- Netweaver AS ABAP - reference SAP note 1950422 for affected releases
- Db2 (DB6) any version
Product
Keywords
, KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , 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.
SAP Knowledge Base Article - Preview