No more data to read from socket error

Five Stars

No more data to read from socket error

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
Moderator

Re: No more data to read from socket error

Hi,
I suspect this is a oracle issue no-more-data-to-read-from-socket-error
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: No more data to read from socket error

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
Moderator

Re: No more data to read from socket error

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.