Resolution:
Description:
===========
On startup BusinessEvents throws "SQLException ORA-00942: table or view does not exist" but the backingstore tables are created.

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

Symptoms:
=========
Exception thrown:
Error [CacheCluster.Thread.1] - [jdbcstore] ORA-00942: table or view does not exist
Error [CacheCluster.Thread.1] - [root] java.sql.SQLException: ORA-00942: table or view does not exist
Error [CacheCluster.Thread.1] - [root]     at Oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
...

Cause:
======
Reserved database keyword used for one of the properties of a concept/event

Resolution:
========
1). Rename the property of the concept.

2). Add the property to &ltBE-HOME>/dbkeywordmap.xml

Example for property name UID:

<?xml version="1.0" encoding="UTF-8"?>
&ltkeywords>
    <!-- make sure the map name follows
         the corresponding database
         name length limit -->
    &ltkeyword name="start" mapname="start_"/>
    &ltkeyword name="end" mapname="end_"/>
    &ltkeyword name="schema" mapname="schema_"/>
    &ltkeyword name="mode" mapname="mode_"/>
    &ltkeyword name="index" mapname="index_"/>
    &ltkeyword name="uid" mapname="uid1_"/>
</keywords>

NOTE:You find all reserved Oracle keywords with the following SQL :
--------------------------------------------------------------------
SET linesize 120
SET pagesize 3000
COL KEYWORD FORMAT a30
SELECT *   FROM v$reserved_words ORDER BY keyword;
--------------------------------------------------------------------