Posts tagged "ALC-UPG-040-005"

LiveCycle ES: “ALC-UPG-040-005: Exception Migrating Workflow Tasks” Error while migrating the DB in LCM

Issue

When migrating from a LC7 to a LC ES server, you may receive the following exception during the “Migrating Essential Data” step in LiveCycle Configuration Manager:

ALC-UPG-040-005: Exception Migrating Workflow Tasks: [97,571]
com.adobe.livecycle.upgrade.UpgradeException: ALC-UPG-040-000: Internal error: ALC-UPG-040-000: Internal error:
ALC-UPG-040-005: Exception Migrating Workflow Tasks: [97,571]
at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.execute(WorkflowUpgradePlugin.java:320)
at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.migrateCriticalData(WorkflowUpgradePlugin.java:226)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.adobe.livecycle.upgrade.control.PhaseRunner.run(PhaseRunner.java:217)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.adobe.livecycle.upgrade.UpgradeException: ALC-UPG-040-000: Internal error:
ALC-UPG-040-005: Exception Migrating Workflow Tasks: [97,571]

Reason

This will occur when a task has been started by opening a form in Form Manager, but a process was never initiated, probably because the user just closed the form again without submitting. The task has no corresponding entry in the TB_ASSIGNMENT table in the DB.

Solution

The solution in this case is to delete the task entry manually from the database, as it does not affect any running processes. This is a very rare case and should not show up at all in most installations. Here is an SQL statement you can use to search for such tasks in the DB before running LCM.

_____________________________________________

select * from tb_task tsk where
not exists (select 1 from tb_assignment assign where assign.id=tsk.current_assignment_id) or ((tsk.process_instance_id > 0) and
not exists (select 1 from tb_process_instance proc where proc.id=tsk.process_instance_id)) or ((tsk.action_instance_id > 0) and
not exists (select 1 from tb_action_instance act where act.id=tsk.action_instance_id)) or
not exists (select 1 from edcprincipalentity ent where ent.id=tsk.create_user_id) or
not exists (select 1 from tb_form_data form where tsk.form_data_id=form.id)

_____________________________________________

reference: (180999333/2360548)

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