Fatal error in Server job due to ds_uvput()

DS4DRIVER · Post by **DS4DRIVER** » Thu Jul 19, 2007 12:33 pm

While DataStage server was running, the job aborted due to the following Fatal error. The job reads a Sequential file and writes to a Hash file.

stg_SUMRY_HST_ins: ds_uvput() - Write failed for record id 'FNAA3070B
1
-70001
2007-07-03
9999-01-01 00:00:00.000000'

The job successfully finished in the next run.
Is there any expaination why the job failed the first time?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 19, 2007 3:16 pm

Possibly beause there was a null in one of the key columns attempted to be written to the hashed file.

Hashed file, not hash file.

DS4DRIVER · Post by **DS4DRIVER** » Thu Jul 19, 2007 3:46 pm

That is not the case.
There are 5 Key fields in the Hash file. All the fields have Values as per the Record.

ds_uvput() - Write failed for record id 'FNAA3070B
1
-70001
2007-07-03
9999-01-01 00:00:00.000000'

DS4DRIVER · Post by **DS4DRIVER** » Thu Jul 19, 2007 3:47 pm

Also, the next time the job ran with teh same source file, it finished successfully.

chulett · Post by **chulett** » Thu Jul 19, 2007 6:21 pm

Does another run of the 'same file' guarantee that the exact same records will be written to the hashed file? If that's the case and no job changes were made between runs, is there any chance that you ran out of disk space where that hashed file lives on the first run?