topic Re: [resolved] Error on tOracleSCD in Talend Studio

[resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 10:20:51 GMT

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 ?

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 13:26:32 GMT

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

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 13:50:08 GMT

Sure, this is my job with in red the composant in error

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 13:54:01 GMT

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

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 13:56:01 GMT

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

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 14:03:21 GMT

yeah, i used it, maybe i missed the target
New try :

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 14:05:22 GMT

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

Re: [resolved] Error on tOracleSCD

Anonymous — Mon, 02 Feb 2015 14:09:12 GMT

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 ?

Re: [resolved] Error on tOracleSCD

Anonymous — Tue, 03 Feb 2015 16:00:22 GMT

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