TIBCO BusinessEvents engine with backing store feature, throws the error "ORA-01000:maximum open cursors exceeded".

TIBCO BusinessEvents engine with backing store feature, throws the error "ORA-01000:maximum open cursors exceeded".

book

Article ID: KB0094257

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
TIBCO BusinessEvents engine with backing store feature, throws error in the log:

"[inference-class$DBWriter.Thread.2] - [jdbcstore] Check failed. Unable to connect to database
[inference-class$DBWriter.Thread.2] - [root] DBNotAvailableException:DatabaseException : Database Not Available.,         Exception=ORA-01000: maximum open cursors exceeded"


Environment:
===========
BusinessEvents 4.0
All Operating Systems

Symptoms:
=========
Exception in log

Cause:
======
Oracle OCI driver used instead of the Oracle Thin driver.


Resolution:
========
Use the Oracle Thin driver for JDBC SharedResource.

Issue/Introduction

TIBCO BusinessEvents engine with backing store feature, throws the error "ORA-01000:maximum open cursors exceeded".