Error "A server error occured: Failed to get resource manifest from database for delta synchronization" occurs when trying to perform a Barcode sync
Last Updated October 21, 2014
When trying to synchronize assets using Barcode, the error "Error "A server error occured: Failed to get resource manifest from database for delta synchronization" occurs when trying to perform a Barcode sync" occurs.
A server error occured: Failed to get resource manifest from database for delta synchronization.
A server error occurred: Failed to get complete resource list from Database
This can be caused by missing, customized or corrupted Barcode stored procedures in the Symantec_CMDB database.
This can also be caused by a timeout when trying to sync too many assets for Barcode to handle.
Depending on the cause, one of two solutions are available:
Cause: If Barcode has missing, customized or corrupted stored procedures, this error will occur at the beginning of a sync. Solution: Recreate the Barcode stored procedure by running AeXConfigure.
Optional: If the user is aware that Barcode stored procedures have been customized, first back these up in SQL Server Management Studio before proceeding.
On the Symantec Management Platform server, open a command prompt as a Windows Administrator user.
Navigate to the directory "<Install_drive>:\Program Files\Altiris\Notification Server\Bin".
Type and run the following command. This will recreate all Barcode stored procedures, including replacing any customized Barcode ones. The user may want to back these up if they do have customized Barcode Stored procedures before running this command.
This command can take several minutes to run and will take the Altiris Service offline. Once it finishes,the Altiris Service will automatically come back online. It is therefore recommended to run this off production hours or during a maintenance period. Also, if this command returns a list of syntax usage (slash commands), then the command was typed incorrectly. A successful execution will take a few minutes and then once finished, doesn't display any results.
WARNING: If the user had previously customized any Barcode stored procedures, before readding these changes, first make sure that the recreated out of box stored procedures have resolved the sync issue. If so, readd the customizations. If the issue then reoccurs, the user will need to troubleshoot and resolve their customizations or decide to use the out of box stored procedures that work.
Cause: A timeout occurs when trying to sync too many assets for Barcode to handle, which may occur around 30 minutes or so into the attempted sync. Answer: Reduce the amount of assets to sync and/or improve the Symantec Management Platform's performance. For more information about this solution, refer to the following article: