Abnormal End error while running a DS load job into Oracle

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

Do you pass any special characters through the fields?
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

So what you are saying is that there were 3 columns in the source data file that did not map into the target OCI stage.

How did you "remove" them? These columns need to be defined in the Sequential stage else it gives warning messages. You would have to suppress row truncation messages. What exactly did you do?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
rrcreddy4
Participant
Posts: 21
Joined: Sat Jan 29, 2005 10:11 pm

Post by rrcreddy4 »

Hi,

Thanks for your patience and replies.

I looked at my data fields closely and found that I have almost 5 variables with a varchar(255) size. Out of this 5, only 3 were getting populated and remianing 2 were set to @null in the DS. What I did, its a waste process by the DS when I have null values, rather I can have oracle take care of that at table level.

So I removed those 2 fields from my jobs and now the job runs fine. I kept the triggers,condition based uniue constraint as it is.

Now, can any one explain me if this looks fine.

RC
Post Reply