topic Re: No more data to read from socket error in Talend Studio

No more data to read from socket error

djugal — Fri, 10 May 2013 07:12:37 GMT

Hi all,
I use a job which takes input frm url & inserts it into table
bufferinput -----> oracle o/p
job is achieved with the help of context params.
the job when exported as war file works fine in my env i.e windows & oracle 11g
when i deploy the same job on a diff machine using solaris & Oracle 10g it gives an error if number of records are on higher side (greater than 100)
no error as such but the rows are rejected saying "No more data to read from socket"
job works fine if number of records are few
regards,
djugal

Re: No more data to read from socket error

Anonymous — Fri, 10 May 2013 08:19:32 GMT

Hi,
I suspect this is a oracle issue no-more-data-to-read-from-socket-error
Best regards
Sabrina

Re: No more data to read from socket error

djugal — Fri, 10 May 2013 08:41:33 GMT

hi sabrina,
i am gettin the error
Exception in component tOracleOutput_1
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C7Ocommoncall.doOCOMMIT(T4C7Ocommoncall.java:75)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:558)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3674)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3680)
at ta.temp_oracle_jas_0_1.temp_oracle_jas.tFixedFlowInput_1Process(temp_oracle_jas.java:2153)
at ta.temp_oracle_jas_0_1.temp_oracle_jas.tFileInputDelimited_1Process(temp_oracle_jas.java:861)
at ta.temp_oracle_jas_0_1.temp_oracle_jas$1.run(temp_oracle_jas.java:2478)
-bash-3.00$
the job works fine in windows env so i guess its not oracle issue
is there some errors happening on sun solaris side
Thanks & regards,
djugal

Re: No more data to read from socket error

Anonymous — Fri, 10 May 2013 09:01:17 GMT

Hi,
To confirm it, could you connect to the oracle 11g to see if this issue repro? In addition, so far sun solaris Platform is not supported by talend official reference: Compatible Platforms, however, you can migrate the job script into sun solaris and then execute it.

Best regards
Sabrina