My Oracle Support Banner

RIB RMS Publishing Adapters Are Failing (Doc ID 2916142.1)

Last updated on DECEMBER 16, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Symptoms

Receiving error "ORA-02049: timeout: distributed transaction
waiting for lock" error from the MFCS end.

Receiving the below error in the logger_logs.

RMSMFM_ITEMS.UPDATE_QUEUE_TABLE error iteration 1 O_err_code: 2049
O_err_data: ORA-02049: timeout: distributed transaction waiting for lock
seq_no:5909239 rowid: 5909239
ORA-24381: error(s) in array DML
"
"Number RMSMFM_ITEMS.UPDATE_QUEUE_TABLE bulk failures: 45
ORA-24381: error(s) in array DML
"
" object line object
  handle number name
0x25be0b6610 1112 package body RMS01.RMSMFM_ITEMS
0x25be0b6610 812 package body RMS01.RMSMFM_ITEMS
0x25be0b6610 391 package body RMS01.RMSMFM_ITEMS
0x25be773110 1 anonymous block
ORA-24381: error(s) in array DML
ORA-06512: at "RMS01.RMSMFM_ITEMS", line 1070

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.