DSXchange

After going through all the posts in forum. I found out that my issue is with Oracle enterprise stage which was never present in DS8.0. Here is the scenario: -

I am using DS 8.1. I am using Oracle Enterprise stage to load the data in target table in Oracle 10g. The problem is the target table has 380 columns.

When I am trying to load the data in this table, th job aborts with error: -
.

Where as If I am loading the same table with only 20 columns in the Oracle Enterprise stage, then the job runs fine and it populates these 20 cols and rest all are set to Null.

Incidently when I am reading all 380 columns from the same table in a different job then it is giving no problem and it is running fine.

Also instead of Oracle Enterprise stage If I am using ODBC stage then also the job is running fine.

Can anyone please help me in resolving this issue without anything to be done to OS as suggested in one of the post in this forum.

What O/S? It sounds like you've hit a kernel parameter limit with regards to the number of open files.

chulett wrote:What O/S? It sounds like you've hit a kernel parameter limit with regards to the number of open files. ...

This is not related to th kernel limit for number of files:-

Even if I change the ulimit value then as well it gives the problem...as also said here: -

viewtopic.php?t=111077&highlight=File+descriptor+out

Your linked post shows your answer as well. Not sure what else anyone could add.

chulett wrote:Your linked post shows your answer as well. Not sure what else anyone could add. ...

Good news, IBM came back saying its a bug in Oracle Enterprise stage in DS8.1.

They sent the patch and it worked fine now.

Can you please advise the patch number?

ray.wurlod wrote:Can you please advise the patch number? ...

I'll definitely get back to you after confirming the patch number from my DS admin. I'll post it tomorrow EST.