Skip to Content
0

ORA-03135

Mar 12 at 12:14 PM

27

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Mar 12 at 12:47 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 13 at 11:53 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 14 at 07:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded