Shipment Object Does Not Get Unlocked When Using Scalability
Last updated on JULY 09, 2014
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms