If you are using LiveCycle ES to search for processes using the adminui, then you may notice that not all processes are listed under the “Process Name – Version” drop-down list. Only processes which are activated in Workbench, and which have process instances in the TB_PROCESS_INSTANCE table in the database, will show up in this drop-down list.
Check that the process is activated in Workbench, and then you can run the following SQL query to verify that there are existing process instances for that process:
select distinct service_name, count(id) from tb_process_instance
group by service_name
order by service_name
If you are using the Administration UI for Process Management and particularly the stalled operations/branches views in LiveCycle ES 8.2.1, you may notice it takes a long time to return the list of stalled items, particularly if there are many pages to be returned. In some environments a delay of up to 1 minute can be observed which would be unacceptable for a production environment where the IT team need to be able to react quickly to any stalled instances in production.
This issue has been reported mainly with Oracle databases.
The following SQL statements will add indexes to the appropriate tables in the LiveCycle database which will greatly improve the performance of these AdminUI views:
CREATE INDEX status_idx ON tb_action_instance(status);
CREATE INDEX sub_status_idx ON tb_branch_instance(sub_status);
These indexes need to be created manually in ES (8.x) and ES2 (9.x) as they cannot be applied through ServicePacks. The issue is fixed in ADEP (ES3).
After you upgrade from LiveCycle 7 to LiveCycle ES 8.2.1, some of the processes in the Admin user interface and Workspace appearing as “null – 0.0”.
Corruption in the LiveCycle ES database causes process names and versions to be listed in the Admin user interface as “null – 0.0.”. The corruption can be caused if the database content has been modified manually, or if you are using an external (not from Adobe) purge tool on the database.
Restore the database to a valid state.