LiveCycle ES: process_name missing in Workspace for migrated tasks

Issue

You have migrated to LiveCycle ES from a LiveCycle 7 environment and notice that some of the tasks do not have a process name populated in the task view in Workspace. This problem occurs in the migration scripts, which do not correctly update the task information in the database.

Solution

This issue has been addressed in LiveCycle ES2 (9.0.0.0) and later versions.  A patch is available to solve this issue in LiveCycle ES 8.2.1.2. Contact the Adobe support team if you require this patch and ensure that it is suitable for your environment.

Additional information

The patch can only be applied during the migration process. If you have already migrated and are seeing this issue, the patch will not fix the already migrated tasks in the database. To correct this issue in this situation, manually run the following SQL:

UPDATE tb_task
SET process_name =
 (SELECT tb_process_instance.service_name
 FROM tb_process_instance
 WHERE (tb_process_instance.id = tb_task.process_instance_id))
WHERE process_name IS NULL

You should backup your database before applying the above SQL changes.

reference: (181372257/2526063)

VN:F [1.9.22_1171]
Was this helpful? Please rate the content.
Rating: 0.0/10 (0 votes cast)

Comments are closed.