I have a job which extracts data from a OCI stage and then does a few lookups and writes the data to Three OCI stages.
The job just hangs when I run it , the log stops at "Write caching disabled". I think something is wrong with target OCI stages . I hooked up 3 sequential files in the place of the OCI stages and the job runs great. But when I give OCI stages as targets... The job keeps running ... No rows being processed. Please Suggest what coud be wrong, does Write caching disabled mean anything?
JOB with OCI stages hangs :Write caching disabled
Moderators: chulett, rschirm, roy
JOB with OCI stages hangs :Write caching disabled
Be nice to nerds. Chances are you’ll end up working for one.
--- Bill Gates
--- Bill Gates
For testing, replace the two target OCI stages with flat files and keep one OCI stage. If that runs fine then add another OCI stage and run again. If that runs too then I guess its the number of open connections that is allowed by your id, which is causing the problem. I think.....
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: