My Oracle Support Banner

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

Last updated on JANUARY 08, 2020

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.

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

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
Symptoms
Changes
Cause
Solution
References


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