Post reply

DQS installation

  • March 26, 2016 at 4:37 pm

    #326124

    I'm writing here because msdn has no readers using ssis, probably because there are no people using ssis. This is like a last gasp:

    It's been a miracle to install and have what I think is SSDT and VS working on my computer along with mssql server. Some helpful lad had me download a version 2012 because 2015 doesnt' work with VS or something.

    https://social.msdn.microsoft.com/Forums/en-US/86f38c11-4d4f-4983-b05f-a94e3738e520/looking-for-an-ssdt-that-works?forum=ssdt

    Now I'm up to DQS, which itself is fraught with peril. There are numerous sites detailing the travails of installing DQS

    http://social.technet.microsoft.com/wiki/contents/articles/8442.upgrade-dqs-installing-cumulative-updates-or-hotfix-patches-on-data-quality-services.aspx

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

    The nut of which was you can't just right click the dqsinstaller.exe icon and run as administrator, you have to run cmd as the administrator and run dqs after that. My latest problem is (extensive log at bottom):

    .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly":

    [3/25/2016 11:17:53 AM] System.Data.SqlClient.SqlException: Invalid object name 'A_DB_VERSION'.

    [3/25/2016 11:17:53 AM]

    followed by a stack dump, followed by:

    Script process returned unexpected exit code: '1'.

    [3/25/2016 11:17:53 AM] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.

    I found this posting here:

    https://social.msdn.microsoft.com/Forums/Windowsserver/en-US/c5780488-e93e-42f9-a677-418cafe0016c/error-systemdatasqlclientsqlexception-invalid-object-name-adbversion-while-installing-dqs?forum=sqldataqualityservices

    And checked my own versions of sql server and dqs. The latter was hard to find. Anyway, they are:

    Your current Microsoft SQL Server information:

    ---------------------------------------------------------------------------------------------------------

    Product Version: 11.0.2100.60

    and for DQS, its nebulous because in the Dqsinstaller properties window, its:

    file version 2011.110.2100.60

    product version: 11.0.2100.60

    and in the logs (details below) it looks like it's just 11.0.0.0

    So what should I do?

    I know my mssql 2012 is not even sp1, but it was such a miracle to get ssdt to work with vs and mssql that I don't want to do any upgrades like sp2. MSFT is almost as bad at upgrading as Apple. It's like a game of blackjack. I have ssdt working. SSIS almost works except don't use odbc drivers. visual studio works. I don't want to draw a card and go bust. I should just appreciate what I have and not be greedy because there are a million people on the web that upgraded and then lost there kb's or ssis projects or whatever. I think the right path is to just find different versions of dqs and keep trying until one works. Is there a repository of different dqsinstallers like there is for sql server and ssdt? I haven't found one anywhere.

    My actual log:

    [3/25/2016 11:16:42 AM] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS

    [3/25/2016 11:16:42 AM] Using instance: SQLEXPRESS, catalog: DQS.

    [3/25/2016 11:16:42 AM] Executing action: Validate collation argument.

    [3/25/2016 11:16:42 AM] Action 'Validate collation argument' finished successfully.

    [3/25/2016 11:16:42 AM] Executing action: Check whether system reboot is pending.

    [3/25/2016 11:16:42 AM] Action 'Check whether system reboot is pending' finished successfully.

    [3/25/2016 11:16:42 AM] Executing action: Create data quality event source.

    [3/25/2016 11:16:43 AM] Action 'Create data quality event source' finished successfully.

    [3/25/2016 11:16:43 AM] Executing action: Request Database Master Key password from user..

    [3/25/2016 11:17:16 AM] Action 'Request Database Master Key password from user.' finished successfully.

    [3/25/2016 11:17:16 AM] Executing action: Approve removal of data quality services previous schema.

    [3/25/2016 11:17:16 AM] Action 'Approve removal of data quality services previous schema' finished successfully.

    [3/25/2016 11:17:16 AM] Executing action: Load Installation Scripts.

    [3/25/2016 11:17:16 AM] Extracting script to: C:\Users\francine\AppData\Local\Temp\cqtpwxwl.0ve

    [3/25/2016 11:17:17 AM] Extracting script: db\create_core_db_objects.sql

    [3/25/2016 11:17:17 AM] Extracting script: db\create_logic_db_objects.sql

    [3/25/2016 11:17:17 AM] Extracting script: db\create_transient_db_objects.sql

    [3/25/2016 11:17:17 AM] Extracting script: db\static_data.sql

    [3/25/2016 11:17:17 AM] Extracting script: db\drop_dq_databases.sql

    [3/25/2016 11:17:17 AM] Extracting script: helper\DeleteSchemaDs.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\drop_all_assemblies.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\create_databases.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\drop_databases.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\drop_all_tables.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\drop_database_properties.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\master_create.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\master_recreate.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\register_assemblies.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\register_assemblies_tsql.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\register_dq_assemblies.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\create_service_broker_objects.sql

    [3/25/2016 11:17:17 AM] Extracting script: sql\drop_service_broker_objects.sql

    [3/25/2016 11:17:17 AM] Extracting script: recreate_schema.bat

    [3/25/2016 11:17:17 AM] Extracting script: drop_databases.cmd

    [3/25/2016 11:17:17 AM] Extracting script: register_dlls.cmd

    [3/25/2016 11:17:17 AM] Extracting script: unregister_dlls.cmd

    [3/25/2016 11:17:17 AM] Extracting script: assembly_paths_retail.txt

    [3/25/2016 11:17:17 AM] Extracting script: DQS_Data.dqs

    [3/25/2016 11:17:17 AM] Extracting script: DefaultKbs.xml

    [3/25/2016 11:17:17 AM] Total scripts extracted: 25

    [3/25/2016 11:17:17 AM] Action 'Load Installation Scripts' finished successfully.

    [3/25/2016 11:17:17 AM] Executing action: Create data quality schema.

    [3/25/2016 11:17:17 AM] Script: 'recreate_schema.bat francine-PC\SQLEXPRESS DQS SQL_Latin1_General_CP1_CI_AS'

    [3/25/2016 11:17:18 AM] . Trying to connect using Windows Authentication and db name...

    [3/25/2016 11:17:18 AM] Changed database context to 'master'.

    [3/25/2016 11:17:22 AM] Creating DQS databases (DQS_MAIN, DQS_PROJECTS, DQS_STAGING_DATA)...

    [3/25/2016 11:17:22 AM] Configuring DQS databases

    [3/25/2016 11:17:22 AM] Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.

    [3/25/2016 11:17:22 AM] Creating Master Key for database DQS_MAIN...

    [3/25/2016 11:17:22 AM] Creating Module Signing Certificate for database DQS_MAIN...

    [3/25/2016 11:17:22 AM] Exporting Certificate from DQS_MAIN

    [3/25/2016 11:17:22 AM] Importing Certificate into DQS_PROJECTS

    [3/25/2016 11:17:22 AM] Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

    [3/25/2016 11:17:22 AM] Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE statement to install.

    [3/25/2016 11:17:22 AM] Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE statement to install.

    [3/25/2016 11:17:22 AM] Creating DQS roles

    [3/25/2016 11:17:22 AM] Changed database context to 'DQS_STAGING_DATA'.

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --> Running File: drop_database_properties.sql

    [3/25/2016 11:17:22 AM] Changed database context to 'DQS_PROJECTS'.

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --> Drop all SSDQS Database objects and KB schemas

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all Symmetric Keys ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all Certificates ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all FK constraints ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all views ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all tables and synonyms ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all database triggers ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all stored procedures in Knowledge Base schemas ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all types in Knowledge Base schemas ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all Knowledge Base schemas ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --> Running File: drop_database_properties.sql

    [3/25/2016 11:17:22 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --> Drop all SSDQS Database objects and KB schemas

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all Symmetric Keys ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:22 AM] --[ Drop all Certificates ]

    [3/25/2016 11:17:22 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all FK constraints ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all views ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all tables and synonyms ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all database triggers ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all stored procedures in Knowledge Base schemas ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all types in Knowledge Base schemas ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --[ Drop all Knowledge Base schemas ]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --> Running File: drop_database_properties.sql

    [3/25/2016 11:17:23 AM] Changed database context to 'DQS_STAGING_DATA'.

    [3/25/2016 11:17:23 AM] Changed database context to 'DQS_PROJECTS'.

    [3/25/2016 11:17:23 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --> Running File: create_core_db_objects.sql

    [3/25/2016 11:17:23 AM] ---[ Creating Certificates ]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] ---[ Creating Symmetric Keys ]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] ---[ Creating Tables ]---

    [3/25/2016 11:17:23 AM] Creating Table: A_TEST

    [3/25/2016 11:17:23 AM] Creating Table: A_TEST2

    [3/25/2016 11:17:23 AM] Creating Table: A_FLOW

    [3/25/2016 11:17:23 AM] Creating Table: A_FLOW_ANSWER

    [3/25/2016 11:17:23 AM] Creating Table: A_EXECUTION_UNIT

    [3/25/2016 11:17:23 AM] Creating Table: A_CODE_GROUP

    [3/25/2016 11:17:23 AM] Creating Table: A_CODE_MEMBER

    [3/25/2016 11:17:23 AM] Creating Table: A_CONFIGURATION

    [3/25/2016 11:17:23 AM] Creating Table: A_PROCESS

    [3/25/2016 11:17:23 AM] Creating Table: A_SERVICE_BROKER_TASK

    [3/25/2016 11:17:23 AM] Creating Table: A_KNOWLEDGEBASE

    [3/25/2016 11:17:23 AM] Creating Table: A_KNOWLEDGEBASE_AUDIT

    [3/25/2016 11:17:23 AM] Creating Table: A_KNOWLEDGEBASE_ACTIVITY

    [3/25/2016 11:17:23 AM] Creating Table: A_PROFILING_ACTIVITY_ARCHIVE

    [3/25/2016 11:17:23 AM] Creating Table: A_CLIENT_SESSION

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_PROVIDER

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_PROVIDER_SCHEMA

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_CACHE

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_CACHE_SUGGESTION

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_CACHE_SUGGESTION_PARSED

    [3/25/2016 11:17:23 AM] Creating Table: A_REFERENCE_DATA_AUDIT

    [3/25/2016 11:17:23 AM] Creating Table: A_IMPORTED_PROJECT

    [3/25/2016 11:17:23 AM] Creating Table: A_SPELLER_DICTIONARY_VALUE

    [3/25/2016 11:17:23 AM] Creating Table: A_SPECIAL_CHARACTER_RULE

    [3/25/2016 11:17:23 AM] Creating Table: A_PERSISTENT_CACHE

    [3/25/2016 11:17:23 AM] Creating Table: A_TEMPLATE_OBJECTS

    [3/25/2016 11:17:23 AM] Creating Table: A_TEMPLATE_FOREIGN_KEYS

    [3/25/2016 11:17:23 AM] Creating Table: A_TEMPLATE_COLUMNS

    [3/25/2016 11:17:23 AM] ---[ Creating Views ]---

    [3/25/2016 11:17:23 AM] Creating View: V_A_FLOW

    [3/25/2016 11:17:23 AM] Creating View: V_A_KNOWLEDGEBASE

    [3/25/2016 11:17:23 AM] Creating View: V_A_KNOWLEDGEBASE_AUDIT

    [3/25/2016 11:17:23 AM] Creating View: V_A_REFERENCE_DATA_PROVIDER

    [3/25/2016 11:17:23 AM] Changed database context to 'DQS_PROJECTS'.

    [3/25/2016 11:17:23 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] --> Running File: static_data.sql

    [3/25/2016 11:17:23 AM] ---[ Insert Data ]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Cleansing configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Logging settings section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Logging settings section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Association configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert DataValueService configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Association rules configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert IndexService configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Knowledgebase configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Notification configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert Interactive Cleansing configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Reference Data configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert client paging configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Insert client process sampling configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Matching configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Profiling configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Process configuration section]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Reference Data Add provider]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM] ---[Reference Data Add provider schema]---

    [3/25/2016 11:17:23 AM] ---[Add Special characters for term normalization]---

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] (1 rows affected)

    [3/25/2016 11:17:23 AM]

    [3/25/2016 11:17:23 AM] Action 'Create data quality schema' finished successfully.

    [3/25/2016 11:17:23 AM] Executing action: Register data quality assemblies and stored procedures.

    [3/25/2016 11:17:23 AM] Script: 'register_dlls.cmd francine-PC\SQLEXPRESS DQS'

    [3/25/2016 11:17:24 AM] . Trying to connect using Windows Authentication and db name...

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all SSDQS Executable Objects

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all SSDQS Types

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all SSDQS Assemblies

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all SSDQS Schemas

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all CLR Assemblies

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop DQ startup stored procedure DQInitDQS_MAIN

    [3/25/2016 11:17:24 AM] Changed database context to 'master'.

    [3/25/2016 11:17:24 AM]

    [3/25/2016 11:17:24 AM] --> Drop all SSDQS Service Broker Objects

    [3/25/2016 11:17:24 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:25 AM] Dropping Service Broker Services.

    [3/25/2016 11:17:25 AM] Dropping Service Broker Queues.

    [3/25/2016 11:17:25 AM] Dropping Service Broker Contracts.

    [3/25/2016 11:17:25 AM] Dropping Service Broker Messages.

    [3/25/2016 11:17:25 AM] Completed - Service Broker objects dropped.

    [3/25/2016 11:17:25 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:25 AM]

    [3/25/2016 11:17:25 AM] --> Registering Assemblies

    [3/25/2016 11:17:25 AM]

    [3/25/2016 11:17:25 AM] * Register .NET dependency assemblies

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:34 AM] 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.

    [3/25/2016 11:17:35 AM] 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.

    [3/25/2016 11:17:36 AM] 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.

    [3/25/2016 11:17:36 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] 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.

    [3/25/2016 11:17:45 AM] * Register Microsoft.Practices assemblies

    [3/25/2016 11:17:47 AM] 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.

    [3/25/2016 11:17:47 AM] 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.

    [3/25/2016 11:17:47 AM]

    [3/25/2016 11:17:47 AM] * Register DQ assemblies

    [3/25/2016 11:17:48 AM] 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.

    [3/25/2016 11:17:48 AM] 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.

    [3/25/2016 11:17:48 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 Server hosted environment.

    [3/25/2016 11:17:49 AM] 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.

    [3/25/2016 11:17:49 AM] 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.

    [3/25/2016 11:17:49 AM] 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.

    [3/25/2016 11:17:50 AM] 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.

    [3/25/2016 11:17:50 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 Server hosted environment.

    [3/25/2016 11:17:50 AM] 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.

    [3/25/2016 11:17:50 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 Server hosted environment.

    [3/25/2016 11:17:51 AM] 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.

    [3/25/2016 11:17:51 AM] 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.

    [3/25/2016 11:17:51 AM] 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.

    [3/25/2016 11:17:51 AM] Resource file was not copied

    [3/25/2016 11:17:51 AM] Changed database context to 'master'.

    [3/25/2016 11:17:51 AM] Changed database context to 'DQS_MAIN'.

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] * Clear the Code Member Table A_CODE_MEMBER.

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] (0 rows affected)

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] * Clear the Code Group Table A_CODE_GROUP.

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] (0 rows affected)

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] * Register assemblies T-SQL executable objects

    [3/25/2016 11:17:51 AM] - Creating assemblies T-SQL registeration stored procedure.

    [3/25/2016 11:17:51 AM]

    [3/25/2016 11:17:51 AM] * Creating the internal_core schema

    [3/25/2016 11:17:51 AM] - Registering Microsoft.Ssdqs.Infra T-SQL executable objects.

    [3/25/2016 11:17:53 AM] HResult 0x197A, Level 16, State 1

    [3/25/2016 11:17:53 AM] A .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly":

    [3/25/2016 11:17:53 AM] System.Data.SqlClient.SqlException: Invalid object name 'A_DB_VERSION'.

    [3/25/2016 11:17:53 AM] System.Data.SqlClient.SqlException:

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    [3/25/2016 11:17:53 AM] at System.Data.SqlClient.SqlCommand.ExecuteReader()

    [3/25/2016 11:17:53 AM] at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()

    [3/25/2016 11:17:53 AM] at Microsoft.Ssdqs.Infra.Database.DBUtility.GetDataQualityAssemblyDBVersion(IDBAccess dbAccess)

    [3/25/2016 11:17:53 AM] at Microsoft.Ssdqs.Core.Startup.ServerInit.Init(Boolean isDuringSqlServerStartup)

    [3/25/2016 11:17:53 AM] .

    [3/25/2016 11:17:53 AM]

    [3/25/2016 11:17:53 AM]

    [3/25/2016 11:17:53 AM] ERROR - An error occured, check message above

    [3/25/2016 11:17:53 AM]

    [3/25/2016 11:17:53 AM]

    [3/25/2016 11:17:53 AM] Script process returned unexpected exit code: '1'.

    [3/25/2016 11:17:53 AM] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.

    [3/25/2016 11:17:53 AM] Starting installation rollback...

    [3/25/2016 11:17:54 AM] Installation rollback completed successfully.

    [3/25/2016 11:17:54 AM] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Log\DQS_install.log

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply