AnsweredAssumed Answered

SQL 'value too large for column' error for Investment Allocation Job

Question asked by priyanga on Jun 27, 2012
Latest reply on Jul 9, 2012 by Chris_Hackett
Hi,

We got an Investment Allocation job which runs every night. Recently we have been getting an email with the error message below;

This scheduled job failed. Investment Allocation Daily @ 02:00
Job: Investment Allocation Daily @ 02:00
Run ID: 8626019
Scheduler ID: bg@gbahevpl31.ics.express.tnt
Failed - Message: NJS-0401: Execution of job failed.


After looking at the bg-niku log, I found out the following error message. Any idea on how to fix this?

Thanks.

ERROR 2012-06-26 02:15:16,462 [Dispatch Thread-1454 : bg@gbahevpl31.ics.express.tnt] niku.njs (none:none:none) Error executing job: 5004588
java.lang.RuntimeException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "PPADMIN"."INV_INVESTMENTS"."SLICE_STATUS" (actual: 26, maximum: 22)


at com.niku.projmgr.service.staffing.job.InvestmentAllocationJob.scheduledEventFired(InvestmentAllocationJob.java:101)

at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:277)

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:727)

at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "PPADMIN"."INV_INVESTMENTS"."SLICE_STATUS" (actual: 26, maximum: 22)


at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.oracle.OracleImplStatement.execute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source)

at com.ca.clarity.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source)

at sun.reflect.GeneratedMethodAccessor51.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:592)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$1363ef37.executeUpdate(<generated>)

at com.niku.xql2.jdbc.JDBCRecordSet.update(JDBCRecordSet.java:533)

at com.niku.xql2.jdbc.JDBCRecord.doUpdate(JDBCRecord.java:499)

at com.niku.xql2.rules.BaseRule.onUpdate(BaseRule.java:115)

at com.niku.xql2.pmd.rules.INVInvestmentsRule.onUpdate(INVInvestmentsRule.java:214)

at com.niku.xql2.jdbc.JDBCRecord.update(JDBCRecord.java:476)

at com.niku.xql2.pmd.rules.InvestmentTSVController.generate(InvestmentTSVController.java:304)

at com.niku.xql2.pmd.rules.InvestmentTSVController.processRequest(InvestmentTSVController.java:94)

at com.niku.projmgr.service.staffing.job.InvestmentAllocationJob.scheduledEventFired(InvestmentAllocationJob.java:77)

... 3 more

Outcomes