When EMS is configured to use an Oracle database store with the OCI driver, on startup EMS will throw an error containing nonsensible strings.

When EMS is configured to use an Oracle database store with the OCI driver, on startup EMS will throw an error containing nonsensible strings.

book

Article ID: KB0088671

calendar_today

Updated On:

Products Versions
TIBCO Enterprise Message Service -
Not Applicable -

Description

Resolution:
Description:
============
When EMS is configured to use an Oracle database store with the OCI driver, on startup EMS will throw an error containing nonsensible strings.

Environment:
===========
ALL

Symptoms:
========
When EMS is configured to use Oracle database store with OCI driver, the following exception is thrown. The exception string may vary depending on the character encoding setting on the Oracle server side.

2012-03-29 20:22:02.885 com.tibco.tibems.tibemsd.internal.db.EMSDataStoreException: failed to open store: &ltU+0E00>??
2012-03-29 20:22:02.885         at com.tibco.tibems.tibemsd.internal.db.DataStore._checkValidConnParams(DataStore.java:265)
2012-03-29 20:22:02.885         at com.tibco.tibems.tibemsd.internal.db.DataStore.open(DataStore.java:287)
2012-03-29 20:22:02.885         at com.tibco.tibems.tibemsd.internal.db.CallableDataStore.open(CallableDataStore.java:122)
2012-03-29 20:22:02.885         at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
2012-03-29 20:22:02.885         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
2012-03-29 20:22:02.885         at java.lang.reflect.Method.invoke(Method.java:597)
2012-03-29 20:22:02.885         at com.tibco.tibems.tibemsd.internal.Context.invokeMethodInLine(Context.java:308)
2012-03-29 20:22:02.885 SEVERE ERROR: Unable to open store [$sys.nonfailsafe]: [ ESTATUS = 230, ERRSTR = co

Resolution:
==========
Add orai18n.jar (which is located at ORACLE_HOME/jlib) into the classpath of tibemsd.conf . The orai18n.jar file contains many important character setd and global support files.

Issue/Introduction

When EMS is configured to use an Oracle database store with the OCI driver, on startup EMS will throw an error containing nonsensible strings.