Oracle Stage load problem

[h4rd1]

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

[ragavendradineshdsx]

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.

[ArndW]

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.

[h4rd1]

Thanks for the reply.

What kind of privileges that the user need ?


Thanks


Hardi

[chulett]

Depends on what the user needs to do. Chat with your DBA.

[vjonnala1516]

hi, look like table got locked..please verify that..

[h4rd1]

i consult with the dba and check all the session that connect when the job start. there is no any session that lock the table.

here is the screen shot of the job and also the log that i got from Director.

Thanks

Hardi

[chulett]

You're probably locking yourself. Does it run fine on one node?

ps. Your image link is no good.

[h4rd1]

i run it like this

[h4rd1]

heloo


can any one help me with this ?

Thanks


Hardi

[chulett]

Answer the node question.