Errors using Merge Stage but improvement with file set stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nivas
Participant
Posts: 117
Joined: Sun Mar 21, 2004 4:40 pm

Errors using Merge Stage but improvement with file set stage

Post by nivas »

Hi

I am trying to merge two table using Merge stage on one column.
In the properties Tab I provided value for KeyProperty=ACC_NBR and
Sort order is default.
I am getting the following error
But when I tried by putting FileSet Stage after Merge Stage the error has gone.
Could any body help me please to fix this error asap.



main_program: Sort key "ACCT_NBR" no longer exists in dataset schema. It will be dropped from the inserted sortmerge collector

main_program: There are no sort keys in the dataset schema. No parallel sortmerge operator will be inserted.

subArgs={asc}}},1: Failure during execution of operator logic
subArgs={asc}}},1: Output 0 produced 0 records
subArgs={asc}}},1: Fatal Error: Fork failed: Resource temporarily unavailable


thanks
Nivas
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

The input dataset does not have ACCT_NBR.

Check your metadata in the job.
Post Reply