[resolved] Error on tOracleSCD

Highlighted
One Star

[resolved] Error on tOracleSCD

Hi,
I use the TOS version 4.0.3r47759, and i experience an error on the composant tOracleSCD.
Here the error (i've translated the error sentence from french so it's highly possible that this phrase does not exist in SQL; the original sentence is : Le flux de données est déjà fermé)
Exception in component tOracleSCD_1
 
java.sql.SQLException: The data stream is already closed
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
 
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
 
at oracle.jdbc.driver.LongAccessor.getBytes(LongAccessor.java:151)
 
at oracle.jdbc.driver.LongAccessor.getString(LongAccessor.java:193)
 
at oracle.jdbc.driver.T4CLongAccessor.getString(T4CLongAccessor.java:422)
 
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:397)
 
at infocentre.copy_of_d_fournisseurs_0_1.Copy_of_D_FOURNISSEURS.tOracleInput_1Process(Copy_of_D_FOURNISSEURS.java:5591)
 
at infocentre.copy_of_d_fournisseurs_0_1.Copy_of_D_FOURNISSEURS.tOracleConnection_1Process(Copy_of_D_FOURNISSEURS.java:774)
 
at infocentre.copy_of_d_fournisseurs_0_1.Copy_of_D_FOURNISSEURS.runJobInTOS(Copy_of_D_FOURNISSEURS.java:13891)
 
at infocentre.copy_of_d_fournisseurs_0_1.Copy_of_D_FOURNISSEURS.main(Copy_of_D_FOURNISSEURS.java:13645)

Does anybody know what it means please ?

Accepted Solutions
One Star

Re: [resolved] Error on tOracleSCD

So, i've found.
A column from my table was a LONG and the stream column was a STRING.
When i launched the job for the first time, it worked. The second time, i had the error upstairs.
Finally, to fix the error, i had to change the type from LONG to CLOB at it works perfectly fine
hope it could help.
Bye

All Replies
One Star

Re: [resolved] Error on tOracleSCD

Could you upload a screenshot of your Job ?
It'll help to see where your problem is.
One Star

Re: [resolved] Error on tOracleSCD

Sure, this is my job with in red the composant in error Smiley Happy
One Star

Re: [resolved] Error on tOracleSCD

Don't see my screenshot in my post, is it only me ? Could you tell me ?
One Star

Re: [resolved] Error on tOracleSCD

Actually, I can't see it too.
Using the drag and drop, it works perfectly Smiley Happy
One Star

Re: [resolved] Error on tOracleSCD

yeah, i used it, maybe i missed the target Smiley Happy
New try : 
One Star

Re: [resolved] Error on tOracleSCD

ok, still not.
This time i'm gone use the "click and paste..."
One Star

Re: [resolved] Error on tOracleSCD

Sorry, i don't understand why my screenshost is invisible...
Anyway, is there someone with an idea for my problem with the error on the data stream ? 
One Star

Re: [resolved] Error on tOracleSCD

So, i've found.
A column from my table was a LONG and the stream column was a STRING.
When i launched the job for the first time, it worked. The second time, i had the error upstairs.
Finally, to fix the error, i had to change the type from LONG to CLOB at it works perfectly fine
hope it could help.
Bye

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download