Datastage termination error

karry450 · Post by **karry450** » Thu Jul 30, 2009 2:53 am

Hi friends,

Im trying to load a dimensional table from ORACLE TO ORACLE.

Here in MY Targey key field is a Database sequence generated, have taken ORACLE stage and written seq.next val as custom sql.

This is actually working fine in DS7.5.2.

We have migrated the same job to DS8.1 , the job doesnt work here.

And the error is
Abnormal termination of DataStage.
Fault type is 6. Layer type is BASIC run machine.
Fault occurred in BASIC program DSP.Open at address 574.

But when I replace the database sequence with this function KeyMgtGetNextValueConcurrent(<COLUMN_NAME>) my job is working fine.

can anyone help me regarding this.

Thanks
Karthik

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 30, 2009 3:37 am

Does the user with which you are connecting to Oracle via DataStage have select priviledges on the sequence ?

karry450 · Post by **karry450** » Thu Jul 30, 2009 4:31 am

Sainath.Srinivasan wrote:Does the user with which you are connecting to Oracle via DataStage have select priviledges on the sequence ? ...

Yeah I am the user and I have select privilages on the Datastage Sequence.

Thanks

chulett · Post by **chulett** » Thu Jul 30, 2009 5:36 am

What other errors are logged? I'm assuming that's your "From previous run..." message after you reset it, yes?

karry450 · Post by **karry450** » Thu Jul 30, 2009 7:55 am

[quote="chulett"]What other errors are logged? I'm assuming that's your "From previous run..." message after you reset it, yes? ...[/quote

my job is getting struck when it reaches SELECT SEQ.NEXTVAL even after 1 hour time it doesnt show up anything. So I forcibly stopped it and reset it then that the error I have posted is the message after resetting the job.

thanks

chulett · Post by **chulett** » Thu Jul 30, 2009 8:00 am

Any idea what "getting stuck" actually means? An issue on the database side I would assume. Has your DBA monitored the job to see what happens when it runs?