Phantom 11204

parsi_cnu · Post by **parsi_cnu** » Sun Mar 04, 2007 10:10 am

What is that error mean?

I got this error when i ran this job

Phantom 11204
Program "DSD.StageRun": Line 544, Attempted WRITE with NULL record ID

ray.wurlod · Post by **ray.wurlod** » Sun Mar 04, 2007 10:30 am

Your job tried to write a record to a hashed file or some other data target with a primary key, but provided NULL as the primary key value.

This is not permitted.

Make sure no NULL gets this far through your job design.

gateleys · Post by **gateleys** » Mon Mar 05, 2007 9:07 am

During the initial extract phase, or anytime before you write to the hashed file, constrain your stream input to rows with Not Null keys. Use the expression Not(IsNull(inLink.KeyColumn)) to ensure null key values do not pass through.

gateleys