Thursday, October 1, 2015

[ODI 12c] ORA-30088 error while loading data from Exadata to Exalytics

Hi,

Recently i faced an ORA-30088 error while loading data from a table in  Exadata server to a table in Exalytics server with ODI 12c tool version 12.1.3.


Here is the output of error.

ODI-1228: Task Create work table-LKM GT Exadata to Oracle (JYTHON)- fails on the target connection EXALIYTCS_TABLE.
Caused By: java.sql.SQLException: ORA-30088: datetime/interval precision is out of range

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)


After some search on internet and oracle-support we see that it is thrown from definiton of TIMESTAMP datatype definition in topology.

We see that ODI forces timestamp(11) value when creating stage table.



After removing of (%L) part, it succesfully starts to load data on stage table.


Ok, that is all

Thanks for reading.

Enjoy & share.

Source:





No comments :

Post a Comment