My Oracle Support Banner

RFI Supplier Service Adapter in Hung State (Doc ID 2992518.1)

Last updated on DECEMBER 18, 2023

Applies to:

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

Goal

Even after RFI server was bounced, still the issue of "Supplier Service Adapter getting into Hung State" happened again after few days and the adapter stopped processing data from RFI Staging tables with below log entries seen in Supplier.log:

2023-11-26T17:13:47,186 [Timer-42428] INFO RfiSupplierService - ***** This run considering 2 Supplier Stage records for processing *****
2023-11-26T17:13:47,186 [Timer-42428] DEBUG RfiSupplierService - Acquring lock on rfi_timer_control in processStagingRecords for exec Id -1549724368 at 2023-11-26T17:13:47
2023-11-26T17:13:47,186 [Timer-42428] DEBUG RfiLockTimerOracleDao - Before executing select to lock record in RfiLockTimerOracleDao
2023-11-26T17:13:47,187 [Timer-42428] DEBUG BaseOracleDao - EXECUTING : SELECT interface_name from rfi_timer_control where interface_name = ? for UPDATE[SUPPLIER]

 

Solution

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