Shipment Object Does Not Get Unlocked When Using Scalability
(Doc ID 731306.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 5.5.04 to 5.5.04.03 [Release 5.5]
Information in this document applies to any platform.
This problem can occur on any platform.
-- Problem Statement:
When using scalability, ConsolOrderBundle Object lock fails to unlock the shipment after successfully planning the order on a console shipment. The next order that needs to be booked on the same console shipment fails as the system cannot get the lock.
The SECONDARY appserver does not unlock BulkPlanPartition like on the DEFAULT one.
<DATE TIME> <VALUE> Debug ObjectLock Releasing BulkPlanPartition: UPM.<NUMBER> lock for
ConsolOrderBundle agentUtility - 3
<DATE TIME> <VALUE> Debug DataSource Retrieving OBJECT_LOCK connection via profile
DEFAULT: source DEDICATED_DBA agentUtility - 3
<DATE TIME> <VALUE> Debug Sql update object_lock set owner_machine_gid=null,
owned_since=null, activity=null, log_process_id=null, owner_sequence=null where owner_sequence=?
/* DBA */; <VALUE> agentUtility - 3
Also from the logs:
<DATE TIME> <VALUE> Debug Agent Action If returns true agentUtility - 8
<DATE TIME> 0 Debug Agent Publishing topic DBUpdate: sqlStatement=call
upmowner.upm_bulk_recharge_shipment.set_gl_code($GID), statementType=Plain SQL Statement,
refreshCache=false (SHIPMENT_CREATE_AND_MODIFY_MAIN_V2A) on queue DBUpdates, group null
agentUtility - 8
<DATE TIME> 0 Debug ObjectLock Requesting SHIPMENT: UPM.<NUMBER> lock for DIRECT SQL
UPDATE (AGENT) agentUtility - 8
<DATE TIME> 0 Debug DataSource Retrieving OBJECT_LOCK connection via profile DEFAULT:
source DEDICATED_DBA agentUtility - 8
<DATE TIME> 0 Debug Sql select 1 from object_lock where lock_type=? and object_id=? /*
DBA */; http://SHIPMENT, UPM.<NUMBER> agentUtility - 8
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
The steps to reproduce are unknown, but the above messages appear in the log
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document