E1: DB: How to Resolve Error Message "CLI0111E", "SQL0406", "OS400QL016" in Enterprise Server JDE.LOG

(Doc ID 1456043.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.

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:

 

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms