Symptoms
When deploying or executing a Jet Data Manager project, the following error message is presented:
"Cannot show requested dialog.
Additional Information:
File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSASXX.MSSQLSERVER\OLAP\Data\{database name}.0.db\...."
Resolution
-
To correct this issue, you will first need to stop the 'SQL Server Analysis Services' service. To do this, in a run command type in 'services.msc' and click enter. Once opened, navigate to the service mentioned previously and then right-click and select 'Stop'
-
Once you've stopped the service, and ensured that neither the Jet Data Manager or SQL Server Management Studio are open, open up an Explorer window (Documents folder) and navigate to "C:\Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Data\".
-
Once you've navigated to your OLAP data folder, you will need to locate your OLAP database folder and corresponding XML file and delete them.
-
Once the '.db' folder and XML file is deleted, restart the 'SQL Server Analysis Services' service.
-
You can now open up the Jet Data Manager and 'Deploy and Execute' your OLAP server.
Comments