"ORA-01438: value larger than specified precision allowed for this column" Within InfoManager Wrapper Log (Doc ID 1952733.1)

Last updated on MAY 11, 2016

Applies to:

Oracle Knowledge - Version 8.2.3.10 to 8.4.7.1 [Release 8.2 to 8.4]
Information in this document applies to any platform.

Symptoms

Following error is observed within InfoManager wrapper log:

2014/10/13 21:26:00.616 | 31099607 [TestScheduler_Worker-9] DEBUG com.inquira.services.batchjobs.ContentMetricsMergerJob - Site ReferenceKey=MYCO
2014/10/13 21:26:00.616 | 31099622 [TestScheduler_Worker-9] DEBUG com.inquira.model.AbstractEO - Query Fetch Time=14 ms
2014/10/13 21:26:00.718 | 31099631 [TestScheduler_Worker-9] ERROR er.extensions.eof.ERXEOAccessUtilities - Missing EOFailedAdaptorOperationKey or EOFailedDatabaseOperationKey in com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "UPDATE CONTENTMETRICS SET LASTACCESSED = ?, DATEMODIFIED = ?, COUNT = ? WHERE (RECORDID = ? AND DATEMODIFIED = ?)" withBindings: 1:2014-10-13 21:24:29(lastAccessed), 2:2014-10-13 21:26:00(dateModified), 3:10000005(count), 4:"d61a3ad75af946f3bb43727ec23f4094"(recordID), 5:2014-10-13 20:09:27(dateModified)>:
2014/10/13 21:26:00.718 | Next exception:SQL State:22003 -- error code: 1438 -- msg: ORA-01438: value larger than specified precision allowed for this column
2014/10/13 21:26:00.718 | : {EOAdaptorOperationsKey = ({_qualifier = "((recordID = 'd61a3ad75af946f3bb43727ec23f4094') and (dateModified = (com.webobjects.foundation.NSTimestamp)'2014-10-13 18:09:27 Etc/GMT'))"; _adaptorOperator = "EOAdaptorUpdateOperator"; _entity = "ContentMetrics"; _exception = ORA-01438: value larger than specified precision allowed for this column
2014/10/13 21:26:00.718 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
etc.

Cause

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