Hi all,
We have a Parallel job designed which takes data from a SEQ file & puts into ORACLE table. I used Write option as "LOAD" and "TRUNCATE". but it failed giving me the below error:
main_program: Internal Error: (0):util/pathutils.C: 403: Unable to determine current working directory: Too many open files
Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are installed and on your PATH
later, i changed the Write option to "Upsert" and "Update then Insert" and now job is working fine. But, my requirement is to first truncate the table & load the fresh data.
Any help is appreciated.
Thanks & Regards,
Dinesh
main_program: Internal Error: (0):util/pathutils.C: 403
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Wed May 31, 2006 10:57 pm
- Location: Hyderabad
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 16
- Joined: Wed May 31, 2006 10:57 pm
- Location: Hyderabad
Hi all,
Thanks for your response. I tried with OPTIONS(DIRECT=FALSE,PARALLEL=TRUE) and OPTIONS(DIRECT=FALSE,PARALLEL=FALSE) as well. nothing worked out. I even tried with the Index rebuild/maintainence options, but no luck. I'm still getting the same error.
Any help on this regard is greatly appreciated.
Thanks & Regards,
Dinesh
Thanks for your response. I tried with OPTIONS(DIRECT=FALSE,PARALLEL=TRUE) and OPTIONS(DIRECT=FALSE,PARALLEL=FALSE) as well. nothing worked out. I even tried with the Index rebuild/maintainence options, but no luck. I'm still getting the same error.
Any help on this regard is greatly appreciated.
Thanks & Regards,
Dinesh
add the command "ulimit -a" as a before-job shell call, then see what your open files limit is displayed as at runtime.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>