'Transaction Timed Out After <VAL> Seconds' Occurs During Stock Count Process For Large Data Volumes (Doc ID 2625740.1)

Last updated on JUNE 19, 2023

Applies to:

Symptoms

In Oracle Retail Store Inventory Management (RSIM), when attempting to take snapshot during the Stock Count process, the following error occurs.

ERROR
--------

javax.ejb.EJBException: Transaction Rolledback.; nested exception is:
  weblogic.transaction.internal.TimedOutException: Transaction timed out after 301 seconds
BEA1-2260961F7456E1FB888C
  at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.unwrapRemoteException(RemoteBusinessIntfProxy.java:127)
  at weblogic.ejb.container.internal.RemoteBusinessIntfProxy.invoke(RemoteBusinessIntfProxy.java:99)
  at com.sun.proxy.$Proxy25.markStockCountChildsStarted(Unknown Source)
  at oracle.retail.sim.service.stockcount.StockCountChildServiceClient.markStockCountChildsStarted(Unknown Source)
  at oracle.retail.sim.client.screen.stockcount.StockCountWrapper.markStockCountAsStarted(Unknown Source)
  at oracle.retail.sim.client.screen.stockcount.StockCountChildModel.markStockCountAsStarted(Unknown Source)
  at oracle.retail.sim.client.screen.stockcount.StockCountChildPanel.handleTakeSnapshotUnitAmount(Unknown Source)
  at oracle.retail.sim.client.screen.stockcount.StockCountChildPanel.handleTakeSnapshot(Unknown Source)
  at oracle.retail.sim.client.screen.stockcount.StockCountChildScreen.performNavigationEvent(Unknown Source)
  at oracle.retail.sim.client.core.SimScreen.navigationEvent(Unknown Source)
  at oracle.retail.sim.client.application.SimplifiedApplicationFrame.actionPerformed(Unknown Source)
  at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
  at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
  at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
  at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
  at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
  at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
  at java.awt.Component.processMouseEvent(Unknown Source)
  at javax.swing.JComponent.processMouseEvent(Unknown Source)
  at java.awt.Component.processEvent(Unknown Source)
  at java.awt.Container.processEvent(Unknown Source)
  at java.awt.Component.dispatchEventImpl(Unknown Source)
  at java.awt.Container.dispatchEventImpl(Unknown Source)
  at java.awt.Component.dispatchEvent(Unknown Source)
  at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
  at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
  at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
  at java.awt.Container.dispatchEventImpl(Unknown Source)
  at java.awt.Window.dispatchEventImpl(Unknown Source)
  at java.awt.Component.dispatchEvent(Unknown Source)
  at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
  at java.awt.EventQueue.access$500(Unknown Source)
  at java.awt.EventQueue$3.run(Unknown Source)
  at java.awt.EventQueue$3.run(Unknown Source)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  at java.awt.EventQueue$4.run(Unknown Source)
  at java.awt.EventQueue$4.run(Unknown Source)
  at java.security.AccessController.doPrivileged(Native Method)
  at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)
  at java.awt.EventQueue.dispatchEvent(Unknown Source)
  at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
  at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
  at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
  at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: weblogic.transaction.internal.TimedOutException: Transaction timed out after 301 seconds
BEA1-2260961F7456E1FB888C
  at weblogic.utils.StackTraceDisabled.unknownMethod()

Steps to Reproduce:

1. Sign into SIM.
2. Change Store to the desired location.
3. Navigate to: Inventory Management > Stock Counts
4. Double Click on the physical inventory count record. Child Stock Count List is displayed.
5. Click Take Snapshot.

The cursor changes to the spinning circle icon. On the original Take Snapshot attempt, user is also prompted whether count is occurring before store open > select No, then user is asked if it’s occurring before store open or after store close > select after store close.

Following the initial timeout failure from that snapshot attempt, all subsequent snapshot attempts start processing immediately after clicking Take Snapshot (no prompts about before store open).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.