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.