JOB with OCI stages hangs :Write caching disabled

ady · Post by **ady** » Thu Nov 15, 2007 1:25 pm

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?

DSguru2B · Post by **DSguru2B** » Thu Nov 15, 2007 1:29 pm

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.....

ady · Post by **ady** » Thu Nov 15, 2007 2:43 pm

Thanks DSguru

A hashed file in the job had the wrong metadata.... correcting that solved the issue, I dont see the connection between the two but looks like everything good now !

ray.wurlod · Post by **ray.wurlod** » Thu Nov 15, 2007 4:31 pm

Perhaps the "error" was in your diagnosis - after all "write caching disabed" is a message related to Hashed File stage, not to OCI stage.