I have a job which is extracting data using OCI9 stage. After a few lookups [ Hash AND OCI ], the data is written to a Seq file.
For the last few days, the job seems to hang after processing a number of rows [ this number is not fixed].
Today, the job has been runnning for a while but the last line in the Seq. file is incomplete. The job is still running.
How is this explained? How can I resolve the issue?
Thanks
The job is hanging??
Moderators: chulett, rschirm, roy
Have you checked to see if the UNIX process(es) behind the jobs are still running? If you execute a stop command to the job does it stop (after a couple of minutes)? Do the log files after a stop and after a reset show any additional information? How large is the output file (2Gb?)
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
I had a similar problem on release 7.1. I don't know if it's the same problem or not. Here's my work around. Open Job Properties and see if Row Buffering is enabled. If it is and Interprocess is enabled you have to click on In Process, then click on the RowBuffering check box to turn it off. Apparently, there's another bug in disabling row buffering, that if you just uncheck the RowBuffering check box without clicking In Process first, it won't disable RowBuffering completely and the problem still appears.
Good Luck,
Tony
Good Luck,
Tony
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom