Resolution:
Description:
=========
Cache server fails with  Missing IN or OUT parameter at index exception .

Environment:
==========
TIBCO BusinessEvents 3.0.2

Symptoms:
=========
2012 Sep 25 12:25:56:743 GMT -5 BPELOCAL-M1-CS-1 Error [WriteBehindThread:CacheStoreWrapper(com.tibco.be.oracle.BECoherenceOracleStore)] - Error in save. Missing IN or OUT parameter at index:: 115
2012 Sep 25 12:25:56:748 GMT -5 BPELOCAL-M1-CS-1 Error [WriteBehindThread:CacheStoreWrapper(com.tibco.be.oracle.BECoherenceOracleStore)] - java.sql.SQLException: Missing IN or OUT parameter at index:: 115
2012 Sep 25 12:25:56:749 GMT -5 BPELOCAL-M1-CS-1 Error [WriteBehindThread:CacheStoreWrapper(com.tibco.be.oracle.BECoherenceOracleStore)] -     at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)


Cause:
======
Oracle field names  are case sensitive and should be unique. When an event property with the same name only differing in case was being saved, it throws the above exception.

Resolution:
=========
Setting unique properties for the event resolved the issue.