Program "DSD.RUN": Line 597, Unable to unlink the
Posted: Tue Mar 29, 2011 10:12 am
While running the sequence, the sequence completes all steps correctly including the last step Notification activity but it aborts at the end. When i looked at the sequence log after reset, it shows the following error statements
From previous run
DataStage Job 1508 Phantom 7972
Program "DSD.RUN": Line 597, Unable to unlink the operating system file "DSD.RUN_35919_15794".
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
Program "DSD.RUN": Line 2202, Variable previously undefined. Zero length string used.
[14232] Done : DSD.RUN Pre_ProcessingJob.INPUT_RIABCI 0/0/1/0/0
[8508] Done : DSD.RUN lod_RIBLSC_CHECK_DELETES_SCHEDULE_BLEND_RECIPE_HEADER. 0/0/1/0/0
[9872] Done : DSD.RUN ext_RIABCI_Parse_RECIPE_BPC. 0/0/1/0/0
[8984] Done : DSD.RUN sqr_RIABCI_RECIPE_RESTAGE. 0/0/1/0/0
[13440] Done : DSD.RUN sqr_RIABCI_DELETE_OLD_RECIPE_ODS.sqr_RIABCI_DELETE_OLD_RECIPE_ODS 0/0/1/0/0
[852] Done : DSD.RUN sqr_RIABCI_RECIPE_STAGE. 0/0/1/0/0
[7348] Done : DSD.RUN sqr_RIABCI_RECIPE_ODS. 0/0/1/0/0
[11324] Done : DSD.RUN sqr_RIBLSC_LOAD_DATA_WAREHOUSE.BCI 0/0/1/0/0
[13816] Done : DSD.RUN Post_ProcessingJob.ARCHIVE_RIABCI 0/0/1/0/0
[10000] Done : DSD.RUN lod_RIBLSC_AFTER_CHECK_DELETES_SCHEDULE_BLEND_RECIPE_HEADER. 0/0/1/0/0
Program "DSSendMail": Line 482, Unable to unlink the operating system file "sendmail_sqr_RIABCI_BCI_PUBLISH_MAIN36409_7_7972.bat".
Program "DSSendMail": Line 482, DELETE failure.
Attempting to Cleanup after ABORT raised in stage sqr_RIABCI_BCI_PUBLISH_MAIN..JobControl
DataStage Phantom Aborting with @ABORT.CODE = 3
The same code is run in development which is on different server & it works fine without any errors/warnings. Any thoughts ?