Messages Sent from Retail Merchandising System (RMS) Not Picked Up By Retail Integration Bus (RIB) (Doc ID 858086.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Integration Bus - Version 12.0.1 and later
Information in this document applies to any platform.
Checked for relevance 07-Mar-2012
Checked for relevance Dec-2013


Symptoms

For a Retail 12.0 environment, none of the messages are getting picked up by RIB from RMS staging tables.  Hence, no data flow from RMS is occurring via RIB.  All the messages are stuck in the *_MFQUEUE tables.

RIB logs show the below error:

java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath):
oracle-character-set-32
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Compiled Code))
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java(Inlined Compiled Code))
at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java(Inlined Compiled Code))
at oracle.sql.CharacterSetUnknown.toString(CharacterSetFactoryThin.java(Compiled Code))
at oracle.sql.CHAR.getString(CHAR.java(Inlined Compiled Code))
at com.retek.rib.collab.OracleStructDumper.dumpStruct(OracleStructDumper.java(Compiled Code))
at com.retek.rib.collab.OracleStructDumper.dumpit(OracleStructDumper.java(Compiled Code))
at com.retek.rib.collab.OracleStructDumper.dumpit(OracleStructDumper.java(Inlined Compiled Code))
at com.retek.rib.collab.general.OracleObjectPublisherComponentImpl.processResult(OracleObjectPublisherComponentImpl.java(Compiled Code))
at com.retek.rib.collab.general.GeneralPublisherHelper.checkResult(GeneralPublisherHelper.java(Compiled Code))
at com.retek.rib.collab.general.GeneralPublisherHelper.execute(GeneralPublisherHelper.java(Inlined Compiled Code))
at com.retek.rib.collab.general.GeneralPublisherHelper.produceMessage(GeneralPublisherHelper.java(Inlined Compiled Code))
at com.retek.rib.collab.general.GeneralPublisherHelper.createAndPublishMessages(GeneralPublisherHelper.java(Compiled Code))
at com.retek.rib.collab.general.GeneralPublisherHelper.createAndPublishMessages(GeneralPublisherHelper.java(Inlined Compiled Code))
at crGeneralPublisher.executeBusinessRules(crGeneralPublisher.java(Compiled Code))
at com.stc.jcsre.JCollaboration.translate(JCollaboration.java(Compiled Code))
at com.stc.common.collabService.JCCollabControllerImpl.translate(JCCollabControllerImpl.java(CompiledCode))

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