ORA-03135

[former_member1043171]

Hi,

We are facing connection lost issue. When i Initiate the job,Job will terminated in 20 to 30 seconds. Data moving from Oracle to Oracle.Please Help me out

[former_member272504]

Hi Gowtham,

Is the case with this particular job or all the jobs in the local repository ?

Please create a test job --- > one data flow --- > 1 script with a print statement, such as print('********* Testing local Repo *********'); Check whether the is successful or not. If the job fails, then the issue is with the local repository, if it is success then please attach or copy paste the entire error.

BR,

Mahesh

[former_member1043171]

Thanks Abhisekh,

Row per commit Size is 1000 only..and I reduced the per commit size also..

Source file size is 1crore. and Where to apply row num<2 in query transform.

I’m not able send Screen shot..

Please help me sir

[Former Member]

Hi Gowtham :

What is you rows per commit size is that default 1000,

what is the source data table size .

Try to run the job bu query filter rownum <2.If still the connection lost then talk with your DBA this might possible that the incorrect parameter set on SQLNET.ora file

Please send the error screen shot