SAP Knowledge Base Article - Preview

3121705 - Transaction code DB01 is reporting SQL error SQL0420N.

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

SAP ERP 6.0

Keywords

DB6, DB2 LUW, DBACOCKPIT, locks, deadlocks, SQL0415N


, 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.