WRITE failure another Phantom Error
Posted: Thu Oct 02, 2003 10:22 am
Hello Everbody
I have 2 jobs
1.Batch4ShiftLoadDBFtoCSV
2.DbfExt4thShiftMergeCsv
The 1st job is a Controller job which just runs the second job in a loop with different parameter value everytime.
These jobs have been working fine so far but we just upgraded the ETL
server to Server Ver 6.0.1 from 6.0 and with this upgrade we also had NLS enabled.
After the upgrade we have started having problem with the above job.
The job has started behaving erratically sometimes it's fails with the
first parameter and sometimes it runs for 10 or 15 parameters and then
aborts the error message that I get is given below.
I tried looking at the RT_BP1143 directory at line number 180 (Screen shot
below)
174 IF STAGECOM.TRACE.STATS THEN CALL $PERF.END(-13)
175
176 PUT.Pin%%V0S61P2
177 IF NOT(Pin%%V0S61P2.REJECTEDCODE) THEN
178 REJECTED = @FALSE
179 END ELSE
180 Pin%%V0S61P2.REJECTED = @TRUE
181 END
182 END
183 ELSE
184 Pin%%V0S61P2.REJECTED = @TRUE
185 Pin%%V0S61P2.REJECTEDCODE = 0
186 END
187
188
189 UPDATE.COUNT -= 1
----------------------------------------------------------------------
Error Messages :
1. From Batch4ShiftLoadDBFtoCSV
Batch4ShiftLoadDBFtoCSV..JobControl (fatal error from JobControl): Job
Failed: DbfExt4thShiftMergeCsv
When I reset the Job
From previous run
DataStage Job 1140 Phantom 28341
Job Aborted after Fatal Error logged.
Program "DSD.WriteLog": Line 238, Abort.
Attempting to Cleanup after ABORT raised in stage
Batch4ShiftLoadDBFtoCSV..JobControl
2. DbfExt4thShiftMergeCsv
DataStage Job 1143 Phantom 3016
Program "DSD.Startup": Line 180, WRITE failure.
Attempting to Cleanup after ABORT raised in stage
DbfExt4thShiftMergeCsv..XfmBKFLC
DataStage Phantom Aborting with @ABORT.CODE = 3
----------------------------------------------------------------------
Does anybody know what DSD.Startup and DSD.WriteLog does ?
Please help the dummy.
Thanks
I have 2 jobs
1.Batch4ShiftLoadDBFtoCSV
2.DbfExt4thShiftMergeCsv
The 1st job is a Controller job which just runs the second job in a loop with different parameter value everytime.
These jobs have been working fine so far but we just upgraded the ETL
server to Server Ver 6.0.1 from 6.0 and with this upgrade we also had NLS enabled.
After the upgrade we have started having problem with the above job.
The job has started behaving erratically sometimes it's fails with the
first parameter and sometimes it runs for 10 or 15 parameters and then
aborts the error message that I get is given below.
I tried looking at the RT_BP1143 directory at line number 180 (Screen shot
below)
174 IF STAGECOM.TRACE.STATS THEN CALL $PERF.END(-13)
175
176 PUT.Pin%%V0S61P2
177 IF NOT(Pin%%V0S61P2.REJECTEDCODE) THEN
178 REJECTED = @FALSE
179 END ELSE
180 Pin%%V0S61P2.REJECTED = @TRUE
181 END
182 END
183 ELSE
184 Pin%%V0S61P2.REJECTED = @TRUE
185 Pin%%V0S61P2.REJECTEDCODE = 0
186 END
187
188
189 UPDATE.COUNT -= 1
----------------------------------------------------------------------
Error Messages :
1. From Batch4ShiftLoadDBFtoCSV
Batch4ShiftLoadDBFtoCSV..JobControl (fatal error from JobControl): Job
Failed: DbfExt4thShiftMergeCsv
When I reset the Job
From previous run
DataStage Job 1140 Phantom 28341
Job Aborted after Fatal Error logged.
Program "DSD.WriteLog": Line 238, Abort.
Attempting to Cleanup after ABORT raised in stage
Batch4ShiftLoadDBFtoCSV..JobControl
2. DbfExt4thShiftMergeCsv
DataStage Job 1143 Phantom 3016
Program "DSD.Startup": Line 180, WRITE failure.
Attempting to Cleanup after ABORT raised in stage
DbfExt4thShiftMergeCsv..XfmBKFLC
DataStage Phantom Aborting with @ABORT.CODE = 3
----------------------------------------------------------------------
Does anybody know what DSD.Startup and DSD.WriteLog does ?
Please help the dummy.
Thanks