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.
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 :
- Check to see if there are messages in ITEM_MFQUEUE table.
- Process them on 8 threads.
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