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
Datastage termination error
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
[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
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