DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
pavan_test



Group memberships:
Premium Members

Joined: 23 Sep 2005
Posts: 263

Points: 2177

Post Posted: Fri Aug 28, 2009 8:03 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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



Joined: 22 Jun 2006
Posts: 396
Location: England, UK
Points: 2856

Post Posted: Fri Aug 28, 2009 8:12 am Reply with quote    Back to top    

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?

_________________
Mark Winter
Nothing appeases a troubled mind more than good music

Last edited by miwinter on Fri Aug 28, 2009 8:43 am; edited 2 times in total
Rate this response:  
Not yet rated
pavan_test



Group memberships:
Premium Members

Joined: 23 Sep 2005
Posts: 263

Points: 2177

Post Posted: Fri Aug 28, 2009 8:24 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
priyadarshikunal



Group memberships:
Premium Members

Joined: 01 Mar 2007
Posts: 1735
Location: Troy, MI
Points: 9315

Post Posted: Fri Aug 28, 2009 8:44 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
miwinter
Participant



Joined: 22 Jun 2006
Posts: 396
Location: England, UK
Points: 2856

Post Posted: Fri Aug 28, 2009 8:44 am Reply with quote    Back to top    

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
Nothing appeases a troubled mind more than good music
Rate this response:  
Not yet rated
pavan_test



Group memberships:
Premium Members

Joined: 23 Sep 2005
Posts: 263

Points: 2177

Post Posted: Fri Aug 28, 2009 9:27 am Reply with quote    Back to top    

There is no enough table space in DB after little research

Thanks for all the suggestions.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours