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)
Job hungs up when trying to update table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai
-
- Premium Member
- Posts: 32
- Joined: Wed Aug 20, 2014 11:17 am
-
- Participant
- Posts: 32
- Joined: Fri Nov 07, 2014 11:18 am
few things i would check are .
1. Are there duplicates coming from the source links. If so remove / manage them.
2. Work with DBA to identify the active query that is in execution when the job hangs.
3. Check the partitions of the job. i.e. test by running on a single node to see if that works.
4. My guess is since the table locked up , there might be multiple DML operations on that table at the same time.
1. Are there duplicates coming from the source links. If so remove / manage them.
2. Work with DBA to identify the active query that is in execution when the job hangs.
3. Check the partitions of the job. i.e. test by running on a single node to see if that works.
4. My guess is since the table locked up , there might be multiple DML operations on that table at the same time.
that's wierd ?
-
- Participant
- Posts: 50
- Joined: Fri Aug 29, 2014 1:32 pm
- Location: Mumbai