PVM_WORK_ITEM indexes not updated during an upgrade to BPM Enterprise 4.3.x
Article ID: KB0071710
Updated On:
| Products | Versions |
|---|---|
| TIBCO BPM Enterprise (formerly TIBCO ActiveMatrix BPM) | 4.3.0, 4.3.1, 4.3.2 |
Description
After an upgrade to 4.3.0 or 4.3.1 or 4.3.2 from a prior version (4.2.0 or lower), the QUEUE_ID and STATUS columns are indexed with index name IDX_PVM_WI_QID_S. This is incorrect.
The upgrade is supposed to drop this index and re-create it with additional columns - TARGET_ID and TARGET_SPACE. This is only applicable to environments configured on an Oracle database.
The upgrade is supposed to drop this index and re-create it with additional columns - TARGET_ID and TARGET_SPACE. This is only applicable to environments configured on an Oracle database.
Issue/Introduction
PVM_WORK_ITEM indexes not updated during an upgrade to BPM Enterprise 4.3.x
Environment
DB: All supported Oracle database versions
Resolution
Please follow the below steps after the upgrade to 4.3.0 or 4.3.1 or 4.3.2 is complete -
1. Stop all BPM nodes
2. Drop the existing index -
DROP INDEX IDX_PVM_WI_QID_S;
3. Re-create the index with the correct columns -
CREATE INDEX IDX_PVM_WI_QID_S ON PVM_WORK_ITEM ("QUEUE_ID", "STATUS", "TARGET_ID", "TARGET_SPACE");
4. Start all BPM nodes
Additional Information
Internal reference id - WRM-11864
Feedback
Yes
No
Powered by
