Problem with Oracle Enterprise stage in DS 8.1

parag.s.27 · Post by **parag.s.27** » Tue Jan 05, 2010 3:23 pm

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: -

Code: Select all

main_program: Fatal Error: File descriptor out of range in fd_set (requested 1,413, limit 1,023

.

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.

chulett · Post by **chulett** » Tue Jan 05, 2010 3:48 pm

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

parag.s.27 · Post by **parag.s.27** » Tue Jan 05, 2010 6:50 pm

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

chulett · Post by **chulett** » Wed Jan 06, 2010 9:18 am

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

parag.s.27 · Post by **parag.s.27** » Thu Jan 21, 2010 8:31 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jan 21, 2010 3:53 pm

Can you please advise the patch number?

parag.s.27 · Post by **parag.s.27** » Thu Jan 21, 2010 6:02 pm

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.