datastage ETL JOB remains in Processing state for hours

sharathkedika · Post by **sharathkedika** » Mon May 05, 2008 7:53 am

I have a job which pulls the data from staging and inserts in to 4 target tables with SQL action "insert new or update existing rows".

When I try to run the job , it never gone to success. Just all the links color chages to blue(processing) and that's it.

I have only 3 rows in the staging. I am able view these rows using the Oracle stage (view data button). I am not getting why the job is failing to pull the data from the staging table.

I have checked the log file (no clue).

In the Debugger window (there is a message called "out of context").

Please help me to fix this issue.

ArndW · Post by **ArndW** » Mon May 05, 2008 8:29 am

Have you spoken with your DBA to have him/her check for locked groups or records? This would explain the job just hanging around without doing any processing.

The debugger is explained in the documentation, the out-of-context message is perfectly OK in your situation.

ray.wurlod · Post by **ray.wurlod** » Mon May 05, 2008 3:51 pm

In the Debugger use "Step to Next Link" to follow the progress of a row through the job. The row is only in context if the active stage to which its link is connected is currently executing.