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

  • Question

  • Hello,
    we had an intranet SQL Server 2012 SP2 MDS installation (version 11.0.5058.0 with database version 11.2.0.0) 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 11.2.0.5) 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. ...
    Error:
    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

Answers