Exceptions when invoking RTI Job

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
jasonzhou
Participant
Posts: 1
Joined: Thu Aug 18, 2005 2:35 am

Exceptions when invoking RTI Job

Post 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 .
Kirtikumar
Participant
Posts: 437
Joined: Fri Oct 15, 2004 6:13 am
Location: Pune, India

Post 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.
Regards,
S. Kirtikumar.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Did you register[\i] the Web service?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Take a look Here
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply