SYSERR4104 when upgrading MDS 2012 database file from version to version RRS feed

  • Question

  • Hello,
    we had an intranet SQL Server 2012 SP2 MDS installation (version 11.0.5058.0 with database version hosting 3 production MDS models, one of them having 3 versions.

    Currently our IT department installed SQLserver2012-KB3045319 and after that installation MDS database needed schema update. The update via Master Data Services Configuration Manager failed with this error

    Microsoft.MasterDataServices.Configuration.ConfigurationException: SYSERR4104|The multi-part identifier "V1.VersionFlag_ID" could not be bound. ---> System.Data.SqlClient.SqlException: SYSERR4104|The multi-part identifier "V1.VersionFlag_ID" could not be bound.
       at Microsoft.MasterDataServices.Configuration.DatabaseUtilities.UpgradeMasterDataServicesDatabase(SqlConnection connection, String databaseName, Collection`1& businessRuleExclusionWarnings)
       at Microsoft.MasterDataServices.Configuration.Commands.UpdateMasterDataServicesDatabase.InternalProcessRecord()
       at Microsoft.MasterDataServices.Configuration.Commands.ConfigurationCmdlet.ProcessRecord()
       at System.Management.Automation.CommandProcessor.ProcessRecord()
       --- End of inner exception stack trace ---
       at Microsoft.MasterDataServices.Configuration.InstanceManager.Execute(Command command)
       at Microsoft.MasterDataServices.Configuration.InstanceManager.UpgradeMasterDataServicesDatabase(DatabaseServerInformation serverInformation, DatabaseInformation databaseInformation)
       at Microsoft.MasterDataServices.Configuration.UI.ServerManagement.ConfigurationAdministration.UpgradeDatabase(DatabaseInformation databaseInformation)
       at Microsoft.MasterDataServices.Configuration.UI.MdsDatabase.UpgradeDatabase()

    As a workaround to solve this error I created a new MDS database on this SQL Server (version 11.0.5613.0; database version and imported packages of the 3 production models via MDSModelDeploy.

    The 2 models without versions could be imported without error.

    No version specific package of the model with 3 versions (VERSION_2013, VERSION_2014 and VERSION_2015) and 3 versionflags (2013, 2014 and Current (=always pointing at the latest version)) could not be imported. I got always the error

    MDSModelDeploy operation failed. ...
    The "ModelName" model cannot be deployed.
    An error occurred while processing message request type 'ExportViewCreateRequest'. See exception details for more information.
    Package deploymenr failed with 1 errors.
    The multi-part identifier "V1.VersionFlag_ID" could not be bound.

    I searched the package XML file for "V1.VersionFlag_ID" but could not find the string.

    Many THX for any help solving this problem.

    By the way: what is the best-practice for COMPLETE export (all versions) and COMPLETE deployment (all versions) of models with versions? I could not find any instructions for doing this.

    Rainer Kroos

    Tuesday, September 22, 2015 10:46 AM