Analytics Software

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!

Unhandled token type: Unknown token: 0x45 converting sqlserver smalldatetime to oracle timestamp

1052887Nov 6 2013

Hi!

I'm using ODI 12c to migrate some data from MS Sql server DB to Oracle 12c DB.

I'm using LKM SQL to Oracle and IKM Oracle Update.GLOBAL.

In conversion, i'm using CAST(<smalldatetime field> AS TIMESTAMP).

In step Load Data of LKM SQL to Oracle i'm getting the following error:

8000 : 08006 : java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x45

java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Unhandled token type: Unknown token: 0x45

I think it could be caused by the use of LKM SQL to Oracle instead of LKM MSSQL to Oracle. I use SQL to Oracle because I have no agent configured.

Can you help please? Has anyone experienced this error?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2013

Added on Nov 6 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

0 comments

761 views