The log begins with the usual messages about "Starting job...", "Environment variables...", "Active stage starting...", and "Write caching disabled", then it shows the error message:
Code: Select all
ODS_ExportSystemCastanet..ins_CASTANET_CHECK.insert: ds_uvput() - Write failed for record id '3211'
The very next message is just the usual "Attempting to Cleanup...", followed by the "...aborted" and then "...finished" messages. None of these provide any other specific info; they are just the generic messages.
The table is used no where but in this job and it serves to eliminate duplicate entries (sometimes the source produces more than one entry with the same key value) so it has only a single column (the key) and it is defined as Integer 10.
Code: Select all
DICT ODS_CASTANET_CHECK 11:44:11am 30 Oct 2009 Page 1
Type &
Field......... Field. Field........ Conversion.. Column......... Output Depth &
Name.......... Number Definition... Code........ Heading........ Format Assoc..
@ID D 0 ODS_CASTANET_CH 10L S
ECK
id D 0 MD0 id 10R S
@ PH id ID.SUP
@KEY PH id
The job is part of a sequence that is scheduled to run every hour from a batch file that executes "dsjob -run <project> <sequence>". The error happens only occasionally but when it does, I can immediately turn around, run it with the same parameters (pulled from the log) and it succeeds.