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
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
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.