[resolved] Error on tOracleSCD

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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 ? 

[Anonymous · Accepted solution]

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