Database Objects (RULE SET) In RIB AQ Database Become Invalid (Doc ID 1300869.1)

Last updated on JUNE 06, 2016

Applies to:

Oracle Retail Integration Bus - Version 13.0.2 and later
Information in this document applies to any platform.

Symptoms

Some of the Database Objects (DBA_OBJECTS) of type RULE SET come up with 'INVALID' status in the Retail Integration Bus Advance Queuing (RIB AQ) database.

This issue is observed in the following scenarios:

A) After cloning of one RIB instance from other instance / environment.
     Before cloning they may work fine but after cloning of  the RIB AQ database, they come up with invalid objects.

B) Exporting / Importing of RIB AQ schema from one RIB environment to other.

C) After re-installing RIB also, facing the same issue. Below are the steps which are followed:

  1. Delete RIBAQ User and TAFR hospital (TAFRHOSP) User
  2. Delete all the oc4j instances
  3. Re-create All oc4j instances
  4. Re-create RIBAQ and TAFRHOSP Schema
  5. Re-install RIB

Full compilation of database packages, types, and synonyms also may not help.

With this invalid rule sets, messages will not get processed and also adapters may tip down.

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