Home Dashboard Directory Help
Search

DQSInstaller.exe crashes with parameter -?: Unhandled Exception System.TypeLoadException by Wolfgang Bierl


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 802565
Opened: 9/27/2013 4:34:48 AM
Access Restriction: Public
0
Workaround(s)
view
5
User(s) can reproduce this bug

Description

I open a dos box and go to C:\Program Files\Microsoft SQL Server\MSSQL11.SQL08R2DEV\MSSQL\Binn
When I start DQSInstaller.exe -? it lists the Syntax, than crashes.

Dos box shows (of course in germand, i translated it for you convenience):
Unhandled Exception: System.TypeLoadException: The Type
"Microsoft.Ssdgs.Infra.Utilities.Sqm.SqmStatisticsUtility in Assembly "Microsoft.ssdqs.Infra, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" could not be loaded
in
Microsodt.Ssdqs.DqsInstaller.Logic.Installer.GetSqmStatistics()
Microsodt.Ssdqs.DqsInstaller.Logic.Installer.Main(String[] args)

The Server runs in VMware ESXi, 5.1.0, 1157734
Details
Sign in to post a comment.
Posted by Kalyan Ch on 12/27/2013 at 12:16 AM
Have the same issue.
Posted the entire log here

[12/27/2013 1:40:14 PM] Resource file was not copied
[12/27/2013 1:40:15 PM] Changed database context to 'master'.
[12/27/2013 1:40:15 PM] Changed database context to 'DQS_MAIN'.
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM]     * Clear the Code Member Table A_CODE_MEMBER.
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM] (0 rows affected)
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM]     * Clear the Code Group Table A_CODE_GROUP.
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM] (0 rows affected)
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM]     * Register assemblies T-SQL executable objects
[12/27/2013 1:40:15 PM]         - Creating assemblies T-SQL registeration stored
procedure.
[12/27/2013 1:40:15 PM]
[12/27/2013 1:40:15 PM]     * Creating the internal_core schema
[12/27/2013 1:40:15 PM]         - Registering Microsoft.Ssdqs.Infra T-SQL execut
able objects.

[12/27/2013 1:40:17 PM] HResult 0x197A, Level 16, State 1
[12/27/2013 1:40:17 PM] A .NET Framework error occurred during execution of user
-defined routine or aggregate "RegisterAssembly":
[12/27/2013 1:40:17 PM] System.Data.SqlClient.SqlException: Invalid object name
'A_DB_VERSION'.
[12/27/2013 1:40:17 PM] System.Data.SqlClient.SqlException:
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlConnection.OnError(SqlExc
eption exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNex
tResult(Boolean ignoreNonFatalMessages)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlDataReaderSmi.NextResult(
)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderS
mi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(
CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stri
ng method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
asyncWrite)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(
CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stri
ng method)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlCommand.ExecuteReader(Com
mandBehavior behavior, String method)
[12/27/2013 1:40:17 PM]    at System.Data.SqlClient.SqlCommand.ExecuteReader()
[12/27/2013 1:40:17 PM]    at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecComman
d()
[12/27/2013 1:40:17 PM]
[12/27/2013 1:40:17 PM]    at Microsoft.Ssdqs.Infra.Database.DBUtility.GetDataQu
alityAssemblyDBVersion(IDBAccess dbAccess)
[12/27/2013 1:40:17 PM]    at Microsoft.Ssdqs.Core.Startup.ServerInit.Init(Boole
an isDuringSqlServerStartup)
[12/27/2013 1:40:17 PM] .
[12/27/2013 1:40:17 PM]
[12/27/2013 1:40:17 PM]
[12/27/2013 1:40:17 PM] ERROR - An error occured, check message above
[12/27/2013 1:40:17 PM]
[12/27/2013 1:40:17 PM] Script process returned unexpected exit code: '1'.
[12/27/2013 1:40:17 PM] Action 'Register data quality assemblies and stored proc
edures' finished with errors, aborting installation.
[12/27/2013 1:40:17 PM] Starting installation rollback...
[12/27/2013 1:40:18 PM] Installation rollback completed successfully.
[12/27/2013 1:40:18 PM] DQS Installer finished with errors. Please see installat
ion log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\
Log\DQS_install.log

Unhandled Exception: System.TypeLoadException: Could not load type 'Microsoft.Ss
dqs.Infra.Utilities.Sqm.SqmStatisticsUtility' from assembly 'Microsoft.Ssdqs.Inf
ra, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.
at Microsoft.Ssdqs.DqsInstaller.Logic.Installer.GetSqmStatistics()
at Microsoft.Ssdqs.DqsInstaller.Logic.Installer.Main(String[] args)
Posted by SQLWaldorf on 12/10/2013 at 1:53 PM
I have the same problem, but on a Developer edition (no edition change): DQS was working fine, then installed latest CU for SQL Server, also got the lasted windows updates for .Net 4.5. After this, the DQS client told me to run dqsInstaller -update. This ran for a while, asked if it was OK to drop my knowledge bases (yes), and then failed. I filtered some lines in the DQSInstall.log file:
...
[10/12/2013 17:55:04]     * Creating the internal_core schema
[10/12/2013 17:55:04]         - Registering Microsoft.Ssdqs.Infra T-SQL executable objects.
[10/12/2013 17:55:11] HResult 0x197A, Level 16, State 1
[10/12/2013 17:55:11] A .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly":
[10/12/2013 17:55:11] System.Data.SqlClient.SqlException: Invalid object name 'A_DB_VERSION'.
[10/12/2013 17:55:11] System.Data.SqlClient.SqlException:
[10/12/2013 17:55:11]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[10/12/2013 17:55:11]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
...
Since then DQSInstaller fails on any switch I tried.
Posted by Microsoft on 10/3/2013 at 12:03 PM
Hello Wolfgang.
Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.
-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.