My Oracle Support Banner

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

Last updated on MAY 16, 2022

Applies to:

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


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?



To view full details, sign in with your My Oracle Support account.

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

In this Document

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