Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 10gr timestamp and DB2 time stamp mismatch

Brijesh Kumar SinghAug 12 2009 — edited Aug 13 2009
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
This post has been answered by Dan Atwood on Aug 13 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2009
Added on Aug 12 2009
5 comments
3,088 views