Oracle Stage load problem
Moderators: chulett, rschirm, roy
Oracle Stage load problem
Hi all
i have a problem when loading data to oracle stage enterprise in write method : Load and write mode : append.
i have a job to insert data from source to oracle for staging,
ODBC >> Oracle Stage
the problem is the job cannot finish, when i view the job, it's all stuck when loading data to oracle.
when i change the the write method to upsert the job running perfectly. did miss something where configure datastage ?
currently i using ds 8,0,1 fp 2 and windows 2003 sp2.
Thanks for any reply
Hardi
i have a problem when loading data to oracle stage enterprise in write method : Load and write mode : append.
i have a job to insert data from source to oracle for staging,
ODBC >> Oracle Stage
the problem is the job cannot finish, when i view the job, it's all stuck when loading data to oracle.
when i change the the write method to upsert the job running perfectly. did miss something where configure datastage ?
currently i using ds 8,0,1 fp 2 and windows 2003 sp2.
Thanks for any reply
Hardi
-
- Participant
- Posts: 15
- Joined: Sat Nov 14, 2009 3:38 am
Hi all,
Yes,,, even i'm facing the same issue. But, in my case, i'm receiving 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.
Yes,,, even i'm facing the same issue. But, in my case, i'm receiving 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,
Ragavendra Dinesh C
Ragavendra Dinesh C
The "LOAD" method requires exclusive access, unlike the "upsert" mode, talk to your DBA to check on who is holding locks to the table when you try a bulk load.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 18
- Joined: Fri Jan 04, 2008 5:28 am
- Location: Bangalore