E1: DB: How to Resolve Error Message "CLI0111E", "SQL0406", "OS400QL016" in Enterprise Server JDE.LOG
Last updated on MAY 30, 2017
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:
- MicroSoft SQL database: http://support.microsoft.com/kb/313352
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> Master 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  [IBM][iSeries Access ODBC Driver]Numeric value 1917846520 out of range.
ODB0000163 - wSQLExecute failure. rc=-1
ODB0000164 - STMT:00  [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?
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