Client fails to connect to Coordinator (4300381)

Client fails to connect to Coordinator

After upgrade to 7.0.2:

• Coordinator service is running and events are coming in.
• Client fails to connect to Coordinator with error

Value cannot be null. Parameter name: unsecured

 

VSTS 129909

This is due to a change in version 7.0.2 expecting for a non Null value in the Shared Folder Configuration

To confirm the issue, 

• Open SQL Management Studio
• Connect to the SQL Server that contains the Change Auditor database
• Click New Query
• Select the Change Auditor database from the database drop-down box
• Paste the following command in the Query window

SELECT * FROM [Report].[SharedFolder]

• Click Execute

0 NULL NULL NULL

• Click New Query
• Select the Change Auditor database from the database drop-down box
• Paste the following command in the Query window

DELETE FROM [Report].[SharedFolder] WHERE FolderPath IS NULL

• Click Execute
• Close SQL Management Studio

The issue is fixed in versions 7.0.2.9805 and later.

VSTS129909

The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.