Unable to complete plan items
Article ID: KB0071954
Updated On:
| Products | Versions |
|---|---|
| TIBCO Order Management | 5.1.x |
Description
When trying to complete a plan item, either through OMSUI or by sending plan item execute response(with completed=true, success=true, cancelled=false),
it remains stuck in EXECUTION and below error in traced in orchestrator logs:
====
2022-09-18 18:09:26,949 ERROR [com.tib.fom.repo.relational.lock.RelationalLockImpl] [acquireLock] - [ThreadID:118] [Tenant ID:T1] Unable to acquire lock for key DEV:cache:Lockservice:orderType:ORDER_1250:T1 after 0 attempts
====
it remains stuck in EXECUTION and below error in traced in orchestrator logs:
====
2022-09-18 18:09:26,949 ERROR [com.tib.fom.repo.relational.lock.RelationalLockImpl] [acquireLock] - [ThreadID:118] [Tenant ID:T1] Unable to acquire lock for key DEV:cache:Lockservice:orderType:ORDER_1250:T1 after 0 attempts
====
Issue/Introduction
This KB article deals with a use case where plan items do not get completed.
Environment
ALL
Resolution
To resolve the issue, execute oms_seed_orderlock.sql script delivered within OM product under below locations:
$OM_HOME/5.1/db/dbscripts/oracle/order/OMS_Seed_OrderLock.sql
$OM_HOME/5.1/db/dbscripts/postgreSQL/order/scripts/oms_seed_orderlock.sql
$OM_HOME/5.1/db/dbscripts/oracle/order/OMS_Seed_OrderLock.sql
$OM_HOME/5.1/db/dbscripts/postgreSQL/order/scripts/oms_seed_orderlock.sql
Feedback
Yes
No
Powered by
