Time Based Event Execution – Failed Issue

Problem:

From XMPro version 6.1 onwards, a Time-Based event that is configured to run a specific time will fail execution with errors.

Solution:

Make sure that in the following store procedures, the EventDefinition input parameter is NVARCHAR instead of initial VARCHAR

fc_Library_EventManager_SaveEventTrigger
fc_Library_EventManager_SaveEventTriggerHistory
fc_Library_EventManager_UpdateEventTrigger
fc_Library_EventManager_UpdateEventConfiguration

If the EventDefinition input parameter is VARCHAR, update the EventDefinition parameter to NVARCHAR as below: