Error when running DQSInstaller.exe

Question

Hi All,

I'm having some issues when trying to install DQS. I have installed SQL Server developer edition onto a new VM with Windows Server 2008R2 Enterprise Service Pack 1 64 bit. I have received a all clear on the database install process and now tried to run the DQSINstaller from both the Start Menu and Command Line, I am logged in as a domain admin and have the appropriate sysadmin rights on the new database server.

The log I am getting is decidedly unhelpful as the only error message I am getting is Script process returned unexpected exit code: '1'

The entire log is included below.

I have looked through a couple of other forum questions on similar topics and through the troubleshooting guide in BoL, but I don't appear to be getting as far through the process as the others that have fallen over at this point and BoL has nothing that appears to relate to my problem.

Any and all pointers towards a resolution would be very welcome!

Thanks in advance

John

  
[12/07/2012 13:12:47] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
[12/07/2012 13:12:48] Using instance: MSSQLSERVER, catalog: DQS.
[12/07/2012 13:12:48] Executing action: Validate collation argument.
[12/07/2012 13:12:48] Action 'Validate collation argument' finished successfully.
[12/07/2012 13:12:48] Executing action: Check whether system reboot is pending.
[12/07/2012 13:12:48] Action 'Check whether system reboot is pending' finished successfully.
[12/07/2012 13:12:48] Executing action: Create data quality event source.
[12/07/2012 13:12:48] Action 'Create data quality event source' finished successfully.
[12/07/2012 13:12:48] Executing action: Request Database Master Key password from user..
[12/07/2012 13:13:05] Action 'Request Database Master Key password from user.' finished successfully.
[12/07/2012 13:13:05] Executing action: Approve removal of data quality services previous schema.
[12/07/2012 13:13:05] Action 'Approve removal of data quality services previous schema' finished successfully.
[12/07/2012 13:13:05] Executing action: Load Installation Scripts.
[12/07/2012 13:13:05] Extracting script to: C:\Users\administrator.RMS\AppData\Local\Temp\2\qbzvv2ms.huk
[12/07/2012 13:13:05] Extracting script: db\create_core_db_objects.sql
[12/07/2012 13:13:05] Extracting script: db\create_logic_db_objects.sql
[12/07/2012 13:13:05] Extracting script: db\create_transient_db_objects.sql
[12/07/2012 13:13:05] Extracting script: db\static_data.sql
[12/07/2012 13:13:05] Extracting script: db\drop_dq_databases.sql
[12/07/2012 13:13:05] Extracting script: helper\DeleteSchemaDs.sql
[12/07/2012 13:13:05] Extracting script: sql\drop_all_assemblies.sql
[12/07/2012 13:13:05] Extracting script: sql\create_databases.sql
[12/07/2012 13:13:05] Extracting script: sql\drop_databases.sql
[12/07/2012 13:13:05] Extracting script: sql\drop_all_tables.sql
[12/07/2012 13:13:05] Extracting script: sql\drop_database_properties.sql
[12/07/2012 13:13:05] Extracting script: sql\master_create.sql
[12/07/2012 13:13:05] Extracting script: sql\master_recreate.sql
[12/07/2012 13:13:05] Extracting script: sql\register_assemblies.sql
[12/07/2012 13:13:05] Extracting script: sql\register_assemblies_tsql.sql
[12/07/2012 13:13:05] Extracting script: sql\register_dq_assemblies.sql
[12/07/2012 13:13:05] Extracting script: sql\create_service_broker_objects.sql
[12/07/2012 13:13:05] Extracting script: sql\drop_service_broker_objects.sql
[12/07/2012 13:13:05] Extracting script: recreate_schema.bat
[12/07/2012 13:13:05] Extracting script: drop_databases.cmd
[12/07/2012 13:13:05] Extracting script: register_dlls.cmd
[12/07/2012 13:13:05] Extracting script: unregister_dlls.cmd
[12/07/2012 13:13:05] Extracting script: assembly_paths_retail.txt
[12/07/2012 13:13:05] Extracting script: DQS_Data.dqs
[12/07/2012 13:13:05] Extracting script: DefaultKbs.xml
[12/07/2012 13:13:05] Total scripts extracted: 25
[12/07/2012 13:13:05] Action 'Load Installation Scripts' finished successfully.
[12/07/2012 13:13:05] Executing action: Create data quality schema.
[12/07/2012 13:13:05] Script: 'recreate_schema.bat NC-DATACLEANSE DQS SQL_Latin1_General_CP1_CI_AS'
[12/07/2012 13:13:07]
[12/07/2012 13:13:07]
[12/07/2012 13:13:07] Script process returned unexpected exit code: '1'.
[12/07/2012 13:13:07] Action 'Create data quality schema' finished with errors, aborting installation.
[12/07/2012 13:13:07] Starting installation rollback...
[12/07/2012 13:13:07] Installation rollback completed successfully.
[12/07/2012 13:13:07] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log

Answer 1

