When does a job hang in RUN state

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Jul 10, 2007 9:11 am

Hi,

why a job do not come into finished state (in Datastage director log file )while loading the data into data base from a sequential file.

I mean why it still shows that it is in running state....for a long time...
it gets hanged in that state(running)

thanku

thumsup9 · Post by **thumsup9** » Tue Jul 10, 2007 10:15 am

There could be several reasons why a job hangs. Do you have all your metadata defined correctly, have all the necessary insert/update permissions on the target table, Is your data violating any unique key constraints.

I would try to insert one record in the target table manually using SQL and see what error message it throws.

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Jul 10, 2007 10:32 am

yes will try with SQL query...

But i would like to let u know that the error shown in directory is

"main_program: ORCHESTRATE step execution terminating due to SIGINT"

When i tried to pause the job.

thanku.

ArndW · Post by **ArndW** » Tue Jul 10, 2007 5:25 pm

G SHIVARANJANI wrote:...When i tried to pause the job...

DataStage has no facility for pausing jobs. I don't know what you did, but it caused the job to abort.

JoshGeorge · Post by **JoshGeorge** » Tue Jul 10, 2007 8:18 pm

SIGINT error appeared because you tried to interrupt a process. ie. you might have tried to stop the job (pause ?

)

G SHIVARANJANI wrote: But i would like to let u know that the error shown in directory is
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
When i tried to pause the job.