none
DQS installation Error RRS feed

  • Question

  • I am facing following error while installing dqs

     

    Microsoft (R) DQS Installer Command Line Tool
    Copyright (C) 2017 Microsoft. All rights reserved.

    [16/03/2020 4:01:47 pm] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL14.SQLSERVER\MSSQL\Log\DQS_install.log
        
        
    [16/03/2020 4:01:48 pm] Parsing DqsInstaller command line arguments.
    [16/03/2020 4:01:48 pm] Setting the catalog to default value: DQS
    [16/03/2020 4:01:48 pm] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
    [16/03/2020 4:01:48 pm] No existing DQS installation could be found on the machine. DQS databases will be created although option -upgradedlls was used.
    [16/03/2020 4:01:48 pm] Using instance: SQLSERVER, catalog: DQS.
    [16/03/2020 4:01:48 pm] Executing action: Validate collation argument.
    [16/03/2020 4:01:48 pm] Action 'Validate collation argument' finished successfully.
    [16/03/2020 4:01:48 pm] Executing action: Check whether system reboot is pending.
    [16/03/2020 4:01:48 pm] Action 'Check whether system reboot is pending' finished successfully.

    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Running File: drop_all_assemblies.sql
    [16/03/2020 4:38:04 pm] ---[ Dropping all SSDQS Executable Objects ]---
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Drop all SSDQS Types
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Drop all SSDQS Assemblies
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Drop all SSDQS Schemas
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Drop all CLR Assemblies
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Drop DQ startup stored procedure DQInitDQS_MAIN
    [16/03/2020 4:38:04 pm] Changed database context to 'master'.
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Running File: drop_service_broker_objects.sql
    [16/03/2020 4:38:04 pm] ---[ Dropping all SSDQS Service Broker Objects ]---
    [16/03/2020 4:38:04 pm] Changed database context to 'DQS_MAIN'.
    [16/03/2020 4:38:04 pm] Dropping Service Broker Services.
    [16/03/2020 4:38:04 pm] Dropping Service Broker Queues.
    [16/03/2020 4:38:04 pm] Dropping Service Broker Contracts.
    [16/03/2020 4:38:04 pm] Dropping Service Broker Messages.
    [16/03/2020 4:38:04 pm] Completed - Service Broker objects dropped.
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Running register_assemblies.sql
    [16/03/2020 4:38:04 pm] ---[ Registering Assemblies ]---
    [16/03/2020 4:38:04 pm] Changed database context to 'DQS_MAIN'.
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]  --> Registering Assemblies
    [16/03/2020 4:38:04 pm]      The following Warnings are benign to DQSInstaller and may be ignored.
    [16/03/2020 4:38:04 pm]  
    [16/03/2020 4:38:04 pm]      * Register .NET dependency assemblies
    [16/03/2020 4:38:14 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.

    [16/03/2020 4:38:31 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.
    [16/03/2020 4:38:31 pm]  
    [16/03/2020 4:38:31 pm]      The preceding Warnings are benign to DQSInstaller and may be ignored.
    [16/03/2020 4:38:31 pm]  
    [16/03/2020 4:38:31 pm]  --> Running register_dq_assemblies.sql
    [16/03/2020 4:38:31 pm] ---[  Registering Data Quality assemblies ]---
    [16/03/2020 4:38:32 pm] Warning: The SQL Server client assembly 'microsoft.ssdqs.infra, version=14.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [16/03/2020 4:38:37 pm] Warning: The SQL Server client assembly 'microsoft.ssdqs.matching, version=14.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [16/03/2020 4:38:38 pm] Warning: The SQL Server client assembly 'microsoft.ssdqs, version=14.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil.' you are registering is not fully tested in SQL Server hosted environment.
    [16/03/2020 4:38:38 pm] Resource file was not copied
    [16/03/2020 4:38:38 pm]  
    [16/03/2020 4:38:38 pm]  --> Running register_assemblies_tsql.sql
    [16/03/2020 4:38:38 pm] ---[ Registering Assemblies for TSQL]---
    [16/03/2020 4:38:38 pm] Changed database context to 'master'.
    [16/03/2020 4:38:38 pm] Changed database context to 'DQS_MAIN'.
    [16/03/2020 4:38:38 pm]  
    [16/03/2020 4:38:38 pm]      * Clear the Code Member Table A_CODE_MEMBER.
    [16/03/2020 4:38:38 pm] 
    [16/03/2020 4:38:38 pm] (0 rows affected)
    [16/03/2020 4:38:38 pm]  
    [16/03/2020 4:38:38 pm]      * Clear the Code Group Table A_CODE_GROUP.
    [16/03/2020 4:38:38 pm] 
    [16/03/2020 4:38:38 pm] (0 rows affected)
    [16/03/2020 4:38:38 pm]  
    [16/03/2020 4:38:38 pm]      * Register assemblies T-SQL executable objects
    [16/03/2020 4:38:38 pm]         - Creating assemblies T-SQL registeration stored procedure.
    [16/03/2020 4:38:38 pm]  
    [16/03/2020 4:38:38 pm]      * Creating the internal_core schema
    [16/03/2020 4:38:38 pm]         - Registering Microsoft.Ssdqs.Infra T-SQL executable objects.
    [16/03/2020 4:38:40 pm] HResult 0x197A, Level 16, State 1
    [16/03/2020 4:38:40 pm] A .NET Framework error occurred during execution of user-defined routine or aggregate "RegisterAssembly": 
    [16/03/2020 4:38:40 pm] System.TypeInitializationException: The type initializer for 'Microsoft.Ssdqs.Core.Startup.ServerInit' threw an exception. ---> Microsoft.Ssdqs.Infra.Exceptions.ServerException: Failed to initialize configuration. ---> Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: Failed to init log configuration. ---> System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server.
    [16/03/2020 4:38:40 pm] System.Data.SqlClient.SqlException: 
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlDataReaderSmi.NextResult()
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
    [16/03/2020 4:38:40 pm]    at System.Data.SqlClient.SqlCommand.ExecuteReader()
    [16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
    [16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Database.Dao.DaoControllerBase`5.Execute()
    [16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitLogWriter()
    [16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
    [16/03/2020 4:38:40 pm] Microsoft.Ssdqs.Infra.Log.LogMessageFormatException: 
    [16/03/2020 4:38:40 pm]    at Microsoft.Ssdqs.Infra.Log.LLogger.InitConfiguration()
    [16/03/2020 4:38:40 pm]    at Microsoft.Ss...
    [16/03/2020 4:38:40 pm] 
    [16/03/2020 4:38:40 pm] 
    [16/03/2020 4:38:40 pm] ERROR - An error occured, check message above
    [16/03/2020 4:38:40 pm] 
    [16/03/2020 4:38:40 pm] 
    [16/03/2020 4:38:40 pm] Script process returned unexpected exit code: '1'.
    [16/03/2020 4:38:40 pm] Action 'Register data quality assemblies and stored procedures' finished with errors, aborting installation.
    [16/03/2020 4:38:40 pm] Starting installation rollback...
    [16/03/2020 4:38:40 pm] Installation rollback completed successfully.
    [16/03/2020 4:38:40 pm] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL14.SQLSERVER\MSSQL\Log\DQS_install.log

                                                                                                                                        

    Monday, March 16, 2020 12:46 PM