Shipment Object Does Not Get Unlocked When Using Scalability
(Doc ID 731306.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Transportation Management - Version: 5.5.04 to 5.5.04.03
This problem can occur on any platform.
When using scalability, ConsolOrderBundle Object lock fails to unlock the shipment after successfully planning the order on a console shipment. The next orders that needs to be booked on the same console shipment fails as the system cannot get the lock.
The SECONDARY appserver doesn't unlock BulkPlanPartition like on the DEFAULT one.
2008-06-09 09:47:40.686 1718068 Debug ObjectLock Releasing BulkPlanPartition: UPM.2350625 lock for
ConsolOrderBundle agentUtility - 3
2008-06-09 09:47:40.686 1718068 Debug DataSource Retrieving OBJECT_LOCK connection via profile
DEFAULT: source DEDICATED_DBA agentUtility - 3
2008-06-09 09:47:40.686 1718068 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 */; 839313 agentUtility - 3
Also from the logs:
2008-06-09 09:48:01.491 719626 Debug Agent Action If returns true agentUtility - 8
2008-06-09 09:48:01.491 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
2008-06-09 09:48:01.491 0 Debug ObjectLock Requesting SHIPMENT: UPM.2350625 lock for DIRECT SQL
UPDATE (AGENT) agentUtility - 8
2008-06-09 09:48:01.491 0 Debug DataSource Retrieving OBJECT_LOCK connection via profile DEFAULT:
source DEDICATED_DBA agentUtility - 8
2008-06-09 09:48:01.491 0 Debug Sql select 1 from object_lock where lock_type=? and object_id=? /*
DBA */; http://SHIPMENT, UPM.2350625 agentUtility - 8
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
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