Quest ChangeAuditor Coordinator service starts and stops after new ChangeAuditor installation (4250566)

The Quest ChangeAuditor Coordinator service starts and stops after new ChangeAuditor installation and an error similar to the following is recorded in the Coordinator Log (typically located in '%SystemDrive%\Program Files\Quest Software\ChangeAuditor\Service\ChangeAuditor.Service.exe.nptlog')

Error Error: 50000, Procedure: dbo.usp_ErrorLog_Insert, Message: Error: 8649, Procedure: dbo.usp_Data_AlertType_Load, Message: The query has been canceled because the estimated cost of this query (yyyy) exceeds the configured threshold of xxx. Contact the system administrator. Executing SQL:

* yyyy is the estimated cost of the query and xxx is the Microsoft SQL server Query Governor setting