data stage error sigint

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

data stage error sigint

Post by pavan_test »

Hi All,

The data stage jobs abort with error message;
main_program: ORCHESTRATE step execution terminating due to SIGINT

can anyone please suggest me where Do i find for more info about SIGINT and why is it causing the etl job to abort

Thanks
Mark
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

Are there any other warning or fatals in the job log other than that entry? Even go as far as checking every other entry in there, regardless of type.

What's the job design?
Last edited by miwinter on Fri Aug 28, 2009 8:43 am, edited 2 times in total.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

data stage error sigint

Post by pavan_test »

The job ran successfully before (atleast 5 times).

The job consists of Oracle (10g) DB as source and reference (normal lookup) and lookup and if match found deletes the data from different DB table.


is this error caused due to any space issues?

Thanks
Mark
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

answer the first question, is there any other warning or errors in job log?
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
miwinter
Participant
Posts: 396
Joined: Thu Jun 22, 2006 7:00 am
Location: England, UK

Post by miwinter »

Check all is well on the database side i.e. manually connect and run the query. Also, as before, are there any other indications of a problem in the log? Does the job monitor show a particular stage in unknown or aborted state?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

data stage error sigint

Post by pavan_test »

There is no enough table space in DB after little research

Thanks for all the suggestions.
Post Reply