none
Cube deployment failing saying "Errors in the metadata manager. The database with the name of 'xyz' already exists in the 'abc' server"

    Question

  • Hello All,

    I am very new to SSAS. Yesterday I have created a SSAS DB with one cube. Now I want to add one more cube to the DB. So I have created the SSAS DB solution using "Import Analysis Service Database" wizard. Then I have added two dimensions by refreshing the data source view and created a cube on top of them.

    But when I try to deploy the cube the deployment is failing giving the following error.

    "Errors in the metadata manager. The database with the name of 'xyz' already exists in the 'abc' server"

    I just want to add few dimensions and one cube to the existing SSAS DB and I did this many times before successfully. But this time, I don't know what went wrong.

    I even tried to change the options like "Deploy changes only", "Deploy all" etc. But nothing worked.

    Any help regarding the same is highly appreciated

    Monday, August 01, 2011 8:48 AM

Answers

All replies

  • Did you Change Processing Option to "Full processing"?
    http://uk.linkedin.com/in/ramjaddu
    Monday, August 01, 2011 10:32 AM
  • Are you trying to deploy this solution to a different name than your existing database? Or did you try to rename the previous database before deploying the new version with the new cube? If so you may be hitting this issue http://geekswithblogs.net/darrengosbell/archive/2008/09/28/ssas-deploying-to-renamed-databases.aspx 


    http://darren.gosbell.com - please mark correct answers
    • Proposed as answer by Jerry NeeModerator Wednesday, August 03, 2011 7:26 AM
    • Marked as answer by Suman85 Thursday, August 04, 2011 9:44 AM
    Tuesday, August 02, 2011 5:33 AM
  • I'm guessing there's another database with the same name however the ID is different that the one you're attempting to deploy.

    • Proposed as answer by Jerry NeeModerator Wednesday, August 03, 2011 7:16 AM
    • Marked as answer by Suman85 Thursday, August 04, 2011 9:44 AM
    Tuesday, August 02, 2011 6:34 PM
  • @JesseO: I have generated the solution from XYZ db and made some changes and i want to deploy it in the same server with the same name (i.e., XYZ) . So if am not wrong the going to deploy DB should also retain the same ID (i.e., XYZ's ID). If not how can i change/ensure the DB ID which is going to be deploy is same as the Database ID from which the solution is generated.

     

    Thursday, August 04, 2011 9:19 AM
  • @Darren Gosbell: Thanks Darren the link you have shared answered all my questions. Perfect reply :).

    Actaully the problem is the DB from which i have generated solution (i.e., XYZ) having ID other than "XYZ". But as mentioned in the link, the BIDS give the ID same as the TargetDB. Because of this the scenario mentioned by JesseO arose and the deployment failed

     

    Thursday, August 04, 2011 9:44 AM