Resolution:
Description:
==========
BE engine throws an  IndexOutOfBoundsException when using an SQL server for the backing store.

Environment:
==========
TIBCO BusinessEvents 3.0.1 with HF 6 and above.
Microsoft SQL Server 2005/2008
All OS


Symptoms:
=========
The BE engine throws the following exception in the logs.

Configurations/Communications/SQL_SERVER_Connection.sharedjdbc uses oracle mapping scheme

[18:03:48.269] Initializing DB connection pool - Key=/Shared Configurations/Communications/SQL_SERVER_Connection.sharedjdbc,i

nitialSize=2, minSize=2, maxSize=5

[18:03:48.269] Enforce pool size=false,WaitTimeout=1,InactivityTimeout=900, Failover To=

[18:03:48.270] java.lang.RuntimeException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0


Cause:
=====
Incorrect setting for the property be.jdbc.dburi.strategy.0 in the BE engine TRA file (the TRA file used to start the BE engine).

Resolution:
=========
Set the following property in the engine TRA file:  

be.jdbc.dburi.strategy.0 jdbc
(Or)
be.jdbc.dburi.strategy.0=jdbc

Then restart the BE Cache Server and Inference Agents.

TIBCO BusinessEvents (BE) engine started in Cache Server mode, then throws IndexOutOfBoundsException when using SQL server as backing store.