My Oracle Support Banner

Third Party Stock Count Import Batch Fails With 'Transaction timed out after 7201 seconds ' Error For Large Data Volume (Doc ID 2972580.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

Third party stock count batch is failing after 2 hrs with below Error:

ERROR
-----------------------
javax.ejb.EJBException: Transaction Rolledback.: weblogic.transaction.internal.TimedOutException: Transaction timed out after 7201 seconds

STEPS

1. Create a Product Group with count method Third party
2. Add all departments to the product group in the product group components screen.
3. schedule the count.
4. take snapshot.
5. Upload the file to File Transfer Service. (File should have approx. 6,00,000 items)
6. Run the Third-party stock count import batch.


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.