Program "DSD.UVClose"

sumitgulati · Post by **sumitgulati** » Tue Dec 16, 2003 10:24 pm

Hi All,

One of my DataStage Jobs is giving the following warning message:

DataStage Job 9 Phantom 2652
Program "DSD.UVClose": Line 56, Attempted WRITE with NULL record ID
DataStage Phantom Finished

I am not able to figure out what exactly it means.

Kindly let me know the solution.

Thanks
Sumit

kcbland · Post by **kcbland** » Tue Dec 16, 2003 10:32 pm

You have an output link trying to write a row into a hash file where the value of the primary key is NULL.

You need to investigate why, and at a minimum put a constraint on that output link to disallow NULL primary key rows. These messages will slow down your job, as well as fill up the job log.

sumitgulati · Post by **sumitgulati** » Tue Dec 16, 2003 10:47 pm

Hi kcbland,

Thanks for the reply. I have a hash file in the Job used as a lookup. Nowhere in the Job we are populating any hash file. Do you see any other reason for such a warning message.

Thanks,
Sumit

kcbland · Post by **kcbland** » Tue Dec 16, 2003 10:52 pm

Zoink, I wasn't paying enough attention.

There's something internally that tried to write a NULL row somewhere. Odds are it is an internal job file (either the CONFIG, STATUS, or LOG files). There's probably nothing to do about it.

Is it happening every single run, or sporadically, and on other jobs too? If it's repeatable, you may want to contact tech support. You're on 7, and most people aren't, so you're blazing the trail for bugs.

This one is a common message, I've seen it for years on multiple platforms and releases.

sumitgulati · Post by **sumitgulati** » Tue Dec 16, 2003 11:02 pm

Hi kcbland,

Thanks a lot. It was actually NULL value population in Hash file error only. Initially I did not notice the Hash File Load happening in the job.

Thanks a lot. Its resolved now.

Regards,
Sumit