WEM agent Synchronization State shows red X instead of green tick.

In WEM Agent
Event viewer - Error happened while synchronizing agent cache.

'Citrix WEM Agent Host Service Debug.log'
Exception: Server unabled to process sync request. ---> System.ServiceModel.FaultException: Server unabled to process sync request.

In WEM Broker
Event viewer - Failed to process sync request "GetChangeBatch". Exception: Dotmim.Sync.SyncException: Procedure or function 'ds_GlobalParameters_selectchanges' expects parameter '@sync_min_timestamp', which was not supplied.

'Citrix WEM Infrastructure Service Debug.log'
Exception -> Failed to process sync request "GetChangeBatch". Exception: Dotmim.Sync.SyncException: The EXECUTE permission was denied on the object 'ds_GlobalParameters_selectchanges', database '', schema 'dbo'. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'ds_GlobalParameters_selectchanges', database '', schema 'dbo'. 
 

1. Set Execute permission to service account (used in Norskale Infrastructure Service service in WEM Broker) in Stored Procedure ds_GlobalParameters_selectchanges in the WEM database.
2. Set the same for account vuemUser.
3. On WEM Broker restart "Norskale Infrastructure Service" service and wait for agent sync delay.
4. To check the result without waiting for the automatic agent sync
   • On WEM Agent (VDA) stop Citrix WEM Agent Host Service service and delete .db files (C:\Program Files (x86)\Citrix\Workspace Environment Management Agent\Local Databases) and then start Netlogon service.
   • Refresh agent cache on VDA by executing this in elevated Command Prompt.

Problem Cause