Page 1 of 1

ODBC Stage with an Upsert option

Posted: Wed May 26, 2010 1:16 am
by Sivatkv
Hi,

We are facing some hang issues with ODBC stage. We have chosen the upsert option in this stage. But, the job goes to a hang state with this option being selected. We need the upsert option to be selected in the stage.

Could any one please let us know the resolution for this?

Thanks,
Siva

Posted: Wed May 26, 2010 4:03 am
by ray.wurlod
My guess is locking contention in the target database. Get your DBA to monitor locks.

Posted: Wed May 26, 2010 6:40 am
by chulett
I would guess so as well. Does this happen if you run the job on a single node?