I am running a job whose design is as follows:
Seq_File ---> Transformer ---> Stored_Procedure_Stage(ORACLE) ---> Transformer2 ---> Seq_File2
The job is aborting with the following message:
I know that the reason for this as the maximum number of processes have been reached, Oracle will not process any new requests. Thats fine.Item #: 2528
Event ID: 2527
Timestamp: 2006-11-09 11:55:23
Type: Warning
User Name: ncsmetl
Message: SP_Get_OM_Param,0: Error: ORA-00020: maximum number of processes (%s) exceeded
Item #: 2529
Event ID: 2528
Timestamp: 2006-11-09 11:55:23
Type: Fatal
User Name: ncsmetl
Message: SP_Get_OM_Param,0: Error occurred in call to ORPHCallActivePluginInitialize().
Item #: 2530
Event ID: 2529
Timestamp: 2006-11-09 11:55:23
Type: Fatal
User Name: ncsmetl
Message: SP_Get_OM_Param,0: The runLocally() of the operator failed.
But my requirement is how do i catch these kind of errors and make the job finish normally or with warnings. Also, please throw some light on the basic functionality of ORPHCallActivePluginInitialize() and why the call failed here. I searched through the archives but couldnt find an appropriate answer. Thanks in advance.
Regards,