This discussion is archived
0 Replies Latest reply: Nov 6, 2013 8:31 AM by 91c741aa-3535-4efb-83ca-7fbc84d17f6e RSS

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

91c741aa-3535-4efb-83ca-7fbc84d17f6e Newbie
Currently Being Moderated

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!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points