[resolved] Error on tOracleSCD

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