When processing Analysis Services cube from SSIS package I encountered the following error:
[Analysis Services Execute DDL Task] Error: Errors in the metadata manager. An error occurred when loading the Aggregation design from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\[Your database name].0.db\[Your Cube Name].cub\[Measure Group]det\AggreagationDesign-[Your Aggregation Name].agg.xml’
I tried to process and deploy the cube database through SQL Server Management Studio and BIDS, I was getting the same error over and over. I also tried to process and deploy just dimensions, one cube by another however nothing helped.
The problem: Corruption of the XML file that holds your cube definition due to conflicting dimension definition between the cube structure inside the project and the deployed cube database caused by changes in the underlying source schema.
- Stop the SQL Server Analysis Services service
- Rename or delete the folder where the cub.xml file resides. Folder starts with [Your database name].0.db
- Restart the SQL Server Analysis Services service
- Connect to your SQL Server Analysis Services instance via SSMS and delete the cube database.
- Deploy your cube database from your BIDS project
While deploying Analysis Services database you may also get the error
“The following system error occurred: No mapping between account names and security IDs was done”.
What can be an issue? Your BIDS project has a role defined in database that contains users or user groups not available in the deployment environment. To fix this errors simply delete and/or replace users or user groups with values that are correct in deployment domain.
The easiest way to do this is to highlight the users in a cube role definition and copy selection. Click the Add button and paste the copied list in the box. Click Check Names and the invalid name should be displayed in a prompt. If there are no invalid names in the current role, all names are verified.