SQL Server 2012 SP2 upgrade -- MDS model dissappearing RRS feed

  • Question

  • hi all, I was wondering if anyone has encountered issues w/ MDS after doing an upgrade to SP2 (SQLServer 2012) and subsequently upgrading the MDS internal database.

    My problem (and it appears this issue is replicatable on various systems) is that a particular model has dissappeared, at least from the GUI.  Cache refresh does not do the trick reviving the model.

    Furthermore, when I am trying to run an MDSModelDeploy deployupdate to restore the model, I get "the xxx model cannot be updated.  There is no match for a model with the same name and MUID".

    I also tried deployclone but get  "a clone of the xxx model cannot be deployed"  An error occurred while processing message request type "MetadataCloneRequest. See exception details for more information. Package deployment failed with 1 errors.  The user does not have permission or the object ID is not valid."

    Any thoughts on how this can be resolved?

    It seems to me that every time MS releases a CU or a SP, we run chiefly into MDS issues.  Is this something to be expected, is there a specific MDS upgrade path that one needs to employ?  

    Also, we're getting at times"the MDSERR400038|Unpublished business rules exist. Apply the business rules before running Business Rules or Validation again"  ... and I know that's something funky because otherwise the processes run successfully many times a day, without any metadata changes.

    thx a big bunch for any thoughts  -- it seems since the original MDS team has left the shop, MS cannot really get it straights, with the CU's and SP's, for this module (MDS).  


    Tuesday, July 15, 2014 11:10 PM


  • Check if this is related with this issue with Service Pack 2 for SQL Server 2012:


    "There is a regression bug in SQL Server 2012 and SQL Server 2014 where, if you rebuild an index online in parallel, and you also experience a fatal error such as a lock timeout, you could experience data loss or corruption"

    Thursday, August 7, 2014 2:31 PM