Oracle 10gr timestamp and DB2 time stamp mismatch
Hi i am getting this error which i am executing this line
tableObj.lastUpdateTs = 'now'
here tableObj is the hair object of table.
and the error is
A component failed while executing activity '/TaxAmountProcure#Default-1.0/Interactive[WorkProcurementRequest]' (BP-method Work Procurement Request) over instance '/TaxAmountProcure#Default-1.0/1/0'.
Details:
The method 'CIL_workProcurementRequestWorkProcurementRequestIN' from class 'TaxAmountProcurement.TaxAmountProcure.Default_1_0.Instance' could not be successfully executed.
Caused by: [BEA][DB2 JDBC Driver][DB2]STRING REPRESENTATION OF DAYTIME VALUE NOT VALID DATETIME VALUE
Caused by: [BEA][DB2 JDBC Driver][DB2]STRING REPRESENTATION OF DAYTIME VALUE NOT VALID DATETIME VALUE
fuego.lang.ComponentExecutionException: The method 'CIL_workProcurementRequestWorkProcurementRequestIN' from class 'TaxAmountProcurement.TaxAmountProcure.Default_1_0.Instance' could not be successfully executed. at fuego.component.ExecutionThreadContext.invokeMethod(ExecutionThreadContext.java:519) at fuego.component.ExecutionThreadContext.invokeMethod(ExecutionThreadContext.java:273) at fuego.fengine.FEEngineExecutionContext.invokeMethodAsCil(FEEngineExecutionContext.java:219) at fuego.server.execution.EngineExecutionContext.runCil(EngineExecutionContext.java:1280) at fuego.server.execution.TaskExecution.invoke(TaskExecution.java:401) at fuego.server.execution.InteractiveNormalCilExecution.invoke(InteractiveNormalCilExecution.java:425) at fuego.server.execution.TaskExecution.executeCIL(TaskExecution.java:513) at fuego.server.execution.TaskExecution.executeTask(TaskExecution.java:697) at fuego.server.execution.TaskExecution.executeTask(TaskExecution.java:657) at fuego.server.execution.TaskExecution.executeTask(TaskExecution.java:154) at fuego.server.execution.microactivity.InteractiveMicroActivity.executeNormalCil(InteractiveMicroActivity.java:501) at fuego.server.execution.microactivity.InteractiveMicroActivity.executeItem(InteractiveMicroActivity.java:454) at fuego.server.execution.microactivity.InteractiveMicroActivity.execute(InteractiveMicroActivity.java:104) at fuego.server.AbstractProcessBean$48.execute(AbstractProcessBean.java:3184) at fuego.server.execution.DefaultEngineExecution$AtomicExecutionTA.runTransaction(DefaultEngineExecution.java:304) at fuego.transaction.TransactionAction.startBaseTransaction(TransactionAction.java:470) at fuego.transaction.TransactionAction.startTransaction(TransactionAction.java:551) at fuego.transaction.TransactionAction.start(TransactionAction.java:212) at fuego.server.execution.DefaultEngineExecution.executeImmediate(DefaultEngineExecution.java:123) at fuego.server.execution.EngineExecution.executeImmediate(EngineExecution.java:66) at fuego.server.AbstractProcessBean.runTask(AbstractProcessBean.java:3188) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at fuego.lang.JavaClass.invokeMethod(JavaClass.java:1410) at fuego.lang.JavaObject.invoke(JavaObject.java:227) at fuego.component.Message.process(Message.java:585) at fuego.component.ExecutionThread.processMessage(ExecutionThread.java:780) at fuego.component.ExecutionThread.processBatch(ExecutionThread.java:755) at fuego.component.ExecutionThread.doProcessBatch(ExecutionThread.java:142) at fuego.component.ExecutionThread.doProcessBatch(ExecutionThread.java:134) at fuego.fengine.FEngineProcessBean.processBatch(FEngineProcessBean.java:244) at fuego.component.ExecutionThread.work(ExecutionThread.java:839) at fuego.component.ExecutionThread.run(ExecutionThread.java:408)Caused by: fuego.components.SQLException: [BEA][DB2 JDBC Driver][DB2]STRING REPRESENTATION OF DAYTIME VALUE NOT VALID DATETIME VALUE at fuego.sql.TableSQLObject.implicitStore(TableSQLObject.java:409) at fuego.sql.TableSQLObject.store(TableSQLObject.java:340) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at fuego.lang.JavaClass.invokeMethod(JavaClass.java:1410) at fuego.sql.SQLObject.invoke(SQLObject.java:364) at fuego.lang.Invokeable.invokeImpl(Invokeable.java:234) at fuego.lang.Invokeable.invokeDynamic(Invokeable.java:188) at xobject.Components.ProcurementRequest.store(ProcurementRequest.xcdl) at xobject.Components.BulkUpdateUtilObj.setStatusToSelected(BulkUpdateUtilObj.xcdl:12) at xobject.Fuego__AutoGen__Screenflows__.__WorkProcurementRequestSF.entireXCall(__WorkProcurementRequestSF.xcdl:195) at xobject.Fuego__AutoGen__Screenflows__.__WorkProcurementRequestSF.EntireXCall_Invocator(__WorkProcurementRequestSF.xcdl:7) at xobject.Fuego__AutoGen__Screenflows__.__WorkProcurementRequestSF.Begin_Router(__WorkProcurementRequestSF.xcdl:6) at xobject.Fuego__AutoGen__Screenflows__.__WorkProcurementRequestSF.Begin_Invocator(__WorkProcurementRequestSF.xcdl:11) at TaxAmountProcurement.TaxAmountProcure.Default_1_0.Instance.CIL_workProcurementRequestWorkProcurementRequestIN(Instance.xcdl:2) at TaxAmountProcurement.TaxAmountProcure.Default_1_0.Instance.CIL_workProcurementRequestWorkProcurementRequestIN(Instance.xcdl) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at fuego.component.ExecutionThreadContext.invokeMethod(ExecutionThreadContext.java:512) ... 34 moreCaused by: java.sql.SQLException: [BEA][DB2 JDBC Driver][DB2]STRING REPRESENTATION OF DAYTIME VALUE NOT VALID DATETIME VALUE at albpm.jdbc.base.BaseExceptions.createException(Unknown Source) at albpm.jdbc.base.BaseExceptions.getException(Unknown Source) at albpm.jdbc.db2.drda.DRDARequest.processSQLCA(Unknown Source) at albpm.jdbc.db2.drda.DRDARequest.processCodePoint(Unknown Source) at albpm.jdbc.db2.drda.DRDAStatementRequest.processCodePoint(Unknown Source) at albpm.jdbc.db2.drda.DRDAExecuteStatementRequest.processCodePoint(Unknown Source) at albpm.jdbc.db2.drda.DRDARequest.processReply(Unknown Source) at albpm.jdbc.db2.DB2ImplStatement.getNextResultType(Unknown Source) at albpm.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source) at albpm.jdbc.base.BaseStatement.postImplExecute(Unknown Source) at albpm.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source) at albpm.jdbc.base.BaseStatement.commonExecute(Unknown Source) at albpm.jdbc.base.BaseStatement.executeUpdateInternal(Unknown Source) at albpm.jdbc.base.BasePreparedStatement.executeUpdate(Unknown Source) at fuego.jdbc.FaultTolerantPreparedStatement.executeUpdate(FaultTolerantPreparedStatement.java:623) at fuego.sql.TableSQLObject.update(TableSQLObject.java:916) at fuego.sql.TableSQLObject.implicitStore(TableSQLObject.java:378) ... 56 more