SIGINT Error

IBMDS4KK · Post by **IBMDS4KK** » Mon Dec 09, 2013 12:55 am

Dear DS Mates,

Job Design : Oracle Connector => Oracle Connector

Description : Data is fetching from Source table and updating the Target table based on key column.

Cause : After running 7 to 8 hrs, suddenly we are getting SIGINT Error.

Example : We have 100 records from source after updating 75 records on 3 nodes, we are getting this error.

Please suggest the best solution to get rid of this error because it was affecting the business. Thanks!

chulett · Post by **chulett** » Mon Dec 09, 2013 8:26 am

Is this coming from the O/S or from Oracle? Please post the entire error message. This is an "Interrupt Signal" which can (for example) come from a kill command. I'd be curious if the stage has been returning records during the 7 or 8 hours or if it was still 'gathering' information and thus looking like an idle process?

IBMDS4KK · Post by **IBMDS4KK** » Tue Dec 10, 2013 4:31 am

Hi Chulett,

1) I am not sure whether the fatal error is coming from O/S or Oracle. Please tell me by the seeing the below error :

'main_program: ORCHESTRATE step execution terminating due to SIGINT'

2) Please check the below Log Image :

[Edit: non-functional image removed, see Craig's post below - Andy]

Kindly suggest me how to get rid of this error. Thanks!

ray.wurlod · Post by **ray.wurlod** » Tue Dec 10, 2013 4:48 am

Cease killing processes or issuing Stop requests to jobs.

chulett · Post by **chulett** » Tue Dec 10, 2013 8:22 am

ps. You can't link to an image on your local PC. While you can see it in your post, no-one else can. Either post the log contents (text) or upload the image to any of the free file sharing sites out there and then link to that.