Um blog sobre nada

Um conjunto de inutilidades que podem vir a ser úteis

DQS Error after CU Upgrade

Posted by Diego em Setembro 20, 2013


    I recently installed SQL Server 2012 SP1 CU5 upgrade and that made DQS to stop working.  I was getting a message saying:

 

An error occurred in the Microsoft .NET Framework while trying to load assembly id 65581.

 

    That redirected me to this Microsoft page (http://technet.microsoft.com/en-us/library/jj125366.aspx) that explained that after you have installed a SQL Server update (patch, hotfix, or cumulative update) on a previously configured DQS instance, you might have to upgrade the DQS databases schema by running the DQSInstaller.exe file with the upgrade command line parameter by running:


dqsinstaller.exe -upgrade

 

Which presented me with the message

 

DQS version is up to date, no upgrade scripts will be run.

 

After this, the error message changed to: 


A new version of .NET or Data Quality Services was installed on this machine. In order to continue to work with DQS please run ‘DqsInstaller.exe -upgrade’.

 

Obliviously that didn’t fix the issue so I had to recompile the .NET assemblies by running:

dqsinstaller-UpgradeDlls.

Uma resposta to “DQS Error after CU Upgrade”

  1. Diego said

    FYI, the correct command is:
    dqsinstaller -upgradedlls

    it has to be lowercase

Deixe uma Resposta

Preencha os seus detalhes abaixo ou clique num ícone para iniciar sessão:

Logótipo da WordPress.com

Está a comentar usando a sua conta WordPress.com Terminar Sessão / Alterar )

Imagem do Twitter

Está a comentar usando a sua conta Twitter Terminar Sessão / Alterar )

Facebook photo

Está a comentar usando a sua conta Facebook Terminar Sessão / Alterar )

Google+ photo

Está a comentar usando a sua conta Google+ Terminar Sessão / Alterar )

Connecting to %s