Hi

I am getting this error :

ODI-1228: Task Create staging (C$) table-LKM SQL to Oracle (Built-In)- fails on the target connection FILE_GENERIC.

Caused By: java.sql.SQLException: ODI-40400: Invalid format description

at com.sunopsis.jdbc.driver.file.impl.metadata.MetaDataExtractor.buildTableDescFromRequestSQLExceptionOnly(MetaDataExtractor.java:480)

at com.sunopsis.jdbc.driver.file.SQLManager.buildCommand(SQLManager.java:438)

at com.sunopsis.jdbc.driver.file.FileStatement.buildCommand(FileStatement.java:96)

at com.sunopsis.jdbc.driver.file.FileStatement.execute(FileStatement.java:83)

After I imported a project that was working with Oracle Database 12c EE Extreme Perf Release 12.1.0.2.0 but appears to be fail

with Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

The failing steps :

create table ODI_DEPLOY01.C$_0DATASOURCECSV ( C1 CLOB ) ;

works when done via sqlplus .

# sqlplus 'SYSTEM/<passwd>@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.xxxx)(PORT=1521))(CONNECT_DATA=(service_name=ocrcload.devopspub1.devopsalpha.oraclevcn.com)))'

Connected to:

Oracle Database 12c EE Extreme Perf Release 12.2.0.1.0 - 64bit Production

SQL> create table ODI_DEPLOY01.C$_0DATASOURCECSV

(

C1 CLOB

)

Table created

In ODI :

The table create sub-task step 40 fails and the entire execution halts afterwards :

<

Detail of step 40 failing :

I have be struggling with this for a couple of days. Is there anyone who could explain a more detailed explanation of what is wrong ?

How do I open a support ticket ?

John D

John.p.Donnelly < at oracle > dot <com >