Posts tagged "ALC-UPG-040-000"

LiveCycle ES: ALC-UPG-040-000 UpgradeException: Invalid Join: process_instance

Issue

When you upgrade your LiveCycle 7 environment to LiveCycle ES 8.2.1, the following exception may occur during the Migrate Essential Data step while running the LCM:

[2010-03-11 10:33:11,699], SEVERE, Thread-54, com.adobe.livecycle.upgrade.control.PhaseRunner, Aborting. Invocation of method 
[migrateCriticalData] failed for com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin. Caught 
com.adobe.livecycle.upgrade.UpgradeException, message: ALC-UPG-040-000: Internal error: ALC-UPG-040-000: 
Internal error: Invalid Join: process_instance
com.adobe.livecycle.upgrade.UpgradeException: ALC-UPG-040-000: Internal error: ALC-UPG-040-000: 
Internal error: Invalid Join: process_instance
 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: Invalid Join: process_instance
 at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.migrateWorkflow7Templates(WorkflowUpgradePlugin.java:392)
 at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.execute(WorkflowUpgradePlugin.java:314)
 ... 7 more
Caused by: java.lang.RuntimeException: Invalid Join: process_instance
 at com.adobe.pof.omapi.AbstractQueryCompoundExpression.addObjectFilter(AbstractQueryCompoundExpression.java:571)
 at com.adobe.pof.omapi.AbstractQueryCompoundExpression.addFilter(AbstractQueryCompoundExpression.java:325)
 at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.updateProcessInstanceWithServiceInfo(WorkflowUpgradePlugin.java:1368)
 at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.upgradeLC7ProcessTypeToService(WorkflowUpgradePlugin.java:487)
 at com.adobe.livecycle.upgrade.workflow.WorkflowUpgradePlugin.migrateWorkflow7Templates(WorkflowUpgradePlugin.java:386)
 ... 8 more
[2010-03-11 10:33:11,803], INFO, AWT-EventQueue-0, com.adobe.livecycle.upgrade.gui.UpgradePhaseDialog, ALC-UPG-040-000: 
Internal error: ALC-UPG-040-000: Internal error: ALC-UPG-040-000: Internal error: Invalid Join: process_instance

Additional information

Corruption in the LiveCycle ES database can cause this error.  The database can get corrupted if there were any manual modifications, or SQL statements run on the DB, or if you are using an external (not from Adobe) purge utility on the DB.

Solution

  1. Restore the database to a valid state before running the LCM.
  2. Make sure that there are no SQL queries running on the LiveCycle ES Database, before the LCM has run.

reference: (181485096/2526063)

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

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)