My Oracle Support Banner

Item Publishers Shutting Down With "Error ORA-06503 : PL/SQL: Function returned with out value returned by program unit RMSMFM_ITEMS.PROCESS_QUEUE_RECORD" (Doc ID 2672724.1)

Last updated on DECEMBER 01, 2021

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Messages from ITEM_MFQUEUE table stops being published. The 8 channels configured to publish messages from ITEM_MFQUEUE table shutdown with an error :

" 2019-09-04 13:00:35,195 [Timer-66] WARN com.retek.rib.collab.general.OracleObjectPublisherComponentImpl - Error from call to GETNXT: Error ORA-06503 : PL/SQL: Function returned with
out value returned by program unit RMSMFM_ITEMS.PROCESS_QUEUE_RECORD "


 Steps to reproduce :

  1. Check to see if there are messages in ITEM_MFQUEUE table.
  2. Process them on 8 threads.

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.