none
DQSInstaller error

    Question

  • Hi.  I keep getting same error when I run the DQS Installer.exe.  The version number is the same as the SQL Server instance its under.  This is the error.

    A .Net framework error occurred during execution of user defined routine or aggregate "registerassembly"

    The strange thing is I can install it fine if I run the installer before i run the SSDT BI upgrade.  I know that sounds strange but I can't seem to install both.  If I install one I can't install the other.

    I removed all of the other instances on my machine.  I am using a default instance.

    Help please.

    Saturday, June 14, 2014 2:35 AM

All replies

  • Very first I think the DQSInstaller.exe is the not matching the version of the binaries. What is the current version of SQL ? may be your DQSInstaller bersion is 11.0.2100.60(RTM)... so try the below

    May be you have to install CU2 for sql 2012 to see if it solves your issue ?  http://support.microsoft.com/kb/2703275 It should patch the DQSInstaller to the latest version.

    Just go ahead and check your setup logsand see if the DQS CU1 has updates to this file ? In case if you have already installed SP1.

    • C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\<date>_<time>\SQL2012
    • sql_dq_Cpu64_1.log

    You should see text in there showing that it copied the DQSInstaller.exe binary file.


    Finally you have to come up with complete setup log so that its easy to find what went wrong, and where is the mistake is and more...


    Raju Rasagounder Sr MSSQL DBA

    Wednesday, June 25, 2014 10:22 PM
  • Or read this forum too...

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6780318c-387f-41e2-a464-420249ebdd8a/error-message-during-dqs-installation-of-dqsmain-portion-of-installer?forum=sqldataqualityservices


    Raju Rasagounder Sr MSSQL DBA

    Wednesday, June 25, 2014 10:22 PM
  • Thank you very much for the reply.  I tried to install CU2 but it says that the instance is already of an equal or higher version so it won't let me upgrade.  Here is the error log.  I would really appreciate the help.

                                                                                            

    [6/27/2014 9:42:42 PM] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log

    [6/27/2014 9:42:42 PM] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
    [6/27/2014 9:42:43 PM] Using instance: MSSQLSERVER, catalog: DQS.
    [6/27/2014 9:42:44 PM] Executing action: Validate collation argument.
    [6/27/2014 9:42:44 PM] Action 'Validate collation argument' finished successfully.
    [6/27/2014 9:42:44 PM] Executing action: Check whether system reboot is pending.
    [6/27/2014 9:42:44 PM] Action 'Check whether system reboot is pending' finished successfully.
    [6/27/2014 9:42:44 PM] Executing action: Create data quality event source.
    [6/27/2014 9:42:44 PM] Action 'Create data quality event source' finished successfully.
    [6/27/2014 9:42:44 PM] Executing action: Request Database Master Key password from user..
    [6/27/2014 9:43:09 PM] Action 'Request Database Master Key password from user.' finished successfully.
    [6/27/2014 9:43:09 PM] Executing action: Approve removal of data quality services previous schema.
    [6/27/2014 9:43:09 PM] Action 'Approve removal of data quality services previous schema' finished successfully.
    [6/27/2014 9:43:09 PM] Executing action: Load Installation Scripts.
    [6/27/2014 9:43:09 PM] Extracting script to: C:\Users\Craig\AppData\Local\Temp\cxxkwj01.tfu
    [6/27/2014 9:43:10 PM] Extracting script: db\create_core_db_objects.sql
    [6/27/2014 9:43:10 PM] Extracting script: db\create_logic_db_objects.sql
    [6/27/2014 9:43:10 PM] Extracting script: db\create_transient_db_objects.sql
    [6/27/2014 9:43:10 PM] Extracting script: db\static_data.sql
    [6/27/2014 9:43:10 PM] Extracting script: db\drop_dq_databases.sql
    [6/27/2014 9:43:10 PM] Extracting script: helper\DeleteSchemaDs.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\drop_all_assemblies.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\create_databases.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\drop_databases.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\drop_all_tables.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\drop_database_properties.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\master_create.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\master_recreate.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\register_assemblies.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\register_assemblies_tsql.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\register_dq_assemblies.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\create_service_broker_objects.sql
    [6/27/2014 9:43:10 PM] Extracting script: sql\drop_service_broker_objects.sql
    [6/27/2014 9:43:10 PM] Extracting script: recreate_schema.bat
    [6/27/2014 9:43:11 PM] Extracting script: drop_databases.cmd
    [6/27/2014 9:43:11 PM] Extracting script: register_dlls.cmd
    [6/27/2014 9:43:11 PM] Extracting script: unregister_dlls.cmd
    [6/27/2014 9:43:11 PM] Extracting script: assembly_paths_retail.txt
    [6/27/2014 9:43:11 PM] Extracting script: DQS_Data.dqs
    [6/27/2014 9:43:11 PM] Extracting script: DefaultKbs.xml
    [6/27/2014 9:43:11 PM] Total scripts extracted: 25
    [6/27/2014 9:43:11 PM] Action 'Load Installation Scripts' finished successfully.
    [6/27/2014 9:43:11 PM] Executing action: Create data quality schema.
    [6/27/2014 9:43:11 PM] Script: 'recreate_schema.bat PA01WCLEVIN02 DQS SQL_Latin1_General_CP1_CI_AS'
    [6/27/2014 9:43:11 PM] .  Trying to connect using Windows Authentication and db name...
    [6/27/2014 9:43:12 PM] Changed database context to 'master'.
    [6/27/2014 9:43:16 PM] Creating DQS databases (DQS_MAIN, DQS_PROJECTS, DQS_STAGING_DATA)...
    [6/27/2014 9:43:16 PM] Configuring DQS databases
    [6/27/2014 9:43:16 PM] Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
    [6/27/2014 9:43:16 PM] Creating Master Key for database DQS_MAIN...
    [6/27/2014 9:43:16 PM] Creating Module Signing Certificate for database DQS_MAIN...
    [6/27/2014 9:43:16 PM] Exporting Certificate from DQS_MAIN
    [6/27/2014 9:43:16 PM] Importing Certificate into DQS_PROJECTS
    [6/27/2014 9:43:16 PM] Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
    [6/27/2014 9:43:16 PM] Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install.
    [6/27/2014 9:43:16 PM] Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.
    [6/27/2014 9:43:16 PM] Creating DQS roles
    [6/27/2014 9:43:16 PM] Changed database context to 'DQS_STAGING_DATA'.
    [6/27/2014 9:43:16 PM]  
    [6/27/2014 9:43:16 PM]  --> Running File: drop_database_properties.sql
    [6/27/2014 9:43:16 PM] Changed database context to 'DQS_PROJECTS'.
    [6/27/2014 9:43:16 PM]  
    [6/27/2014 9:43:16 PM]  --> Drop all SSDQS Database objects and KB schemas
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all Symmetric Keys ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all Certificates ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all FK constraints ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all views ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all tables and synonyms ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all database triggers ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all stored procedures in Knowledge Base schemas ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all types in Knowledge Base schemas ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --[ Drop all Knowledge Base schemas ]
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --> Running File: drop_database_properties.sql
    [6/27/2014 9:43:17 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:43:17 PM]  
    [6/27/2014 9:43:17 PM]  --> Drop all SSDQS Database objects and KB schemas
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all Symmetric Keys ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all Certificates ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all FK constraints ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all views ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all tables and synonyms ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all database triggers ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all stored procedures in Knowledge Base schemas ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all types in Knowledge Base schemas ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --[ Drop all Knowledge Base schemas ]
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --> Running File: drop_database_properties.sql
    [6/27/2014 9:43:18 PM] Changed database context to 'DQS_STAGING_DATA'.
    [6/27/2014 9:43:18 PM] Changed database context to 'DQS_PROJECTS'.
    [6/27/2014 9:43:18 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --> Running File: create_core_db_objects.sql
    [6/27/2014 9:43:18 PM] ---[  Creating Certificates  ]---
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM] ---[  Creating Symmetric Keys  ]---
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM] ---[  Creating Tables  ]---
    [6/27/2014 9:43:18 PM] Creating Table:     A_TEST    
    [6/27/2014 9:43:18 PM] Creating Table:     A_TEST2    
    [6/27/2014 9:43:18 PM] Creating Table:     A_FLOW    
    [6/27/2014 9:43:18 PM] Creating Table:     A_FLOW_ANSWER    
    [6/27/2014 9:43:18 PM] Creating Table:     A_EXECUTION_UNIT 
    [6/27/2014 9:43:18 PM] Creating Table:     A_CODE_GROUP    
    [6/27/2014 9:43:18 PM] Creating Table:     A_CODE_MEMBER    
    [6/27/2014 9:43:18 PM] Creating Table:     A_CONFIGURATION    
    [6/27/2014 9:43:18 PM] Creating Table:     A_PROCESS    
    [6/27/2014 9:43:18 PM] Creating Table:     A_SERVICE_BROKER_TASK    
    [6/27/2014 9:43:18 PM] Creating Table:     A_KNOWLEDGEBASE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_KNOWLEDGEBASE_AUDIT    
    [6/27/2014 9:43:18 PM] Creating Table:     A_KNOWLEDGEBASE_ACTIVITY    
    [6/27/2014 9:43:18 PM] Creating Table:     A_PROFILING_ACTIVITY_ARCHIVE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_CLIENT_SESSION    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_PROVIDER    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_PROVIDER_SCHEMA    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_CACHE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_CACHE_SUGGESTION    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_CACHE_SUGGESTION_PARSED    
    [6/27/2014 9:43:18 PM] Creating Table:     A_REFERENCE_DATA_AUDIT    
    [6/27/2014 9:43:18 PM] Creating Table:     A_IMPORTED_PROJECT    
    [6/27/2014 9:43:18 PM] Creating Table:     A_SPELLER_DICTIONARY_VALUE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_SPECIAL_CHARACTER_RULE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_PERSISTENT_CACHE    
    [6/27/2014 9:43:18 PM] Creating Table:     A_TEMPLATE_OBJECTS    
    [6/27/2014 9:43:18 PM] Creating Table:     A_TEMPLATE_FOREIGN_KEYS    
    [6/27/2014 9:43:18 PM] Creating Table:     A_TEMPLATE_COLUMNS    
    [6/27/2014 9:43:18 PM] ---[ Creating Views ]---
    [6/27/2014 9:43:18 PM] Creating View:      V_A_FLOW
    [6/27/2014 9:43:18 PM] Creating View:      V_A_KNOWLEDGEBASE
    [6/27/2014 9:43:18 PM] Creating View:      V_A_KNOWLEDGEBASE_AUDIT
    [6/27/2014 9:43:18 PM] Creating View:     V_A_REFERENCE_DATA_PROVIDER    
    [6/27/2014 9:43:18 PM] Changed database context to 'DQS_PROJECTS'.
    [6/27/2014 9:43:18 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:43:18 PM]  
    [6/27/2014 9:43:18 PM]  --> Running File: static_data.sql
    [6/27/2014 9:43:18 PM] ---[ Insert Data ]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Cleansing configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Logging settings section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Logging settings section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Association configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert DataValueService configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Association rules configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert IndexService configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Knowledgebase configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Notification configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert Interactive Cleansing configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Reference Data configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert client paging configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Insert client process sampling configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Matching configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Profiling configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Process configuration section]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Reference Data Add provider]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] ---[Reference Data Add provider schema]---
    [6/27/2014 9:43:18 PM] ---[Add Special characters for term normalization]---
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] (1 rows affected)
    [6/27/2014 9:43:18 PM] 
    [6/27/2014 9:43:18 PM] Action 'Create data quality schema' finished successfully.
    [6/27/2014 9:43:18 PM] Executing action: Register data quality assemblies and stored procedures.
    [6/27/2014 9:43:18 PM] Script: 'register_dlls.cmd PA01WCLEVIN02 DQS'
    [6/27/2014 9:43:19 PM] .  Trying to connect using Windows Authentication and db name...
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all SSDQS Executable Objects
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all SSDQS Types
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all SSDQS Assemblies
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all SSDQS Schemas
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all CLR Assemblies
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop DQ startup stored procedure DQInitDQS_MAIN
    [6/27/2014 9:43:19 PM] Changed database context to 'master'.
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Drop all SSDQS Service Broker Objects
    [6/27/2014 9:43:19 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:43:19 PM] Dropping Service Broker Services.
    [6/27/2014 9:43:19 PM] Dropping Service Broker Queues.
    [6/27/2014 9:43:19 PM] Dropping Service Broker Contracts.
    [6/27/2014 9:43:19 PM] Dropping Service Broker Messages.
    [6/27/2014 9:43:19 PM] Completed - Service Broker objects dropped.
    [6/27/2014 9:43:19 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]  --> Registering Assemblies
    [6/27/2014 9:43:19 PM]  
    [6/27/2014 9:43:19 PM]      * Register .NET dependency assemblies
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.management, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.configuration.install, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.runtime.serialization, 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'smdiagnostics, 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.windows.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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.drawing, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'accessibility, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'system.runtime.serialization.formatters.soap, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:34 PM] Warning: The Microsoft .NET Framework assembly 'microsoft.jscript, version=10.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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:35 PM] Warning: The Microsoft .NET Framework assembly 'system.management.instrumentation, 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:37 PM] Warning: The Microsoft .NET Framework assembly 'system.messaging, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:37 PM] Warning: The Microsoft .NET Framework assembly 'system.directoryservices, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.enterpriseservices, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.runtime.remoting, 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.web, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a, processorarchitecture=amd64.' 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'microsoft.build.framework, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.xaml, 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 stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.runtime.caching, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'microsoft.build.utilities.v4.0, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.directoryservices.protocols, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.drawing.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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.web.regularexpressions, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'microsoft.build.tasks.v4.0, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM] Warning: The Microsoft .NET Framework assembly 'system.serviceprocess, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:43:55 PM]      * Register Microsoft.Practices assemblies
    [6/27/2014 9:44:00 PM] Warning: The Microsoft .NET Framework assembly 'microsoft.csharp, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:44:00 PM] Warning: The Microsoft .NET Framework assembly 'system.dynamic, 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 or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
    [6/27/2014 9:44:00 PM]  
    [6/27/2014 9:44:00 PM]      * Register DQ assemblies
    [6/27/2014 9:44:01 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.infra, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:03 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.core, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:03 PM] 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 Server hosted environment.
    [6/27/2014 9:44:04 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.referencedata, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:04 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.index, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:06 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.associationrules, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:07 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.datavalueservice, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:09 PM] 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 Server hosted environment.
    [6/27/2014 9:44:10 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.cleansing, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:10 PM] 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 Server hosted environment.
    [6/27/2014 9:44:11 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.flow, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:12 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs.matching, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:12 PM] Warning: The SQL Server client assembly 'microsoft.ssdqs, version=11.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [6/27/2014 9:44:12 PM] Resource file was not copied
    [6/27/2014 9:44:12 PM] Changed database context to 'master'.
    [6/27/2014 9:44:12 PM] Changed database context to 'DQS_MAIN'.
    [6/27/2014 9:44:12 PM]  
    [6/27/2014 9:44:12 PM]      * Clear the Code Member Table A_CODE_MEMBER.
    [6/27/2014 9:44:12 PM] 
    [6/27/2014 9:44:12 PM] (0 rows affected)
    [6/27/2014 9:44:12 PM]  
    [6/27/2014 9:44:12 PM]      * Clear the Code Group Table A_CODE_GROUP.
    [6/27/2014 9:44:12 PM] 
    [6/27/2014 9:44:12 PM] (0 rows affected)
    [6/27/2014 9:44:12 PM]  
    [6/27/2014 9:44:12 PM]      * Register assemblies T-SQL executable objects
    [6/27/2014 9:44:12 PM]         - Creating assemblies T-SQL registeration stored procedure.
    [6/27/2014 9:44:12 PM]  
    [6/27/2014 9:44:12 PM]      * Creating the internal_core schema
    [6/27/2014 9:44:12 PM]         - Registering Microsoft.Ssdqs.Infra T-SQL executable objects.
    [6/27/2014 9:44:16 PM] HResult 0x197A, Level 16, State 1
    [6/27/2014 9:44:16 PM] A .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly": 
    [6/27/2014 9:44:16 PM] System.Data.SqlClient.SqlException: Invalid object name 'A_DB_VERSION'.
    [6/27/2014 9:44:16 PM] System.Data.SqlClient.SqlException: 
    [6/27/2014 9:44:16 PM]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    [6/27/2014 9:44:16 PM] 
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlDataReaderSmi.NextResult()
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    [6/27/2014 9:44:17 PM]    at System.Data.SqlClient.SqlCommand.ExecuteReader()
    [6/27/2014 9:44:17 PM]    at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
    [6/27/2014 9:44:17 PM]    at Microsoft.Ssdqs.Infra.Database.DBUtility.GetDataQualityAssemblyDBVersion(IDBAccess dbAccess)
    [6/27/2014 9:44:17 PM]    at Microsoft.Ssdqs.Core.Startup.ServerInit.Init(Boolean isDuringSqlServerStartup)
    [6/27/2014 9:44:17 PM] .
    [6/27/2014 9:44:17 PM] 
    [6/27/2014 9:44:17 PM] 
    [6/27/2014 9:44:17 PM] ERROR - An error occured, check message above
    [6/27/2014 9:44:17 PM] 
    [6/27/2014 9:44:17 PM] Script process returned unexpected exit code: '1'.
    [6/27/2014 9:44:17 PM] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.
    [6/27/2014 9:44:17 PM] Starting installation rollback...
    [6/27/2014 9:44:17 PM] Installation rollback completed successfully.
    [6/27/2014 9:44:17 PM] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log


    Saturday, June 28, 2014 1:52 AM
  • What is the sql version ?

    http://social.technet.microsoft.com/wiki/contents/articles/3776.troubleshoot-installation-and-configuration-issues-in-data-quality-services-dqs.aspx


    Raju Rasagounder Sr MSSQL DBA

    Sunday, June 29, 2014 4:01 AM
  • Below is the version of SQL I have installed.

    11.0.2218.0 RTM Enterprise Edition (64-bit)

    I'm not sure if you saw my reply but I tried to install the CU2 hotfix but it said that a higher version was already installed.  The DQS version installed is 11.0.2100.60.  Is that the problem?  Different versions?

    Monday, June 30, 2014 1:08 AM
  • can you try to install SP1 ?

    Raju Rasagounder Sr MSSQL DBA

    Monday, June 30, 2014 2:30 AM
  • Sure.  Dumb question.  I'm on the Microsoft website.  Which file (or files) do I want to download?  I have the 64-bit version of the Enterprise Edition.

    SQLServer2012SP1-FullSlipstream-ENU-x64.iso

    SQLServer2012SP1-FullSlipstream-x64-ENU.box

    SQLServer2012SP1-FullSlipstream-x64-ENU.exe

    SQLServer2012SP1-KB2674319-x64-ENU.exeThank you very much for the help.

    Monday, June 30, 2014 12:17 PM
  • Raju - Thank you very much for the help.  I installed SP1 and I was able to run the DQS installer without any error.  I really appreciate it!

    Craig

    Wednesday, July 02, 2014 2:23 AM