+ Reply to Thread
Results 1 to 3 of 3

CLI0111E Numeric value out of range. SQLSTATE=22003

  1. CLI0111E Numeric value out of range. SQLSTATE=22003

    hi,

    we use Toplink (TopLink - 4.6.0 (Build 417) with a DB2 Database 7.2. i
    know really old versions, but we could change to e newer one ;-)

    Sometimes we got some problems with update or insert statements --
    numeric value out of range. The SQL statements should be right. We
    took the statements and we tried to execute it manually. It works...
    in our programm sometimes it crashed and we get a Database Exception:
    CLI0111E Numeric value out of range

    i will attach the stacktrace, perhaps somebody cna help us....

    EXCEPTION [TOPLINK-4002] (TopLink - 4.6.0 (Build 417)):
    com.webgain.integrator.exceptions.DatabaseException
    EXCEPTION DESCRIPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
    Driver] CLI0111E Numeric value out of range. SQLSTATE=22003
    INTERNAL EXCEPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver]
    CLI0111E Numeric value out of range. SQLSTATE=22003
    ERROR CODE: -99999
    at
    com.webgain.integrator.exceptions.DatabaseException.sqlException(Unknown
    Source)
    at
    com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(Unknown
    Source)
    at
    com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeNoSelect(Unknown
    Source)
    at
    com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.UnitOfWork.executeCall(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.CallQueryMechanism.executeCall(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.CallQueryMechanism.executeCall(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.CallQueryMechanism.insertObject(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.StatementQueryMechanism.insertObject(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(Unknown
    Source)
    at
    com.webgain.integrator.queryframework.InsertObjectQuery.executeCommit(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.performUserDefinedWrite(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.performUserDefinedInsert(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(Unknown
    Source)
    at
    com.webgain.integrator.queryframework.WriteObjectQuery.executeCommit(Unknown
    Source)
    at
    com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.executeWrite(Unknown
    Source)
    at
    com.webgain.integrator.queryframework.WriteObjectQuery.execute(Unknown
    Source)
    at
    com.webgain.integrator.queryframework.DatabaseQuery.execute(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.Session.internalExecuteQuery(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.UnitOfWork.internalExecuteQuery(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.Session.executeQuery(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.Session.executeQuery(Unknown
    Source)
    at
    com.webgain.integrator.internal.sessions.CommitManager.commitAllObjects(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.Session.writeAllObjects(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.UnitOfWork.commitToDatabase(Unknown
    Source)
    at
    com.webgain.integrator.publicinterface.UnitOfWork.commitRootUnitOfWork(Unknown
    Source)
    at com.webgain.integrator.publicinterface.UnitOfWork.commit(Unknown
    Source)

  2. Re: CLI0111E Numeric value out of range. SQLSTATE=22003

    On Mar 20, 9:28 am, tron...@yahoo.com wrote:
    > hi,
    >
    > we use Toplink (TopLink - 4.6.0 (Build 417) with a DB2 Database 7.2. i
    > know really old versions, but we could change to e newer one ;-)
    >
    > Sometimes we got some problems with update or insert statements --
    > numeric value out of range. The SQL statements should be right. We
    > took the statements and we tried to execute it manually. It works...
    > in our programm sometimes it crashed and we get a Database Exception:
    > CLI0111E Numeric value out of range
    >
    > i will attach the stacktrace, perhaps somebody cna help us....
    >
    > EXCEPTION [TOPLINK-4002] (TopLink - 4.6.0 (Build 417)):
    > com.webgain.integrator.exceptions.DatabaseException
    > EXCEPTION DESCRIPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI
    > Driver] CLI0111E Numeric value out of range. SQLSTATE=22003
    > INTERNAL EXCEPTION: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver]
    > CLI0111E Numeric value out of range. SQLSTATE=22003
    > ERROR CODE: -99999
    > at
    > com.webgain.integrator.exceptions.DatabaseException.sqlException(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeNoSelect(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.databaseaccess.DatabaseAccessor.executeCall(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.UnitOfWork.executeCall(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.CallQueryMechanism.executeCall(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.CallQueryMechanism.executeCall(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.CallQueryMechanism.insertObject(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.StatementQueryMechanism.insertObject(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(Unknown
    > Source)
    > at
    > com.webgain.integrator.queryframework.InsertObjectQuery.executeCommit(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.performUserDefinedWrite(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.performUserDefinedInsert(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.insertObjectForWrite(Unknown
    > Source)
    > at
    > com.webgain.integrator.queryframework.WriteObjectQuery.executeCommit(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.queryframework.DatabaseQueryMechanism.executeWrite(Unknown
    > Source)
    > at
    > com.webgain.integrator.queryframework.WriteObjectQuery.execute(Unknown
    > Source)
    > at
    > com.webgain.integrator.queryframework.DatabaseQuery.execute(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.Session.internalExecuteQuery(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.UnitOfWork.internalExecuteQuery(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.Session.executeQuery(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.Session.executeQuery(Unknown
    > Source)
    > at
    > com.webgain.integrator.internal.sessions.CommitManager.commitAllObjects(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.Session.writeAllObjects(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.UnitOfWork.commitToDatabase(Unknown
    > Source)
    > at
    > com.webgain.integrator.publicinterface.UnitOfWork.commitRootUnitOfWork(Unknown
    > Source)
    > at com.webgain.integrator.publicinterface.UnitOfWork.commit(Unknown
    > Source)


    THe data is larger than the field def. Could be a data problem, DB2
    field def or a host variable.

    Because the SQL run manually works, I would think that there is a
    problem with the data. The other possibility is that the data values
    have grown and the field def needs to be expended.

    Good Luck,

    Penn

  3. Re: CLI0111E Numeric value out of range. SQLSTATE=22003

    the field definitionin the database is DECIMAL(8,2) and for example we
    try to insert or update the value to 1330.00 (Double). I think, this
    should be possible....
    ????


+ Reply to Thread