E1: DB: How to Resolve Error Message "CLI0111E", "SQL0406", "OS400QL016" in Enterprise Server JDE.LOG (Doc ID 1456043.1)

Last updated on JUNE 03, 2024

Applies to:

Goal

The error message: CLI0111E  Numeric value out of range is specific to DB2 database. However a similar error can also come from a SQL Server or Oracle database:

• Microsoft confirms that this is a bug in Microsoft products that are listed at the beginning of their article. This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.
• Oracle database: <Document 1137237.1> Primary Note for Diagnosing ORA-06502 Error or ORA-01438 error
• E1 and Oracle database: <Document 1527551.1> E1: DB: Troubleshooting Guide for Oracle Database ORA-NNNNN Error Messages and EnterpriseOne
• If this type of error comes from non-DB2 database, contact the specific database vendor for further assistance.

Example of the Enterprise Server JDE.LOG:

Depending on your RDBMS the error can show up in Call Ojbect Kernel logs as below:

ODBC[Jdbodbc.c,3981] STMT:00 [22003][30160] [IBM][iSeries Access ODBC Driver]Numeric value 1917846520 out of range.
ODB0000163 - wSQLExecute failure. rc=-1
ODB0000164 - STMT:00 [22003][30160] [IBM][iSeries Access ODBC Driver]Numeric value 1917846520 out of range.

OCI0000179 - Error - ORA-31495: error in synchronous change table on "PRODDTA"."F4105"
ORA-01438: value larger than specified precision allowed for this column      

OS400QL016 - ExecuteSQLRequest: QSQLMSG   *LIBL      - SQL0302 - Conversion error on variable or parameter &2

OS400QL016 - ExecuteSQLRequest: QSQLMSG   *LIBL      - SQL0406 - Conversion error on assignment to column &2

What causes this message and how can it be resolved?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.