HI,
We are migrating from oracle 11g to Exadata , but we are facing a very peculiar scenario which is mentioned below,
Job: 21 toracleinput components parallely run and fetch data from exadata and dump the data into files.
Issue: out of 21 toracleinput components some of the toracleinput components extract the data properly and rest fail giving the error
Exception in component tOracleInput_2
java.sql.SQLException: Io exception: Got minus one from a read call
wierd part is out 21 toracleinputs, the number of toracleinputs that extract the data is not constant sometimes 10 get extracted properly sometimes 15.
We are using Talend version 5.3.1.
Note: The code was working properly on oracle 11g.
Thanks,
Hi, Whether these 21 inputs are for different tables in Oracle? Whether data is consistent in all these tables with target metadata defined for flat files? What is mean by Code was working properly on oracle 11g. You are doing migration activity from oracle to exadata. So what is the relation with above statement? Can you please explain? Thanks Vaibhav
Whether these 21 inputs are for different tables in Oracle?
Ans:Yes 21 different tables.
Whether data is consistent in all these tables with target metadata defined for flat files?
Ans:Yes it is consistent.
What is meant by Code was working properly on oracle 11g. You are doing migration activity from oracle to exadata. So what is the relation with above statement?
Ans:This particular code has been working fine since june2013, last week the source database was moved from 11g to exadata, typically our code should work fine by just changing the connection parameters right but it is not happening.
Hi Koustubh, Have you checked the java versions between old and new machines? drivers required for the connectivity on new machine for oracle? I think this is related to jdbc drivers or similar issue. Vaibhav
Have you checked the java versions between old and new machines? We are running talend from windows server with java version "1.7.0_01" which has not changed (so only one machine not two old and new),only the source db has changed to exadata. drivers required for the connectivity on new machine for oracle? I think this is related to jdbc drivers or similar issue. ya we thought so too ,so we dowloaded the latest jdbc drivers from oracle site and have placed in the talends lib folder. still didnot work. Thanks, Koustubh Avadhani
