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
- Restore the database to a valid state before running the LCM.
- Make sure that there are no SQL queries running on the LiveCycle ES Database, before the LCM has run.
reference: (181485096/2526063)


