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:
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: