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
Program "DSD.UVClose"
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
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.
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India