Timeout on usp_QueryTree stored procedure when opening when opening archive databases (4353219)

Rare issue with ChangeAuditor Client hanging / timing out when when opening archive databases.

With either an upgrade of the ChangeAuditor Archive via the Client or a database direct connection from the Client to the Archive database(s), the Client may hang / timeout indefinitely and in the log files, you will see one or more entries similar to:

SQL error: TIMEOUT on usp_QueryTree

WORKAROUND

- Using SQL Server Management Studio, first run this command against the Archive Database(s) that seem to have this issue:

==========
Select * FROM Query.Folder
WHERE FolderID = '00000000-0000-0000-0000-000000000000'
AND FolderName = 'Local'
==========

- If any results are returned, run this SQL query against the same database.

==========
DELETE FROM Query.Folder
WHERE FolderID = '00000000-0000-0000-0000-000000000000'
AND FolderName = 'Local'
==========

- Re-open the ChangeAuditor Client and again attempt to connect to the Archive Database(s).

STATUS

Waiting for fix in a future release of Change Auditor .