Dataset gets deleted in the shared path as BEING_DELETED_FIL

sreekanth.re · Post by **sreekanth.re** » Tue Feb 03, 2009 9:46 pm

Hi,

We are using Datastage Ver 8. While developing a fact job, due to the complexity in the job, we have splitted it into two jobs. The fact table is partitioned based on the FREIGHT_SHIPMENT_DT to capture the records for the last two years. In the sequencor job, before executing the job, the table is truncated and that the job loads into the swap table, from which it is loaded to the mm table and then to the base fact table.

During the first run when the dataset is not created the job executes fine, but during the second run, the dataset that is placed in the shared path gets deleted with the following error message in the director log.

Sets/FTS_FREIGHT_FCT.ds,0: Could not delete partition 0 of D:/Data/FTS/Dev/Data Sets/FTS_FREIGHT_FCT.ds .
filesystem related error

Would like to get your guidance and suggestion on the same to handle this issue.

Thanks in advance.

chulett · Post by **chulett** » Tue Feb 03, 2009 10:16 pm

A search for "Could not delete partition 0" turned up only one other hit so it's not a common thing we've seen before. The "filesystem related" part implies a problem with the disk subsystem where the file ended up... did you have an admin check that out?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 03, 2009 11:43 pm

Let me get this straight.
Run 1 - the Data Set was not created.
Run 2 - the Data Set could not be deleted.

Is that right?

Probably the Data Set stage is set to overwrite, and the "error" is spurious. What does your official support provider have to say?

Is the error fatal, or does Run 2 finish anyway?