Microsoft KB Archive/263873

= BUG: DTS Processing Failure May Not Remove Shadow Files =

Article ID: 263873

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server OLAP Services

-



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.

Additional query words: error The process cannot access file because being used by another

Keywords: kbbug kbpending KB263873

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.