Job Hanging.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Mon Dec 11, 2006 8:28 pm
- Location: India
Job Hanging.
Hi,
I have a simple job, its just extract an load,
but when i run the job it hangs.
no log is recorded, after some time the job batch gets aborted,
i have no idea why this happens.
Please guide me through to solve the problem.
Rbk.
I have a simple job, its just extract an load,
but when i run the job it hangs.
no log is recorded, after some time the job batch gets aborted,
i have no idea why this happens.
Please guide me through to solve the problem.
Rbk.
Remove the 'load' part, make the job write to /dev/null. If it still hangs, you know it is an issue on your extract, perhaps a very lenghty select. If it runs, then the issue is probably on your load stage.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Remove the 'load' part, make the job write to /dev/null. If it still hangs, you know it is an issue on your extract, perhaps a very lenghty select. If it runs, then the issue is probably on your load stage.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.
Some more details on the stage types involved in the source and target would make solving the problem a lot easier as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I've been getting network timeouts all day here - but I don't remember trying to re-post this one. Too late to delete the duplicate now as well. I suppose that this is one way to rack up some serious points.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 8
- Joined: Mon Dec 11, 2006 8:28 pm
- Location: India
-
- Participant
- Posts: 8
- Joined: Mon Dec 11, 2006 8:28 pm
- Location: India
Put a constraint of "1=2" onto the transform stage output writing to your Oracle stage and run the job. Better yet, make a copy of your job and keep only your source stage and write the result to a sequential file at /dev/null to see how long your select takes to execute in the real job, not just the view data.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
In your 2nd job are the input Seq and the output Seq files different?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
I doubt there is a bug - this is base functionality used successfully in hundreds of sites.
Try pointing your output Seq file to '/dev/null'
Try pointing your output Seq file to '/dev/null'
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>