BUG: DTS Processing Failure May Not Remove Shadow Files (263873)

The information in this article applies to:

Microsoft SQL Server OLAP Services 7.0

This article was previously published under Q263873

BUG #: 9144 (plato7x)

SYMPTOMS

In some situations, when processing fails from Data Transformation Services (DTS), Decision Support Object (DSO) transactions are not rolled back properly and leave shadow files in the database folder. The OLAP Server process (msmdsrv) still has open file handles to the shadow files. If processing is performed again the processing may fail with the following error message:

File error[during Open operation] 'The process cannot access the file because it is being used by another process.'

WORKAROUND

You can work around this error message by stopping and re-starting the OLAP Server. Stopping and re-starting the OLAP server causes the OLAP Server process (msmdsrv) to close the open file handles and remove the shadow files. After you stop and re-start the OLAP server, processing can be started again.

STATUS

Microsoft has confirmed that this is a problem in SQL Server OLAP Services version 7.0.

MORE INFORMATION

Shadow files are temporary files that are created by OLAP Services during processing, which have 'S1 at the end of the filename. For example, if the name of cube is sales, you might see files such as Sales'S1.map, Sales'S1.data, and Sales'S1.index in the data folder for the database.

Modification Type:	Major	Last Reviewed:	10/16/2003
Keywords:	kbBug kbpending KB263873