AIP: PO Stuck in PO_MFQUEUE Table and AIP Connection Issue with RIB After Switching Server, Warning in Log "Resource rib-aip-hosp-managed-datasource_RIBDomain was not assigned to any of these servers" (Doc ID 2296005.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Retail Advanced Inventory Planning - Version 14.1.2 and later
Oracle Retail Integration Bus - Version 14.1.2 and later
Information in this document applies to any platform.

Symptoms

In a Clustered File System environment, after switching from the Primary node to the Secondary (fail-over) node, the Purchase Order's (PO) are stuck in the PO_MFQUEUE table and the following is shown in the Oracle Retail Advanced Inventory Planning (AIP) Online log:

aiponline_ms and rib-aip-server are both Up and running.  Issue only occurs when switched to secondary node/server.  Switching back to the primary node/server, the batch runs without issue and PO flow is successful between AIP and RIB.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms