Job hungs up when trying to update table
Posted: Fri May 01, 2015 9:01 am
Hi,
I am copying,
ID(Primary KEY),
EMP_ID,
NAME,
ADDRESS
from Table EMP to a DATASET.
Then I am doing a lookup on DATASET from a different file with columns EMP_ID,NAME,ADDRESS. When ever the EMP_ID matches, I am sending ID,NAME,ADDRESS to an Oracle Connector and trying to update NAME and ADDRESS based on ID in EMP_ID table. But the table hungs up when ever I do this.
I tried running it Sequential and by Partioning data. It doesn't work either.
I copied this data to a temp table and tried to update EMP_ID by using MERGE query. It worked. I am curious why the UPDATE query is not working.
(My DBA says, the table is going into locked stage when ever I run the Job. And many sessions are open on that table. We tried deleting all sessions and blocks. Still the same. None else is accessing the table except me)
I am copying,
ID(Primary KEY),
EMP_ID,
NAME,
ADDRESS
from Table EMP to a DATASET.
Then I am doing a lookup on DATASET from a different file with columns EMP_ID,NAME,ADDRESS. When ever the EMP_ID matches, I am sending ID,NAME,ADDRESS to an Oracle Connector and trying to update NAME and ADDRESS based on ID in EMP_ID table. But the table hungs up when ever I do this.
I tried running it Sequential and by Partioning data. It doesn't work either.
I copied this data to a temp table and tried to update EMP_ID by using MERGE query. It worked. I am curious why the UPDATE query is not working.
(My DBA says, the table is going into locked stage when ever I run the Job. And many sessions are open on that table. We tried deleting all sessions and blocks. Still the same. None else is accessing the table except me)