Is there a limit on Oracle Stages

Ramona Reed · Post by **Ramona Reed** » Tue Oct 02, 2007 9:03 am

I posted by mistake in the Server Editioin Forum.

I would like to know if anyone knows whether there is a limit on the number of Oracle stages you can have in one job. I have a job that has 18 Oracle stages on it, and I am getting a very weird error that doesn't indicate anything. The error is: main_program: Could not check all operators because of previous error(s) but there is not any errors in the log except that message.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 02, 2007 1:58 pm

There is no limit on the number of stages in a DataStage job from a technical perspective (though from a maintainability perspective there ought to be).

There may, however, be a limit on the number of simultaneous connections that can be made to your Oracle instance. Enlist the help of your Oracle DBA to determine whether any such limit is being encountered.