Wednesday, October 23, 2013

Error while Deploying (Errors in the metadata manager) - SSAS Cube


Error   21        Errors in the metadata manager. The dimension with ID of 'Dim Date', Name of 'Dim Date' referenced by the 'DFSX DW' cube, does not exist. Errors in the metadata manager. An error occurred when loading the DFSX DW cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008\OLAP\Data\Analysis Services Project2.0.db\DFSX DW.10.cub.xml'.      


To resolve this issue


1. Stop the SSAS service.


2.       Go to the particular location that shown in the error message: something like this,
C:\Program Files\Microsoft SQL Server\MSAS10_50.SQL2008\OLAP\Data
Delete the particular folder and the file (DFSX.0.db folder and the DFSX DW.10.cub.xml file)


3.       Start the SSAS service again, then redeploy. This will make deployment success.


Cheers!



2 comments:

  1. Interesting blog, here a lot of valuable information is available, it is very useful information Msbi online training

    ReplyDelete
  2. Interesting blog, here a lot of valuable information is available, it is very useful information Msbi online training

    ReplyDelete