decided to flatline the VM and start afresh.  :o(

Answer 2

Scratch that,

On the flatlined server I am getting to exactly the same point in the DQS install process.

So, once again any and all suggestions gratefully received. :o(

-------

Just in case it is useful, my Build is 11.0.2100.60 with a CLR Build of v4.0.30319. This is Developer edition installed from a file downloaded from MSDN
on Friday 13th.

Answer 3

Just a thought,

... If I had backups of the DQS databases (DQS_MAIN, DQS_PROJECTS, and DQS_STAGING_DATA), and
restored them to my server, would running the DQSInstaller.exe from the command prompt with a "-upgradedlls" switch complete the installation, or are there other objects/assemblies installed into SQL Server outside the databases that are required?

Obviously this would also require backups with the appropriate coalition which I cannot see on Codeplex.

http://technet.microsoft.com/en-us/library/hh231682.aspx

Answer 4

Looking through the current install log, I can see that it reports extracting files to C:\Users\johnste\AppData\Local\Temp\2 but if I navigate to this location the folder is completely empty.

Could this be causing the problem or are these files all deleted during the cleanup?

The full text of the two install attempts this morning are...

[16/07/2012 07:20:20] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log
   
   
[16/07/2012 07:20:20] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
[16/07/2012 07:20:21] Using instance: MSSQLSERVER, catalog: DQS.
[16/07/2012 07:20:21] Executing action: Validate collation argument.
[16/07/2012 07:20:21] Action 'Validate collation argument' finished successfully.
[16/07/2012 07:20:21] Executing action: Check whether system reboot is pending.
[16/07/2012 07:20:21] Action 'Check whether system reboot is pending' finished successfully.
[16/07/2012 07:20:21] Executing action: Create data quality event source.
[16/07/2012 07:20:21] Action 'Create data quality event source' finished successfully.
[16/07/2012 07:20:21] Executing action: Request Database Master Key password from user..
[16/07/2012 07:21:10] Action 'Request Database Master Key password from user.' finished successfully.
[16/07/2012 07:21:10] Executing action: Approve removal of data quality services previous schema.
[16/07/2012 07:21:10] Action 'Approve removal of data quality services previous schema' finished successfully.
[16/07/2012 07:21:10] Executing action: Load Installation Scripts.
[16/07/2012 07:21:10] Extracting script to: C:\Users\johnste\AppData\Local\Temp\2\lyhqixqp.uyq
[16/07/2012 07:21:11] Extracting script: db\create_core_db_objects.sql
[16/07/2012 07:21:11] Extracting script: db\create_logic_db_objects.sql
[16/07/2012 07:21:11] Extracting script: db\create_transient_db_objects.sql
[16/07/2012 07:21:11] Extracting script: db\static_data.sql
[16/07/2012 07:21:11] Extracting script: db\drop_dq_databases.sql
[16/07/2012 07:21:11] Extracting script: helper\DeleteSchemaDs.sql
[16/07/2012 07:21:11] Extracting script: sql\drop_all_assemblies.sql
[16/07/2012 07:21:11] Extracting script: sql\create_databases.sql
[16/07/2012 07:21:11] Extracting script: sql\drop_databases.sql
[16/07/2012 07:21:11] Extracting script: sql\drop_all_tables.sql
[16/07/2012 07:21:11] Extracting script: sql\drop_database_properties.sql
[16/07/2012 07:21:11] Extracting script: sql\master_create.sql
[16/07/2012 07:21:11] Extracting script: sql\master_recreate.sql
[16/07/2012 07:21:11] Extracting script: sql\register_assemblies.sql
[16/07/2012 07:21:11] Extracting script: sql\register_assemblies_tsql.sql
[16/07/2012 07:21:11] Extracting script: sql\register_dq_assemblies.sql
[16/07/2012 07:21:11] Extracting script: sql\create_service_broker_objects.sql
[16/07/2012 07:21:11] Extracting script: sql\drop_service_broker_objects.sql
[16/07/2012 07:21:11] Extracting script: recreate_schema.bat
[16/07/2012 07:21:11] Extracting script: drop_databases.cmd
[16/07/2012 07:21:11] Extracting script: register_dlls.cmd
[16/07/2012 07:21:11] Extracting script: unregister_dlls.cmd
[16/07/2012 07:21:11] Extracting script: assembly_paths_retail.txt
[16/07/2012 07:21:11] Extracting script: DQS_Data.dqs
[16/07/2012 07:21:11] Extracting script: DefaultKbs.xml
[16/07/2012 07:21:11] Total scripts extracted: 25
[16/07/2012 07:21:11] Action 'Load Installation Scripts' finished successfully.
[16/07/2012 07:21:11] Executing action: Create data quality schema.
[16/07/2012 07:21:11] Script: 'recreate_schema.bat NC-DATACLEANSE DQS SQL_Latin1_General_CP1_CI_AS'
[16/07/2012 07:21:14]
[16/07/2012 07:21:14]
[16/07/2012 07:21:14] Script process returned unexpected exit code: '1'.
[16/07/2012 07:21:14] Action 'Create data quality schema' finished with errors, aborting installation.
[16/07/2012 07:21:14] Starting installation rollback...
[16/07/2012 07:21:14] Installation rollback completed successfully.
[16/07/2012 07:21:14] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log
[16/07/2012 07:23:19] DQS Installer started. Installation log will be written to C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log
   
   
[16/07/2012 07:23:19] Setting the collation to default value: SQL_Latin1_General_CP1_CI_AS
[16/07/2012 07:23:20] Using instance: MSSQLSERVER, catalog: DQS.
[16/07/2012 07:23:20] Executing action: Validate collation argument.
[16/07/2012 07:23:20] Action 'Validate collation argument' finished successfully.
[16/07/2012 07:23:20] Executing action: Check whether system reboot is pending.
[16/07/2012 07:23:20] Action 'Check whether system reboot is pending' finished successfully.
[16/07/2012 07:23:20] Executing action: Create data quality event source.
[16/07/2012 07:23:20] Action 'Create data quality event source' finished successfully.
[16/07/2012 07:23:20] Executing action: Request Database Master Key password from user..
[16/07/2012 07:23:37] Action 'Request Database Master Key password from user.' finished successfully.
[16/07/2012 07:23:37] Executing action: Approve removal of data quality services previous schema.
[16/07/2012 07:23:37] Action 'Approve removal of data quality services previous schema' finished successfully.
[16/07/2012 07:23:37] Executing action: Load Installation Scripts.
[16/07/2012 07:23:37] Extracting script to: C:\Users\johnste\AppData\Local\Temp\2\v01snfit.rck
[16/07/2012 07:23:37] Extracting script: db\create_core_db_objects.sql
[16/07/2012 07:23:37] Extracting script: db\create_logic_db_objects.sql
[16/07/2012 07:23:37] Extracting script: db\create_transient_db_objects.sql
[16/07/2012 07:23:37] Extracting script: db\static_data.sql
[16/07/2012 07:23:37] Extracting script: db\drop_dq_databases.sql
[16/07/2012 07:23:37] Extracting script: helper\DeleteSchemaDs.sql
[16/07/2012 07:23:37] Extracting script: sql\drop_all_assemblies.sql
[16/07/2012 07:23:37] Extracting script: sql\create_databases.sql
[16/07/2012 07:23:37] Extracting script: sql\drop_databases.sql
[16/07/2012 07:23:37] Extracting script: sql\drop_all_tables.sql
[16/07/2012 07:23:37] Extracting script: sql\drop_database_properties.sql
[16/07/2012 07:23:37] Extracting script: sql\master_create.sql
[16/07/2012 07:23:37] Extracting script: sql\master_recreate.sql
[16/07/2012 07:23:37] Extracting script: sql\register_assemblies.sql
[16/07/2012 07:23:37] Extracting script: sql\register_assemblies_tsql.sql
[16/07/2012 07:23:37] Extracting script: sql\register_dq_assemblies.sql
[16/07/2012 07:23:37] Extracting script: sql\create_service_broker_objects.sql
[16/07/2012 07:23:37] Extracting script: sql\drop_service_broker_objects.sql
[16/07/2012 07:23:37] Extracting script: recreate_schema.bat
[16/07/2012 07:23:37] Extracting script: drop_databases.cmd
[16/07/2012 07:23:37] Extracting script: register_dlls.cmd
[16/07/2012 07:23:37] Extracting script: unregister_dlls.cmd
[16/07/2012 07:23:37] Extracting script: assembly_paths_retail.txt
[16/07/2012 07:23:37] Extracting script: DQS_Data.dqs
[16/07/2012 07:23:37] Extracting script: DefaultKbs.xml
[16/07/2012 07:23:37] Total scripts extracted: 25
[16/07/2012 07:23:37] Action 'Load Installation Scripts' finished successfully.
[16/07/2012 07:23:37] Executing action: Create data quality schema.
[16/07/2012 07:23:37] Script: 'recreate_schema.bat NC-DATACLEANSE DQS SQL_Latin1_General_CP1_CI_AS'
[16/07/2012 07:23:39]
[16/07/2012 07:23:39]
[16/07/2012 07:23:39] Script process returned unexpected exit code: '1'.
[16/07/2012 07:23:39] Action 'Create data quality schema' finished with errors, aborting installation.
[16/07/2012 07:23:39] Starting installation rollback...
[16/07/2012 07:23:39] Installation rollback completed successfully.
[16/07/2012 07:23:39] DQS Installer finished with errors. Please see installation log file at C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\DQS_install.log

Answer 5

Now I'm REALLY confused.

I just ran the DQSInstaller again (from the start menu), it looks identical with teh exception of a different filename at line 14 and the timestamps, but this time I do have files in C:\...\Temp\2. Same "unexpected exit code of 1" with a succesful rollback.

Answer 6

I've found a couple of forum replies that suggest using process monitor to capture events from DQSInstaller.exe and cmd.exe.

I've given that a go and in addition to a lot of SUCCESS results I am also seeing "Name not found" "Path not found" "No such file" "No more entries" "Buffer overflow" "File locked with only readers" "Reparse" "Invalid Parameter" "Not reparse point" "Is directory" and "End of file"

The prcess that is returning a 1 exit code is DQSInstaller.exe - process exit. (see image)

the text from the process tab is...

Description: Microsoft.Ssdqs.DqsInstaller
Company: Microsoft Corporation
Name: DQSInstaller.exe
Version: 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Path: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\DQSInstaller.exe
Command Line: "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\DQSInstaller.exe"
PID: 2416
Parent PID: 2924
Session ID: 2
User: RMS\johnste
Auth ID: 00000000:00096e86
Architecture: 64-bit
Virtualized: False
Integrity: High
Started: 16/07/2012 14:25:14
Ended: 16/07/2012 14:25:52
Modules:
DQSInstaller.exe 0x2a0000 0x286000 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\DQSInstaller.exe Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
System.EnterpriseServices.Wrapper.dll 0x2640000 0x25000 C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
instapi.dll 0x48060000 0xd000 C:\Program Files\Microsoft SQL Server\90\Shared\instapi.dll Microsoft Corporation 2005.090.1399.00
System.Transactions.dll 0x6ffd0000 0x4a000 C:\Windows\Microsoft.NET\assembly\GAC_64\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
System.EnterpriseServices.Wrapper.dll 0x70880000 0x25000 C:\Windows\Microsoft.NET\assembly\GAC_64\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
System.Data.dll 0x71d60000 0x311000 C:\Windows\Microsoft.Net\assembly\GAC_64\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll Microsoft Corporation 4.0.30319.245 (RTMGDR.030319-2400)
msvcr80.dll 0x72d50000 0xc9000 C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4940_none_88df89932faf0bf6\msvcr80.dll Microsoft Corporation 8.00.50727.4940
security.dll 0x73ba0000 0x3000 C:\Windows\System32\security.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
kernel32.dll 0x77040000 0x11f000 C:\Windows\System32\kernel32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
user32.dll 0x77160000 0xfa000 C:\Windows\System32\user32.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
ntdll.dll 0x77260000 0x1a9000 C:\Windows\System32\ntdll.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
Microsoft.Ssdqs.ReferenceData.ni.dll 0x7fee4160000 0xe1000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Ref#\f2a29b912335a067c0193113ced9cc40\Microsoft.Ssdqs.ReferenceData.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.Matching.ni.dll 0x7fee4250000 0xcd000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Mat#\33c1d2c2634878c2f4886fcbdbb54166\Microsoft.Ssdqs.Matching.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.DataValueService.ni.dll 0x7fee4320000 0xdb000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Dat#\87959bc67699e9d89c5bbccb8ee0403b\Microsoft.Ssdqs.DataValueService.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.Cleansing.ni.dll 0x7fee4400000 0x2ab000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Cle#\cd96e5dfaaddc695e851e4ab47f9d29e\Microsoft.Ssdqs.Cleansing.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.Core.ni.dll 0x7fee46b0000 0x203000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Core\e3c131d1abc62c0972d6418cfe898c65\Microsoft.Ssdqs.Core.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.Index.ni.dll 0x7fee4ee0000 0xa5000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Ind#\edb2a9fc53d15657c3981ba322cc6367\Microsoft.Ssdqs.Index.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.DataService.ni.dll 0x7fee4f90000 0x9f000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Dat#\5b3ba75548947ece1ac650d07811762e\Microsoft.Ssdqs.DataService.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Practices.EnterpriseLibrary.Logging.ni.dll 0x7fee5030000 0x116000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Practices#\0375925ba09caf935b568c2e7288933e\Microsoft.Practices.EnterpriseLibrary.Logging.ni.dll Microsoft Corporation 4.1.0.0
Microsoft.Ssdqs.Infra.ni.dll 0x7fee5150000 0x4f5000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Inf#\def76dc6670931da012fea5c3c5ff88a\Microsoft.Ssdqs.Infra.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
DqsInstaller.ni.exe 0x7fee5650000 0x2ae000 C:\Windows\assembly\NativeImages_v4.0.30319_64\DqsInstaller\7cf0535c54b300450ed203c68805b713\DqsInstaller.ni.exe Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
System.EnterpriseServices.ni.dll 0x7fee5c10000 0x10e000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.EnterpriseSe#\6e782d57dc034af2a80fd15040720648\System.EnterpriseServices.ni.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
System.Transactions.ni.dll 0x7fee5d20000 0xe0000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Transactions\b1301f7a27e9cc366cc8044d32bbf988\System.Transactions.ni.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
System.DirectoryServices.AccountManagement.ni.dll 0x7fee65c0000 0x12c000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.DirectorySer#\4b4e7845e30dc8a3a5269e7592e7a8b3\System.DirectoryServices.AccountManagement.ni.dll Microsoft Corporation 4.0.30319.1 built by: RTMRel
Microsoft.Ssdqs.DomainRules.ni.dll 0x7fee6730000 0x78000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Dom#\9a0d521819503b65ebd65b90958b9ea9\Microsoft.Ssdqs.DomainRules.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.AssociationRules.ni.dll 0x7fee67b0000 0x4f000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Ass#\422b47ef62b47faf39c659de237224b7\Microsoft.Ssdqs.AssociationRules.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Ssdqs.ni.dll 0x7fee68b0000 0x9e000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs\074daf509b268a0c89c35144c853ec63\Microsoft.Ssdqs.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Practices.EnterpriseLibrary.Common.ni.dll 0x7fee6950000 0x14d000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Practices#\e058a9b2b840f14eba425487d013d40e\Microsoft.Practices.EnterpriseLibrary.Common.ni.dll Microsoft Corporation 4.1.0.0
Microsoft.Practices.ObjectBuilder2.ni.dll 0x7fee6aa0000 0x68000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Practices#\f63ab015a4df4b925b7f790bc04c78a7\Microsoft.Practices.ObjectBuilder2.ni.dll Microsoft Corporation 2.2.0.0
Microsoft.Ssdqs.Association.ni.dll 0x7fee78c0000 0x44000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Ass#\415bb9bb7e603e42c26648e5a550f913\Microsoft.Ssdqs.Association.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
System.EnterpriseServices.Wrapper.dll 0x7fee8bb0000 0x58000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.EnterpriseSe#\6e782d57dc034af2a80fd15040720648\System.EnterpriseServices.Wrapper.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
Microsoft.Ssdqs.Flow.ni.dll 0x7fee8c40000 0x14000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ssdqs.Flow\13301ec06a12a54805715bc4531df17d\Microsoft.Ssdqs.Flow.ni.dll Microsoft Corporation 2011.0110.2100.60 ((SQL11_RTM).120210-1612)
Microsoft.Practices.Unity.ni.dll 0x7fee8c90000 0x45000 C:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Practices#\2f04eefbde44bdf11f3b74368e8efd64\Microsoft.Practices.Unity.ni.dll Microsoft Corporation 1.2.0.0
sqmapi.dll 0x7fee9400000 0x2d000 C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\sqmapi.dll Microsoft Corporation 6.0.6000.16386 (vista_rtm.061101-2205)
System.Data.ni.dll 0x7feee200000 0x843000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Data\3d7a169926a36ba5b7b8c7abe036a22e\System.Data.ni.dll Microsoft Corporation 4.0.30319.245 (RTMGDR.030319-2400)
System.Core.ni.dll 0x7feeea50000 0x9f7000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Core\43b4dd37b8635d93ca57d7e2707efaa1\System.Core.ni.dll Microsoft Corporation 4.0.30319.233 built by: RTMGDR
shfolder.dll 0x7fef09e0000 0x7000 C:\Windows\System32\shfolder.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
clrjit.dll 0x7fef0af0000 0x173000 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clrjit.dll Microsoft Corporation 4.0.30319.237 (RTMGDR.030319-2300)
System.Xml.ni.dll 0x7fef72d0000 0x6b9000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Xml\1286c6f6a688cb2da337e85cd3abee84\System.Xml.ni.dll Microsoft Corporation 4.0.30319.233 built by: RTMGDR
System.Configuration.ni.dll 0x7fef7990000 0x135000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System.Configuration\3869c2ac9bcc74d7f390e63bd96306c7\System.Configuration.ni.dll Microsoft Corporation 4.0.30319.1 (RTMRel.030319-0100)
System.ni.dll 0x7fef7ba0000 0xb55000 C:\Windows\assembly\NativeImages_v4.0.30319_64\System\ae57e498b6716c18995db41524cdff50\System.ni.dll Microsoft Corporation 4.0.30319.233 built by: RTMGDR
nlssorting.dll 0x7fef8700000 0x14000 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\nlssorting.dll Microsoft Corporation 4.0.30319.237 (RTMGDR.030319-2300)
mscorlib.ni.dll 0x7fef8720000 0x1277000 C:\Windows\assembly\NativeImages_v4.0.30319_64\mscorlib\8f7f691aa155c11216387cf3420d9d1b\mscorlib.ni.dll Microsoft Corporation 4.0.30319.237 (RTMGDR.030319-2300)
MSVCR100_CLR0400.dll 0x7fef99a0000 0xd1000 C:\Windows\System32\MSVCR100_CLR0400.dll Microsoft Corporation 10.00.30319.1
clr.dll 0x7fef9a80000 0x965000 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\clr.dll Microsoft Corporation 4.0.30319.237 (RTMGDR.030319-2300)
mscoreei.dll 0x7fefa3f0000 0x90000 C:\Windows\Microsoft.NET\Framework64\v4.0.30319\mscoreei.dll Microsoft Corporation 4.0.30319.237 (RTMGDR.030319-2300)
mscoree.dll 0x7fefa480000 0x6f000 C:\Windows\System32\mscoree.dll Microsoft Corporation 4.0.40305.0 (Main.040305-0000)
ntdsapi.dll 0x7fefaaa0000 0x27000 C:\Windows\System32\ntdsapi.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
rasadhlp.dll 0x7fefaad0000 0x8000 C:\Windows\System32\rasadhlp.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
wkscli.dll 0x7fefb0b0000 0x15000 C:\Windows\System32\wkscli.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
netapi32.dll 0x7fefb0d0000 0x16000 C:\Windows\System32\netapi32.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
FWPUCLNT.DLL 0x7fefb520000 0x53000 C:\Windows\System32\FWPUCLNT.DLL Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
winnsi.dll 0x7fefb5f0000 0xb000 C:\Windows\System32\winnsi.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
IPHLPAPI.DLL 0x7fefb600000 0x27000 C:\Windows\System32\IPHLPAPI.DLL Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
WSHTCPIP.DLL 0x7fefc3c0000 0x7000 C:\Windows\System32\WSHTCPIP.DLL Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
credssp.dll 0x7fefc640000 0xa000 C:\Windows\System32\credssp.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
netutils.dll 0x7fefc670000 0xc000 C:\Windows\System32\netutils.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
bcryptprimitives.dll 0x7fefc680000 0x4c000 C:\Windows\System32\bcryptprimitives.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
rsaenh.dll 0x7fefc740000 0x47000 C:\Windows\System32\rsaenh.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
schannel.dll 0x7fefc7d0000 0x57000 C:\Windows\System32\schannel.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
dnsapi.dll 0x7fefc860000 0x5b000 C:\Windows\System32\dnsapi.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
msv1_0.dll 0x7fefc970000 0x51000 C:\Windows\System32\msv1_0.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
wship6.dll 0x7fefc9d0000 0x7000 C:\Windows\System32\wship6.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
mswsock.dll 0x7fefc9e0000 0x55000 C:\Windows\System32\mswsock.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
cryptsp.dll 0x7fefca40000 0x17000 C:\Windows\System32\cryptsp.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
kerberos.dll 0x7fefca60000 0xb4000 C:\Windows\System32\kerberos.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
bcrypt.dll 0x7fefcb90000 0x22000 C:\Windows\System32\bcrypt.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
ncrypt.dll 0x7fefcbc0000 0x4e000 C:\Windows\System32\ncrypt.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
srvcli.dll 0x7fefccc0000 0x23000 C:\Windows\System32\srvcli.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
cryptdll.dll 0x7fefccf0000 0x14000 C:\Windows\System32\cryptdll.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
secur32.dll 0x7fefcd80000 0xb000 C:\Windows\System32\secur32.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
sspicli.dll 0x7fefd000000 0x25000 C:\Windows\System32\sspicli.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
apphelp.dll 0x7fefd040000 0x57000 C:\Windows\System32\apphelp.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
CRYPTBASE.dll 0x7fefd0a0000 0xf000 C:\Windows\System32\CRYPTBASE.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
RpcRtRemote.dll 0x7fefd150000 0x14000 C:\Windows\System32\RpcRtRemote.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
msasn1.dll 0x7fefd250000 0xf000 C:\Windows\System32\msasn1.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
crypt32.dll 0x7fefd340000 0x167000 C:\Windows\System32\crypt32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
kernelbase.dll 0x7fefd510000 0x6b000 C:\Windows\System32\kernelbase.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
rpcrt4.dll 0x7fefd580000 0x12d000 C:\Windows\System32\rpcrt4.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
ws2_32.dll 0x7fefd6b0000 0x4d000 C:\Windows\System32\ws2_32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
shell32.dll 0x7fefd780000 0xd88000 C:\Windows\System32\shell32.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
sechost.dll 0x7fefe5b0000 0x1f000 C:\Windows\System32\sechost.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
shlwapi.dll 0x7fefe630000 0x71000 C:\Windows\System32\shlwapi.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
imm32.dll 0x7fefe6d0000 0x2e000 C:\Windows\System32\imm32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
usp10.dll 0x7fefe700000 0xc9000 C:\Windows\System32\usp10.dll Microsoft Corporation 1.0626.7601.17514 (win7sp1_rtm.101119-1850)
gdi32.dll 0x7fefe7d0000 0x67000 C:\Windows\System32\gdi32.dll Microsoft Corporation 6.1.7601.17514 (win7sp1_rtm.101119-1850)
msctf.dll 0x7fefe840000 0x109000 C:\Windows\System32\msctf.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
msvcrt.dll 0x7fefe950000 0x9f000 C:\Windows\System32\msvcrt.dll Microsoft Corporation 7.0.7600.16385 (win7_rtm.090713-1255)
ole32.dll 0x7fefeda0000 0x203000 C:\Windows\System32\ole32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
advapi32.dll 0x7fefefb0000 0xdb000 C:\Windows\System32\advapi32.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
lpk.dll 0x7feff090000 0xe000 C:\Windows\System32\lpk.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)
oleaut32.dll 0x7feff480000 0xd7000 C:\Windows\System32\oleaut32.dll Microsoft Corporation 6.1.7601.17514
nsi.dll 0x7feff560000 0x8000 C:\Windows\System32\nsi.dll Microsoft Corporation 6.1.7600.16385 (win7_rtm.090713-1255)

But I'm not clear how I mich use this information to find out what is actually going wrong.

Answer 7

This thread? http://social.msdn.microsoft.com/Forums/en-US/sqldataqualityservices/thread/ce0e9bfa-eb36-40b7-be2a-a24665f018d1

1. There was some command shell thing on installed on his computer called ansicon.exe which tampered with the results from the command prompt running a batch file. It would return 1 no matter which command he ran, even when Success was reported, so the caller thought it failed.

Do you also have Ansicon, or any shell addins?

HKCU\System\Microsoft\Command Processor\AutoRun Reg_SZ: "c:\temp\ansi32\x64\ansicon.exe" -p

2. Can you open the command prompt (elevated as admin) switch into your temp folder to one of the random folder names, such as this one and try to run the batch file manually:

C:\Users\johnste\AppData\Local\Temp\2\v01snfit.rck

Then try the batch file manually:

recreate_schema.bat NC-DATACLEANSE DQS SQL_Latin1_General_CP1_CI_AS'

3. From your process monitor do you see sqlcmd.exe running any work?

The batch file should run these scripts...

recreate_schema.bat.
--> SQLCMD -b -a32767 -S"%DQS_DB_HOST%" -d"%DQS_DB%" -isql\master_recreate.sql
--> --> :r sql\master_create.sql
--> --> --> :r db\static_data.sql
--> --> --> --> [static_data.sql]
PRINT '---[Add Special characters for term normalization]---'
GO
INSERT INTO [A_SPECIAL_CHARACTER_RULE] ([FROM_CHARACTER], [TO_CHARACTER]) VALUES ('''' ,'')

I am wondering if the SQLCMD is not found, or if one of the scripts it not running.

Use the process monitor to see if each file is picked up with success.

False negatives are common in process monitor, so usually you will see a few NOT FOUND on the wrong folder as a process searches for a file or dll before it finds it in the right place with SUCCESS in the right folder.  That is just how windows works - searches several locations for files.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 8

Thanks for getting back to me Jason,

1. I certainly don't have ansicon in the registry, I'm not sure how I would go about checking for "any" powershell addins, but I've looked at all the registry entries that include "Command Processor" and none of them conform to the format in your example.

2. This directory was empty again this morning. I re-ran the installer (from start menu with elevated rights) and this placed a new copy 52fpxil3.sed into my temp/2 directory. 

Navigating into this and running the recreate_schema.bat file from the elevated command prompt appear to run the install correctly though it does not append anything to my log file; the output from the command window is...

C:\Users\johnste\AppData\Local\Temp\2\52fpxil3.sed>recreate_schema.bat NC-DATACL
EANSE DQS SQL_Latin1_General_CP1_CI_AS
.  Trying to connect using Windows Authentication and db name...
Changed database context to 'master'.
Dropping database (DQS_STAGING_DATA)
Creating DQS databases (DQS_MAIN, DQS_PROJECTS, DQS_STAGING_DATA)...
Configuring DQS databases
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE stat
ement to install.
Creating Master Key for database DQS_MAIN...
Creating Module Signing Certificate for database DQS_MAIN...
Exporting Certificate from DQS_MAIN
Importing Certificate into DQS_PROJECTS
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONF
IGURE statement to install.
Configuration option 'xp_cmdshell' changed from 0 to 1. Run the RECONFIGURE stat
ement to install.
Configuration option 'xp_cmdshell' changed from 1 to 0. Run the RECONFIGURE stat
ement to install.
Creating DQS roles
Changed database context to 'DQS_STAGING_DATA'.

 --> Running File: drop_database_properties.sql
Changed database context to 'DQS_PROJECTS'.

 --> Drop all SSDQS Database objects and KB schemas

 --[ Drop all Symmetric Keys ]

 --[ Drop all Certificates ]

 --[ Drop all FK constraints ]

 --[ Drop all views ]

 --[ Drop all tables and synonyms ]

 --[ Drop all database triggers ]

 --[ Drop all stored procedures in Knowledge Base schemas ]

 --[ Drop all types in Knowledge Base schemas ]

 --[ Drop all Knowledge Base schemas ]

 --> Running File: drop_database_properties.sql
Changed database context to 'DQS_MAIN'.

 --> Drop all SSDQS Database objects and KB schemas

 --[ Drop all Symmetric Keys ]

 --[ Drop all Certificates ]

 --[ Drop all FK constraints ]

 --[ Drop all views ]

 --[ Drop all tables and synonyms ]

 --[ Drop all database triggers ]

 --[ Drop all stored procedures in Knowledge Base schemas ]

 --[ Drop all types in Knowledge Base schemas ]

 --[ Drop all Knowledge Base schemas ]

 --> Running File: drop_database_properties.sql
Changed database context to 'DQS_STAGING_DATA'.
Changed database context to 'DQS_PROJECTS'.
Changed database context to 'DQS_MAIN'.

 --> Running File: create_core_db_objects.sql
---[  Creating Certificates  ]---

---[  Creating Symmetric Keys  ]---

---[  Creating Tables  ]---
Creating Table:     A_TEST
Creating Table:     A_TEST2
Creating Table:     A_FLOW
Creating Table:     A_FLOW_ANSWER
Creating Table:     A_EXECUTION_UNIT
Creating Table:     A_CODE_GROUP
Creating Table:     A_CODE_MEMBER
Creating Table:     A_CONFIGURATION
Creating Table:     A_PROCESS
Creating Table:     A_SERVICE_BROKER_TASK
Creating Table:     A_KNOWLEDGEBASE
Creating Table:     A_KNOWLEDGEBASE_AUDIT
Creating Table:     A_KNOWLEDGEBASE_ACTIVITY
Creating Table:     A_PROFILING_ACTIVITY_ARCHIVE
Creating Table:     A_CLIENT_SESSION
Creating Table:     A_REFERENCE_DATA_PROVIDER
Creating Table:     A_REFERENCE_DATA_PROVIDER_SCHEMA
Creating Table:     A_REFERENCE_DATA_CACHE
Creating Table:     A_REFERENCE_DATA_CACHE_SUGGESTION
Creating Table:     A_REFERENCE_DATA_CACHE_SUGGESTION_PARSED
Creating Table:     A_REFERENCE_DATA_AUDIT
Creating Table:     A_IMPORTED_PROJECT
Creating Table:     A_SPELLER_DICTIONARY_VALUE
Creating Table:     A_SPECIAL_CHARACTER_RULE
Creating Table:     A_PERSISTENT_CACHE
Creating Table:     A_TEMPLATE_OBJECTS
Creating Table:     A_TEMPLATE_FOREIGN_KEYS
Creating Table:     A_TEMPLATE_COLUMNS
---[ Creating Views ]---
Creating View:      V_A_FLOW
Creating View:      V_A_KNOWLEDGEBASE
Creating View:      V_A_KNOWLEDGEBASE_AUDIT
Creating View:     V_A_REFERENCE_DATA_PROVIDER
Changed database context to 'DQS_PROJECTS'.
Changed database context to 'DQS_MAIN'.

 --> Running File: static_data.sql
---[ Insert Data ]---

(1 rows affected)

(1 rows affected)

(1 rows affected)
---[Insert Cleansing configuration section]---

(1 rows affected)
---[Insert Logging settings section]---

(1 rows affected)
---[Insert Logging settings section]---

(1 rows affected)
---[Insert Association configuration section]---

(1 rows affected)
---[Insert DataValueService configuration section]---

(1 rows affected)
---[Insert Association rules configuration section]---

(1 rows affected)
---[Insert IndexService configuration section]---

(1 rows affected)
---[Insert Knowledgebase configuration section]---

(1 rows affected)
---[Insert Notification configuration section]---

(1 rows affected)
---[Insert Interactive Cleansing configuration section]---

(1 rows affected)
---[Reference Data configuration section]---

(1 rows affected)
---[Insert client paging configuration section]---

(1 rows affected)
---[Insert client process sampling configuration section]---

(1 rows affected)
---[Matching configuration section]---

(1 rows affected)
---[Profiling configuration section]---

(1 rows affected)
---[Process configuration section]---

(1 rows affected)
---[Reference Data Add provider]---

(1 rows affected)
---[Reference Data Add provider schema]---
---[Add Special characters for term normalization]---

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

(1 rows affected)

C:\Users\johnste\AppData\Local\Temp\2\52fpxil3.sed>

[A LOT further than I had managed before]  :D

However, when I try to connect the client to the server (both on the same VM) I get an error stating that it cannot find stored procedure 'KnowledgebaseManagement.SetDataQualitySession'.

I cannot see a KnowledgebaseManagement schema defined against any of the databases that have now been created on the server. I'm going to go through the process monitor output to see if I can see a script that failed that should have put this in place and I'll get back to you with my results.

Thanks again

JST

Added >> error message from connection attempt...

SQL Server Data Quality Services
--------------------------------------------------------------------------------

Message Id: LogOnWindowFailedToConnect
Cannot connect to NC-DATACLEANSE.

Could not find stored procedure 'KnowledgebaseManagement.SetDataQualitySession'.

--------------------------------------------------------------------------------
System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure 'KnowledgebaseManagement.SetDataQualitySession'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Ssdqs.Infra.Database.DBAccess.ExecCommand()
   at Microsoft.Ssdqs.Proxy.Database.DBAccessClient.Exec()
   at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient.SetDataQualitySession(Nullable`1 clientId, Nullable`1 knowledgebaseId)
   at Microsoft.Ssdqs.Proxy.EntryPoint.BaseEntryPointClient..ctor(String serverName, String databaseName, Nullable`1 clientId, Nullable`1 knowledgebaseId)
   at Microsoft.Ssdqs.Proxy.EntryPoint.NotificationEntryPointClient..ctor(String serverName, String databaseName)
   at Microsoft.Ssdqs.Studio.ViewModels.Data.Common.DataManager.ConnectToDatabase(String instance, String database, Boolean useEncryption)
   at Microsoft.Ssdqs.Studio.ViewModels.ViewModels.Application.LogOnWindowViewModel.ConnectToServer()
   at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousRelayAction.Action()
   at Microsoft.Ssdqs.Studio.ViewModels.Utilities.UIAsynchronousAction.ActionExecuter()

Answer 9

Looking through the results of the process monitor I can see successes on master_recreate.sql and on static_data.sql, so it would appear that all the required scripts are running.  

Answer 10

1. It looks like the batch file ran all the scripts that it is supposed to. Make sure the process monitor shows all of those being picked up from dqsinstaller.exe {

master_create.sql
Running File: drop_database_properties.sql
Running File: create_core_db_objects.sql
Running File: static_data.sql

}

2. In process monitor does it show the location of SQLCMD.exe?

Is it running the one from SQL 2012? Is it using the one from Program Files or Program Files (x86)?

DQSInstaller allows windows to find SQLCMD from the environment PATH variable.

What is your path? From command prompt to see it - SET PATH

Sometimes a broken folder or order of folders in the PATH environment variable affects things. SQL 2012 (110) should be before SQL 2008 (90) or SQL 2005 (80) in the list of folders in the path string if they are installed side-by-side.

3. Which version do you have RTM or CU2? Try installing CU2 update to see if it help. http://support.microsoft.com/kb/2703275

4. You can try to change the temp folder when you launch dqsinstaller from elevated admin prompt, just to make sure there isn't something going wrong there.

SET TMP=C:\temp

DQSInstaller.exe -instance MSSQLServer

5.  A profiler trace might show us something we aren't noticing in the log output, or lack thereof.

Knowing the last query (SQL Batch Starting/ Batch Completed) to run from the DQSInstaller would be interesting, since from the log output we don't know which step of the batch file is breaking. Which table did it create last, or which row did it insert last before the exit code 1.

The log doesn't tell us any of those details. Its just blank...  it was after 2 seconds - which is not much of the work done. I'm not sure if it got logged in or not. Profiler would also show Audit Login / Login Failed events if you measure them.

12/07/2012 13:13:05] Script: 'recreate_schema.bat NC-DATACLEANSE DQS SQL_Latin1_General_CP1_CI_AS'
[12/07/2012 13:13:07]
[12/07/2012 13:13:07]
[12/07/2012 13:13:07] Script process returned unexpected exit code: '1'.

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 11

Hi again Jason,

1. These are only showing up under SQLCMD in process monitor, if I exclude this from the filter I don't see any of the scripts showing up.

2. Process monitor shows sqlcmd at C:\Program Files\Microsoft SQL Server\110\Tools\Binn.  This is a new install on a fresh server, the only references I have to earlier editions is from the backwards compatibility.

my path is ...

C:\Users\johnste\AppData\Local\Temp\2\52fpxil3.sed> set path
Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32
\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft SQL Server\110\DTS\Binn\;C:\
Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\;C:\Program Files\Micros
oft SQL Server\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\110\T
ools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft Visual Studio 10.0\
Common7\IDE\PrivateAssemblies\;C:\Program Files (x86)\Microsoft SQL Server\110\D
TS\Binn\
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC

Changed the temp folder to C;\temp and I can n ow connect the client to the server!

Thanks again.

John

Answer 12

Was changing the TMP folder enough to fix it?

Just wanted to make sure I understood the "fix".

Not sure why these temp folders are not good enough :-)

C:\Users\administrator.RMS\AppData\Local\Temp\2\
C:\Users\johnste\AppData\Local\Temp\2\

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 13

Hi Jason,

I had also installed CU2 and to be fair I cannot recall if I tried again between doing this and changing the temp folder (It had been a long day and my concentration falls off a bit after the first 12 hours)

The process monitor application had shut itself down and I had lost the trace which I had planned to use to verify which was the last file run, also the ...temp/2 folder had cleaned itself out and I ran the DQSInstaller from the start menu (elevated permissions) to repopulate it so I could try again from the elevated command prompt and it what this that ran through to the end.

I had also restrated after the trace and install folder had been cleared down, even though the CU2 install did not request it, just because I'm that old!!

If you need any more info please let me know and I'll tell you what I can, but obviously the urgency has diminished a little from my end.

JST