DataBase Already Exists Metadata Error

• ktflash

  Default port

  Points: 1400

  More actions

  February 16, 2024 at 8:19 am

  #4379581

  Ahoy,

  Seems like i renamed my SSAS Database accidently and only changed the CAPS (Old_NAME) to (Old_Name).

  Now my problem is that i cant deploy the Database with the Old_NAME anymore.

  I have tried serveral things but it always tells me the metadata manager says that the database already exists.

  Problem is the solutions i found only tell me to alter the existing database but that does not work, it is not even visible anymore.

  I can still deploy/delete Old_Name unlimited amounts of time but  i can not deploy or delete Old_NAME.

  I tried the following:

  • Check if there is another Database with the same ID

    • SSMS Settings
    • DMV:

      • SELECT [CATALOG_NAME],Database_ID

        FROM $system.DBSCHEMA_CATALOGS)

  • Restart Engine
  • Delete existing Databases from Server
  • Check the folder where the SSAS Cube Files are stored for Old_NAME, no files there
  • Attempt to drop the Database using XML/MDX ("Database does not exist") as opposed to the opposite message already exists when i try to create it
  • Deploy using SSAS Wizard and Visual Studio

  Anyone Ideas?

  Maybe Meta Data Manager has some file i can edit and delete the id from manually?

  Thanks

   

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

• ktflash

  Default port

  Points: 1400

  More actions

  February 16, 2024 at 4:07 pm

  #4379804

  Well restarting the entire server seems to have done the trick...

  I want to be the very best
  Like no one ever was

  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help