DSXchange

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!

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?

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!

Cease killing processes or issuing Stop requests to jobs.

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.