My Oracle Support Banner

ASNOut Message Is Getting Struck In RIB With Error: [E] ORA-01013 (Doc ID 3059726.1)

Last updated on NOVEMBER 20, 2024

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 to 16.0.3 [Release 16.0]
Information in this document applies to any platform.

Symptoms

ASNOut messages which are failing in RIB due to below error
"[E] ORA-01013: user requested cancel of current operation
at com.retek.rib.j2ee.RIBMessageSub".

The messages are not getting processed from RIB and also message data is huge. Attaching the ASNOut message for reference.

Initially this was the issue but after this performance issue happened the long running SQL while processing ASNOut message with 3K+ line item details and ultimately failing with "Exception while processing request: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [procRslt: unknown] Closed Statement - Nested exception: - com.retek.rib.collab.RibAPIException: Error from {call RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [procRslt: unknown] Closed Statement" error, we identified this as a known performance issue in stock ledger package.

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
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.