The following unexpected errors occurred:
The following errors occurred during database processing of test results for wpoh0010expub01 :
- Adding test history failed. Failed to end transaction. Inner exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
- Adding web reports data failed. Invalid operation. The connection is closed.
The following errors occurred during database processing of test results for wpoh0010exmbx13 :
- Adding test history failed. Failed to end transaction. Inner exception: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
- Adding web reports data failed. Invalid operation. The connection is closed
The SQL Timeout is set to low for the amout of data that is being written to the database.
To increase the SQL Timeout follow the instructions below.
1. Open registry editor on Spotlight on Messaging Diagnostic Services machine.
2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\Spotlight Management Framework\Diagnostic Services (on 64 bit machine)
HKEY_LOCAL_MACHINE\SOFTWARE\Quest Software\Spotlight Management Framework\Diagnostic Services (on 32 bit machine).
3. Locate DatabaseConnectionString value,:Source=WPOH0014ESQLA04\WPOH0014ESQLA04;Initial Catalog=SpotlightManagementFramework;Trusted_Connection=Yes;Connection Timeout=30
4. Change the Timeout=60 and save the changes.
