[resolved] SCD ORA connector NULL pointer error

Anonymous — Wed, 20 Aug 2014 18:43:28 GMT

The below simple job trying to make use of SCD component in Oracle, throws NULL pointer from Delimited file. Anything missing?

Re: [resolved] SCD ORA connector NULL pointer error

Anonymous — Wed, 20 Aug 2014 21:59:17 GMT

While running in a Talend server (in a Linux), get some more info. It's the same job.

Sending job 'SCD_II_ORA' to server (10.170.24.35:8001)...
File transfer completed.
Deploying job 'SCD_II_ORA' on server ()...
Running job 'SCD_II_ORA'...
Starting job SCD_II_ORA at 13:48 20/08/2014.
connecting to socket on port 3664
connected
disconnected
Exception in component tOracleSCD_1
java.sql.SQLSyntaxErrorException: ORA-00904: "SCD_END": invalid identifier
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:774)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:849)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1377)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:386)
at test.scd_ii_ora_0_1.SCD_II_ORA.tFileInputDelimited_1Process(SCD_II_ORA.java:785)
at test.scd_ii_ora_0_1.SCD_II_ORA.runJobInTOS(SCD_II_ORA.java:1726)
at test.scd_ii_ora_0_1.SCD_II_ORA.main(SCD_II_ORA.java:1579)
Job SCD_II_ORA ended at 13:48 20/08/2014.

Re: [resolved] SCD ORA connector NULL pointer error

Anonymous — Wed, 20 Aug 2014 22:13:13 GMT

Resolved. It was a metadata issue.

topic Re: [resolved] SCD ORA connector NULL pointer error in Talend Studio

[resolved] SCD ORA connector NULL pointer error

Re: [resolved] SCD ORA connector NULL pointer error

Re: [resolved] SCD ORA connector NULL pointer error