Symptom
Following successful upgrade of DB6CONV from v6.28 to the latest v6.59, the following sql error (and dump) is reported when starting DB6CONV using tcode SE38:
"SQL0420N Invalid character found in a character string argument of the function "INTEGER". SQLSTATE=22018"
Category Installation Errors
Runtime Errors DBIF_DSQL2_SQL_ERROR
Except. CX_SY_NATIVE_SQL_ERROR
Date and Time 09.07.2022 23:50:56
--------------------------------------------------------------------------------------------------
Short text
SQL error "-420" occurred when executing Native SQL.
--------------------------------------------------------------------------------------------------
Source Code Extract
--------------------------------------------------------------------------------------------------
Line |SourceCde
--------------------------------------------------------------------------------------------------
4866|*** LOCAL EXEC SQL ***
4867|* 6.51: was (TABNAME,6,6) before
4868| EXEC SQL .
>>>>>| SELECT CAST(MAX(SUBSTR(TABNAME,7,6)) AS INT)
4870| INTO :P_COUNT2
4871| FROM DB6CONVT
4872| WHERE TABNAME LIKE '<EXT>_%'
4873| ENDEXEC .
Read more...
Environment
- SAP Netweaver AS ABAB any release
- IBM DB2 LUW (DB6) any release
- DB6CONV current releases
Product
Keywords
DB6CONV SE38 -420 SQL0420N DB6CONVT DB6CONVL , 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.