AppSync: SQL copies fail during the freeze-thaw phase due to MSSQL backup errors

Summary: Appsync copies of SQL databases fails when running the MSSQL backup of the SQL database due to a timeout.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

No changes were made in the customer environment.
 

Appsync is unable to take a consistent copy of an SQL database. The Service Plan events will show :

Sat 06/18/2016 06:30:22 AM Create local copy    SQL_000011    ServerName1 Backup failed to complete in the time allotted. Verify database maintenance is not running and no other backups are running. Try running the service plan with fewer databases. 
Sat 06/18/2016 06:30:22 AM Create local copy    SQL_000114    ServerName1 Starting backup of SQL Server databases. 

The AppSync Plugin log will show:
 
2016-06-18 06:30:25.790 ERROR [14112]  []           [ServerName1] [xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx] Unable to get the value for query key CC_AGENT_THREAD_WAIT_TIME. Error: The system cannot find the file specified. 


A subsequent attempted mount of the same Appsync SQL Copy fails with the following in the Service Plan Events :


Sat 06/18/2016 06:47:24 AM    Recover copy    SQL_000106    ServerName2 Failed to open the metadata file C:\AppSyncMounts\ServerName1\APPSYNC_VDI_ServerName1_SQLDBName.bin for the RESTORE operation. The error number is 2. If using Windows authentication, make sure the user account has full control permissions to the directory.' 
Sat 06/18/2016 06:47:24 AM    Recover copy    SQL_000034    ServerName2 An error occurred during recovery; disconnecting from database SQLInstance.SQLDBName. 

Cause

After the SQL DB freeze, Appsync does not wait for the MSSQL backup of the database to complete in time.

The following registry keys under HKEY_LOCAL_MACHINE\SOFTWARE\EMC\AppSync  were missing on the Production SQL server :

Name                          Type               Data
CCAGENT_THREAD_WAIT_TIME      REG_DWORD          1200
CC_SQL_VDI_TIMEOUT            REG_DWORD          1200



 

Resolution

Resolution:

Create the following 2 missing registry entries on the Production host in HKEY_LOCAL_MACHINE\SOFTWARE\EMC\AppSync.
The type is REG_DWORD, and the value should be 1200.

CCAGENT_THREAD_WAIT_TIME
CC_SQL_VDI_TIMEOUT  

After the registry changes, Restart the AppSync host plugin Service.
 
Please ensure any passive nodes are updated as well if this is a Cluster and the same registry entries are also found to be missing on other nodes of the Cluster. 

Affected Products

AppSync

Products

AppSync
Article Properties
Article Number: 000056630
Article Type: Solution
Last Modified: 18 Sept 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.