Home Dashboard Directory Help
Search

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


Status: 

Active


3
0
Sign in
to vote
Type: Bug
ID: 802565
Opened: 9/27/2013 4:34:48 AM
Access Restriction: Public
1
Workaround(s)
view
6
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 ansonee on 5/5/2014 at 9:24 AM
I am having the EXACT same issue with DQS:

[5/5/2014 10:44:23 AM] Dropping Service Broker Services.
[5/5/2014 10:44:23 AM] Dropping Service Broker Queues.
[5/5/2014 10:44:23 AM] Dropping Service Broker Contracts.
[5/5/2014 10:44:23 AM] Dropping Service Broker Messages.
[5/5/2014 10:44:23 AM] Completed - Service Broker objects dropped.
[5/5/2014 10:44:23 AM] Changed database context to 'DQS_MAIN'.
[5/5/2014 10:44:23 AM]
[5/5/2014 10:44:23 AM] --> Registering Assemblies
[5/5/2014 10:44:23 AM]
[5/5/2014 10:44:23 AM]     * Register .NET dependency assemblies
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.ma
nagement, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, pro
cessorarchitecture=msil.' you are registering is not fully tested in the SQL Ser
ver hosted environment and is not supported. In the future, if you upgrade or se
rvice this assembly or the .NET Framework, your CLR integration routine may stop
working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.co
nfiguration.install, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11
d50a3a, processorarchitecture=msil.' you are registering is not fully tested in
the SQL Server hosted environment and is not supported. In the future, if you up
grade or service this assembly or the .NET Framework, your CLR integration routi
ne may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.ru
ntime.serialization, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c5619
34e089, processorarchitecture=msil.' you are registering is not fully tested in
the SQL Server hosted environment and is not supported. In the future, if you up
grade or service this assembly or the .NET Framework, your CLR integration routi
ne may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'smdiagnos
tics, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, process
orarchitecture=msil.' you are registering is not fully tested in the SQL Server
hosted environment and is not supported. In the future, if you upgrade or servic
e this assembly or the .NET Framework, your CLR integration routine may stop wor
king. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.wi
ndows.forms, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089,
processorarchitecture=msil.' you are registering is not fully tested in the SQL
Server hosted environment and is not supported. In the future, if you upgrade or
service this assembly or the .NET Framework, your CLR integration routine may s
top working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.dr
awing, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, proces
sorarchitecture=msil.' you are registering is not fully tested in the SQL Server
hosted environment and is not supported. In the future, if you upgrade or servi
ce this assembly or the .NET Framework, your CLR integration routine may stop wo
rking. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'accessibi
lity, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, process
orarchitecture=msil.' you are registering is not fully tested in the SQL Server
hosted environment and is not supported. In the future, if you upgrade or servic
e this assembly or the .NET Framework, your CLR integration routine may stop wor
king. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'system.ru
ntime.serialization.formatters.soap, version=4.0.0.0, culture=neutral, publickey
token=b03f5f7f11d50a3a, processorarchitecture=msil.' you are registering is not
fully tested in the SQL Server hosted environment and is not supported. In the f
uture, if you upgrade or service this assembly or the .NET Framework, your CLR i
ntegration routine may stop working. Please refer SQL Server Books Online for mo
re details.
[5/5/2014 10:44:42 AM] Warning: The Microsoft .NET Framework assembly 'microsoft
.jscript, version=10.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, pr
ocessorarchitecture=msil.' you are registering is not fully tested in the SQL Se
rver hosted environment and is not supported. In the future, if you upgrade or s
ervice this assembly or the .NET Framework, your CLR integration routine may sto
p working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:43 AM] Warning: The Microsoft .NET Framework assembly 'system.ma
nagement.instrumentation, version=4.0.0.0, culture=neutral, publickeytoken=b77a5
c561934e089, processorarchitecture=msil.' you are registering is not fully teste
d in the SQL Server hosted environment and is not supported. In the future, if y
ou upgrade or service this assembly or the .NET Framework, your CLR integration
routine may stop working. Please refer SQL Server Books Online for more details.

