Page 1 of 1

Exceptions when invoking RTI Job

Posted: Thu Aug 18, 2005 2:53 am
by jasonzhou
I developed a parallel job which contained four stages: RTI Input Stage,DB2/UDB API Stage, Join Stage and RTI Output stage. The RTI Input Stage contains two columns(c1,c2) and was orgnized as array when deploying the RTI Jobs as WebService. DB2/UDB API Stage connect to table A ,which contains three columns(ID,c1,c2,c3), column 'ID' is the primary key. And column c1 and c2 were used to do join operation with the RTI Input Stage. The RTI Output Stage contains three Columns: c1,c2 and c3.

After I deploying the RTI Jobs as a WebService,I saw that there is an instance of the RTI job was runing in the DataStage Director ,so I developed a java program to invoke it, but I got a RTIExcetpion. which contains a message:"Job parallelGetLocation is not running. Check the RTIAgent error log for errors.". When I turn to the DataStage Director, the instance of the RTI Job was aborted and another instance was begin to running, the log of the aborted RTI Job instance contains the following message:"main_program:ORCHESTRATE step execution terminating due to SIGINT" .
And the log file RTIAgent.log contains the following message:
2005-08-19 03:56:00,564 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - OperationHandler registered. Type: Server Class: com.ascentialsoftware.rti.agent.handler.datastage.DataStageHandler
2005-08-19 03:56:00,587 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - OperationHandler registered. Type: PX Class: com.ascentialsoftware.rti.agent.handler.datastage.DataStageHandler
2005-08-19 03:56:00,592 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - OperationHandler registered. Type: Echo Class: com.ascentialsoftware.rti.agent.handler.echo.EchoHandler
2005-08-19 03:56:00,672 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - Query Handler registered: com.ascentialsoftware.rti.agent.query.datastage.DataStageQuery
2005-08-19 03:56:00,674 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - Query Handler registered: com.ascentialsoftware.rti.agent.query.datastage.PXQuery
2005-08-19 03:56:00,741 [main] INFO com.ascentialsoftware.rti.agent.RTIAgentImpl - Request Router ready for requests on port 2000
2005-08-19 04:03:30,238 [1124438173599_PRC] ERROR com.ascentialsoftware.rti.agent.handler.datastage.PipeReceiver - [1124438173599_PRC]error during call to init: dspipe_init(1): open(/tmp/ade.ETLConstruction.parallelGetLocation.1124438173599.RTI_Output) - No such file or directory

I have tried many times but received the same result, why ?

Thank you .

Posted: Fri Dec 09, 2005 1:31 am
by Kirtikumar
Have u tried executing the job as batch job first.

Use the folder stage and remove the RTI stages and try to execute it as batch job see if it works.

Posted: Fri Dec 09, 2005 5:41 pm
by ray.wurlod
Did you register[\i] the Web service?

Posted: Sat Dec 10, 2005 6:57 pm
by roy
Hi,
Take a look Here
IHTH,