Page 1 of 1

DataStage Phantom

Posted: Mon Mar 07, 2005 8:22 am
by subramanya
I am getting the following error..

DataStage Job 174 Phantom 1916
Program "DSD.StageRun": Line 571, Attempted WRITE with NULL record ID
DataStage Phantom Finished


What is meant by DataStage Phantom?

Thnx
Subbu..

Posted: Mon Mar 07, 2005 8:31 am
by kcbland
Your job tried to write a row to a hash file with a primary key value of NULL. Phantom is the name of the process under which jobs are controlled. Basically, a phantom process manages running the job in the background after the DS engine daemon starts the job. Any unanticipated error conditions are trapped as screenoutput, and the phantom process reports those error messages into your job log at the job completion time.

Your problem is that you either have a data error or an allowable null condition. You should either put something in place to resolve the null reason, or put a constraint on the output link to prevent writing rows with a NULL value in the primary key.

Thanx

Posted: Wed Mar 09, 2005 2:39 am
by subramanya
Thanx for the info..

Subbu