[5/5/2014 10:44:44 AM] Warning: The Microsoft .NET Framework assembly 'system.me
ssaging, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, proc
essorarchitecture=msil.' you are registering is not fully tested in the SQL Serv
er hosted environment and is not supported. In the future, if you upgrade or ser
vice this assembly or the .NET Framework, your CLR integration routine may stop
working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:44:44 AM] Warning: The Microsoft .NET Framework assembly 'system.di
rectoryservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a
3a, processorarchitecture=msil.' you are registering is not fully tested in the
SQL Server hosted environment and is not supported. In the future, if you upgrad
e or service this assembly or the .NET Framework, your CLR integration routine m
ay stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.en
terpriseservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50
a3a, processorarchitecture=amd64.' you are registering is not fully tested in th
e SQL Server hosted environment and is not supported. In the future, if you upgr
ade or service this assembly or the .NET Framework, your CLR integration routine
may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.ru
ntime.remoting, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e08
9, processorarchitecture=msil.' you are registering is not fully tested in the S
QL Server hosted environment and is not supported. In the future, if you upgrade
or service this assembly or the .NET Framework, your CLR integration routine ma
y stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.we
b, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processora
rchitecture=amd64.' you are registering is not fully tested in the SQL Server ho
sted environment and is not supported. In the future, if you upgrade or service
this assembly or the .NET Framework, your CLR integration routine may stop worki
ng. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'microsoft
.build.framework, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50
a3a, processorarchitecture=msil.' you are registering is not fully tested in the
SQL Server hosted environment and is not supported. In the future, if you upgra
de or service this assembly or the .NET Framework, your CLR integration routine
may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.xa
ml, version=4.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089, processor
architecture=msil.' you are registering is not fully tested in the SQL Server ho
sted environment and is not supported. In the future, if you upgrade or service
this assembly or the .NET Framework, your CLR integration routine may stop worki
ng. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.ru
ntime.caching, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a
, processorarchitecture=msil.' you are registering is not fully tested in the SQ
L Server hosted environment and is not supported. In the future, if you upgrade
or service this assembly or the .NET Framework, your CLR integration routine may
stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'microsoft
.build.utilities.v4.0, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f
11d50a3a, processorarchitecture=msil.' you are registering is not fully tested i
n the SQL Server hosted environment and is not supported. In the future, if you
upgrade or service this assembly or the .NET Framework, your CLR integration rou
tine may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.di
rectoryservices.protocols, version=4.0.0.0, culture=neutral, publickeytoken=b03f
5f7f11d50a3a, processorarchitecture=msil.' you are registering is not fully test
ed in the SQL Server hosted environment and is not supported. In the future, if
you upgrade or service this assembly or the .NET Framework, your CLR integration
routine may stop working. Please refer SQL Server Books Online for more details
.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.de
sign, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, process
orarchitecture=msil.' you are registering is not fully tested in the SQL Server
hosted environment and is not supported. In the future, if you upgrade or servic
e this assembly or the .NET Framework, your CLR integration routine may stop wor
king. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.dr
awing.design, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a,
processorarchitecture=msil.' you are registering is not fully tested in the SQL
Server hosted environment and is not supported. In the future, if you upgrade o
r service this assembly or the .NET Framework, your CLR integration routine may
stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.we
b.regularexpressions, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f1
1d50a3a, processorarchitecture=msil.' you are registering is not fully tested in
the SQL Server hosted environment and is not supported. In the future, if you u
pgrade or service this assembly or the .NET Framework, your CLR integration rout
ine may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'microsoft
.build.tasks.v4.0, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d5
0a3a, processorarchitecture=msil.' you are registering is not fully tested in th
e SQL Server hosted environment and is not supported. In the future, if you upgr
ade or service this assembly or the .NET Framework, your CLR integration routine
may stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM] Warning: The Microsoft .NET Framework assembly 'system.se
rviceprocess, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a,
processorarchitecture=msil.' you are registering is not fully tested in the SQL
Server hosted environment and is not supported. In the future, if you upgrade o
r service this assembly or the .NET Framework, your CLR integration routine may
stop working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:07 AM]     * Register Microsoft.Practices assemblies
[5/5/2014 10:45:12 AM] Warning: The Microsoft .NET Framework assembly 'microsoft
.csharp, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, proc
essorarchitecture=msil.' you are registering is not fully tested in the SQL Serv
er hosted environment and is not supported. In the future, if you upgrade or ser
vice this assembly or the .NET Framework, your CLR integration routine may stop
working. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:12 AM] Warning: The Microsoft .NET Framework assembly 'system.dy
namic, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, proces
sorarchitecture=msil.' you are registering is not fully tested in the SQL Server
hosted environment and is not supported. In the future, if you upgrade or servi
ce this assembly or the .NET Framework, your CLR integration routine may stop wo
rking. Please refer SQL Server Books Online for more details.
[5/5/2014 10:45:12 AM]
[5/5/2014 10:45:12 AM]     * Register DQ assemblies
[5/5/2014 10:45:15 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
infra, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, proce
ssorarchitecture=msil.' you are registering is not fully tested in SQL Server ho
sted environment.
[5/5/2014 10:45:17 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
core, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, proces
sorarchitecture=msil.' you are registering is not fully tested in SQL Server hos
ted environment.
[5/5/2014 10:45:18 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
dataservice, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91,
processorarchitecture=msil.' you are registering is not fully tested in SQL Ser
ver hosted environment.
[5/5/2014 10:45:19 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
referencedata, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc9
1, processorarchitecture=msil.' you are registering is not fully tested in SQL S
erver hosted environment.
[5/5/2014 10:45:20 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
index, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, proce
ssorarchitecture=msil.' you are registering is not fully tested in SQL Server ho
sted environment.
[5/5/2014 10:45:21 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
associationrules, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080
cc91, processorarchitecture=msil.' you are registering is not fully tested in SQ
L Server hosted environment.
[5/5/2014 10:45:22 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
datavalueservice, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080
cc91, processorarchitecture=msil.' you are registering is not fully tested in SQ
L Server hosted environment.
[5/5/2014 10:45:23 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
domainrules, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91,
processorarchitecture=msil.' you are registering is not fully tested in SQL Ser
ver hosted environment.
[5/5/2014 10:45:24 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
cleansing, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, p
rocessorarchitecture=msil.' you are registering is not fully tested in SQL Serve
r hosted environment.
[5/5/2014 10:45:25 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
association, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91,
processorarchitecture=msil.' you are registering is not fully tested in SQL Ser
ver hosted environment.
[5/5/2014 10:45:26 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
flow, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, proces
sorarchitecture=msil.' you are registering is not fully tested in SQL Server hos
ted environment.
[5/5/2014 10:45:27 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs.
matching, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, pr
ocessorarchitecture=msil.' you are registering is not fully tested in SQL Server
hosted environment.
[5/5/2014 10:45:29 AM] Warning: The SQL Server client assembly 'microsoft.ssdqs,
version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorar
chitecture=msil.' you are registering is not fully tested in SQL Server hosted e
nvironment.
[5/5/2014 10:45:29 AM] Resource file was not copied
[5/5/2014 10:45:29 AM] Changed database context to 'master'.
[5/5/2014 10:45:29 AM] Changed database context to 'DQS_MAIN'.
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM]     * Clear the Code Member Table A_CODE_MEMBER.
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM] (0 rows affected)
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM]     * Clear the Code Group Table A_CODE_GROUP.
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM] (0 rows affected)
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM]     * Register assemblies T-SQL executable objects
[5/5/2014 10:45:29 AM]         - Creating assemblies T-SQL registeration stored
procedure.
[5/5/2014 10:45:29 AM]
[5/5/2014 10:45:29 AM]     * Creating the internal_core schema
[5/5/2014 10:45:29 AM]         - Registering Microsoft.Ssdqs.Infra T-SQL executa
ble objects.
[5/5/2014 10:45:34 AM] HResult 0x197A, Level 16, State 1
[5/5/2014 10:45:34 AM] A .NET Framework error occurred during execution of user-
defined routine or aggregate "RegisterAssembly":
[5/5/2014 10:45:34 AM] System.Data.SqlClient.SqlException: Invalid object name '
A_DB_VERSION'.
[5/5/2014 10:45:34 AM] System.Data.SqlClient.SqlException:
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlConnection.OnError(SqlExce
ption exception, Boolean breakConnection, Action`1 wrapCloseInAction)
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNext
Result(Boolean ignoreNonFatalMessages)
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlDataReaderSmi.NextResult()

[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderSm
i(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
[5/5/2014 10:45:34 AM]
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(C
ommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Strin
g method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean
asyncWrite)
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(C
ommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Strin
g method)
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlCommand.ExecuteReader(Comm
andBehavior behavior, String method)
[5/5/2014 10:45:34 AM]    at System.Data.SqlClient.SqlCommand.ExecuteReader()
[5/5/2014 10:45:34 AM]    at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand
()
[5/5/2014 10:45:34 AM]    at Microsoft.Ssdqs.Infra.Database.DBUtility.GetDataQua
lityAssemblyDBVersion(IDBAccess dbAccess)
[5/5/2014 10:45:34 AM]    at Microsoft.Ssdqs.Core.Startup.ServerInit.Init(Boolea
n isDuringSqlServerStartup)
[5/5/2014 10:45:34 AM] .
[5/5/2014 10:45:34 AM]
[5/5/2014 10:45:34 AM]
[5/5/2014 10:45:34 AM] ERROR - An error occured, check message above
[5/5/2014 10:45:34 AM]
[5/5/2014 10:45:34 AM] Script process returned unexpected exit code: '1'.
[5/5/2014 10:45:34 AM] Action 'Register data quality assemblies and stored proce
dures' finished with errors, aborting installation.
[5/5/2014 10:45:34 AM] Starting installation rollback...
[5/5/2014 10:45:35 AM] Installation rollback completed successfully.
[5/5/2014 10:45:35 AM] DQS Installer finished with errors. Please see installati
on log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVERTAB\MSSQ
L\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)


And it looks like there hasn't been any movement on this issue since December of 2013...

Does someone from Microsoft plan on looking into this and releasing a fix?!?!?
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.
Posted by Constantini82 on 5/11/2014 at 11:43 PM
UNINSTALL UPDATES