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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.