AnsweredAssumed Answered

Problem with Post to Wip job after upgrading to V12

Question asked by Itai on Oct 29, 2009
Latest reply on Nov 4, 2009 by Paul_Maxwell
Hi,  after upgrading to V12 version, when we run the post to wip job we have the error below. Did someone have this error during the upgrade activity.  ERROR 2009-10-29 15:45:26,122 [Dispatch Thread-23 : bg@papillon.capgemini.com] niku.njs (none:none:none) Error executing job: 5063857com.niku.union.persistence.PersistenceException:SQL error code: 1861Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01861: literal does not match format stringORA-06512: at "NIKU.PAC_PRC_POSTTOWIPS_SP", line 178ORA-06512: at line 1Executed:{call pac_prc_posttowips_sp ( 9236006, 5122000, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) }Derived from statement:    @dynamic@    Referenced by:  Using input:{in_datef=2003-01-01 00:00:00, material=M, equipment=Q, codetype=All, poc=null, batch=null, recalculate_currency=0, in_clntcode=null, batchuser=sbandawa, labor=L, in_sourceModule=null, expense=X, in_code=All, in_datet=2025-01-01 00:00:00}at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:1800)at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:1858)at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2334)at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:701)at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:610)at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:450)at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:221)at com.niku.njs.listeners.SPJob.scheduledEventFired(SPJob.java:137)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-01861: literal does not match format stringORA-06512: at "NIKU.PAC_PRC_POSTTOWIPS_SP", line 178ORA-06512: at line 1at 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.executeInternal(Unknown Source)at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:585)at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$ed018b86.execute( )at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2313)... 8 more  Best regardsItaï

Outcomes