THIS ARTICLE APPLIES TO:
Migrated Workflows in Channels 9.4 and higher.
ISSUE DESCRIPTION:
Migration of workflows from Channels 9.1 works for fresh upgrades to Channels 9.4.0.6 (9.4 CU6) and later. In deployments that have upgraded to Channels 9.2 or Channels 9.4, migration is already accomplished, and some migrated workflows fail to execute.
ROOT CAUSE:
In versions prior to Channels 9.4, on executing the CommCore Workflow Migration tool, the WorkflowFilter::Status is set to ‘0’ (disabled) for all the migrated "scheduled workflows", due to which the workflows fail to execute.
SOLUTION OR WORK AROUND:
The Commcore Migration tool shipped in version 9.4 CU7, has been updated to fix this issue.
However, in deployments that have upgraded from prior versions to Channels 9.4, Channels system administrators must perform the following steps to work around this issue and enable the scheduled workflows that have been migrated from the earlier versions.
- Stop all of the Commcore and Channel Services.
- Login to Channels Database(Main) using "SQL Management studio".
- Execute the following SQL query on the database.
UPDATE WorkflowFilter SET STATUS = 1
WHERE Filterid
IN (
SELECT WWF.FilterId FROM ScheduleNTask AS SNT
JOIN WorkflowFilter AS WWF
ON SNT.taskid = WWF.workflowid AND SNT.tasktype = 3
); - Start all the services stopped in step 1.
AFFECTED SYSTEMS & USERS:
Channels 9.2 and Channels 9.4 users.
ADDITIONAL INFORMATION:
The path for users migrating Channels CommCore workflows from versions prior to Channels 9.2 is:
Channels 9.1(or prior) to Channels 9.4.0.7.
Channels 9.2, and Channels 9.4 users must note that workflows in their deployments are already migrated as a result upgrading to the higher versions. They must not use the Channels 9.4.0.7 workflow migration tool.
ESCALATION PROCEDURE:
If you have additional questions, please contact our Support team at 877-373-7848 (option 2) or via email at support@gomoxie.com.