I have a simple ds job: Dataset - lookup with a table - lookup with an other table - load in table.
The job remain in running ......without a reason!:-(
Could someone help me?
job still in running
Moderators: chulett, rschirm, roy
Loric,
you have just asked the car-equivalent question of "My car always stops running after I start it. Why?". How can we answer you question without knowing more about your problem.
a) there is always a reason.
b) Does it always "hang"
c) Does it process a number of rows or stop at the first row?
d) What stage is causing the problem? (you need to debug this yourself, but commenting out or replacing stages and adding "peek" stages)
There will be more questions depending on the answers, but it will provide a start.
you have just asked the car-equivalent question of "My car always stops running after I start it. Why?". How can we answer you question without knowing more about your problem.
a) there is always a reason.
b) Does it always "hang"
c) Does it process a number of rows or stop at the first row?
d) What stage is causing the problem? (you need to debug this yourself, but commenting out or replacing stages and adding "peek" stages)
There will be more questions depending on the answers, but it will provide a start.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Loric,
Make sure if there any locks on database tables.
If you are on Oracle just check the following with your DBA
HTH
--Rich
Make sure if there any locks on database tables.
If you are on Oracle just check the following with your DBA
Code: Select all
1. select * from v$lock where type = 'TM'
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST
-------- -------- ---------- -- ---------- ---------- ---------- ----------
CTIME BLOCK
---------- ----------
803EECF0 803EED04 53 TM 251183 0 3 0
2423 0
2. select object_name from dba_objects where object_id = 251183
--Rich