Oracle issue

kittu.raja · Post by **kittu.raja** » Tue Apr 13, 2010 4:32 pm

Hi,

I am trying to load into the oracle table but I am getting an error saying "Ora_Policy,1: /bin/echo: write error: Broken pipe"
"Ora_Policy,1: Operator terminated abnormally: received signal SIGSEGV".

I am using upsert mode.

My design is FF --- pivot ----Xfm ---- Rmd ----- Oracle

When I run it one more time it is successful.

Tomorrow when I run it again it is not successful and again if I run it it is successful.

The job takes one hour to complete.

I serached in the forum but did not find relevant answer for my case.

Can anyone help me out.

Thanks,

prasad.bodduluri · Post by **prasad.bodduluri** » Tue Apr 13, 2010 11:02 pm

build index on table columns which are key columns, i think it will fast the job.

kittu.raja · Post by **kittu.raja** » Wed Apr 14, 2010 7:15 am

prasad.bodduluri wrote:build index on table columns which are key columns, i think it will fast the job.

I have indexes on my table. but my problem is not the time its aborting for the first time and successful for the second time.

Kryt0n · Post by **Kryt0n** » Wed Apr 14, 2010 4:36 pm

When it works, is it processing faster than when it doesn't work? In particular, how long does it take before it actually starts pushing data in to Oracle.

If it appears to fail just as data is pushed to Oracle, then check your sqlnet expire_time settings or even just try setting it to a lower value. Oracle may be determining your connection has died and cutting you off, DataStage doesn't realise this until it actually tries to load the data. This was something that caught us out but can't actually remember what the error we received was...