Posts tagged "tasks"

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)

LiveCycleES: description of manual tasks after upgrading from LiveCycle 7

For anybody looking for more information about migration from LiveCycle 7.x to LiveCycle ES, there are some manual steps involved which you should know about so that you can plan your resources and testing around this.

The main manual tasks are:

  1. Upgrade process using Upgrade tool
  2. Delete init-forms
  3. Change each form variable type from ‘lc7form’ to ‘xfaform’
  4. Set render/submit service for each xfaform variable
  5. Remapping User QPAC’s input and output variables (in LiveCycle 7.x, the input can be a variable name, but in LiveCycle ES, it must be an xPath expression), if multiple User QPACs are used in a process, you have to remap the input/output one-by-one.
  6. Activate the new process version

You can find more information on each of the steps above in the LiveCycle Workbench ES documentation below.
Upgrading processes in LiveCycle Workbench:
http://livedocs.adobe.com/livecycle/8.2/wb_help/wwhelp/wwhimpl/js/html/wwhelp.htm
…see the section under Creating Processes > Upgrading processes, particularly the section on Performing Upgrades.

For LiveCycle Workbench ES2.5 you should read the following documentation:
http://help.adobe.com/en_US/LiveCycle/9.5/WorkbenchHelp/WS92d06802c76abadb4e389e8612826be7e6a-8000.html

More information about the tasks involved in upgrading a process that uses an init-form bound to a schema:
http://kb2.adobe.com/cps/404/kb404420.html

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