Page 1 of 1

Phantom 11204

Posted: Sun Mar 04, 2007 10:10 am
by parsi_cnu
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

Posted: Sun Mar 04, 2007 10:30 am
by ray.wurlod
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.

Posted: Mon Mar 05, 2007 9:07 am
by gateleys
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