TIBCO BusinessEvents engine throws java.lang.ClassNotFoundException: while executing Oracle stored procedures.

TIBCO BusinessEvents engine throws java.lang.ClassNotFoundException: while executing Oracle stored procedures.

book

Article ID: KB0088901

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
=========
Error -

Exception occured : com.tibco.cep.runtime.model.exception.impl.BEExceptionImpl: java.lang.RuntimeException: java.lang.ClassNotFoundException: Concepts.Cust_Promotion
     at com.tibco.cep.modules.db.functions.StoredProcsHelper.getConceptsAtIndex(StoredProcsHelper.java:202)

- seen while executing oracle stored procedures.

Environment:
==========
TIBCO Product name and version: TIBCO BusinessEvents (BE) 3.0.2
Operating System(s): All

Symptoms:
========
See above description.

Cause:
=====
Specifying incorrect concept reference in a rule function as shown below could throw this exception.

++++++++
   Concepts.Cust_Promotion[] emps = Database.sp.getConceptsAtIndex(spStmt, 1, "/Concepts.Cust_Promotion");
++++++++
From project customer had concept Cust_Promotion under concepts folder, so the above rule should be
+++++++++
   Concepts.Cust_Promotion[] emps = Database.sp.getConceptsAtIndex(spStmt, 1, "/Concepts/Cust_Promotion");
+++++++++

Note the forward slash (/) instead of dot (.)

Resolution:
========
Change the dot (.) to a forward slash (/) in the rule function.

References:
=========
None

Issue/Introduction

TIBCO BusinessEvents engine throws java.lang.ClassNotFoundException: while executing Oracle stored procedures.