Resolution:
Exception reported in BusinessEvents Cache Loader/Cache Server process.

ERROR IN SAVE.. Fail to convert to internal representation: oracle.sql.STRUCT@98062f
java.sql.SQLException: Fail to convert to internal representation: oracle.sql.STRUCT@98062f
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.oracore.OracleTypeNUMBER.toNUMBER(OracleTypeNUMBER.java:540)
    at oracle.jdbc.oracore.OracleTypeNUMBER.toDatum(OracleTypeNUMBER.java:54)
    at oracle.sql.StructDescriptor.toOracleArray(StructDescriptor.java:717)
    at oracle.sql.StructDescriptor.toArray(StructDescriptor.java:1375)
    at oracle.sql.STRUCT.<init>(STRUCT.java:159)
    at com.tibco.be.oracle.serializers.OracleEventSerializer.getOracleAttributes(OracleEventSerializer.java:47)
    at com.tibco.be.oracle.impl.OracleAdapter.insertEvent(OracleAdapter.java:1445)
    at com.tibco.be.oracle.BECoherenceOracleStore.save(BECoherenceOracleStore.java:403)
    at com.tibco.be.oracle.BECoherenceOracleStore.store(BECoherenceOracleStore.java:335)
    at com.tangosol.net.cache.ReadWriteBackingMap$CacheStoreWrapper.store(ReadWriteBackingMap.java:3936)
    at com.tangosol.net.cache.ReadWriteBackingMap$CacheStoreWrapper.storeInternal(ReadWriteBackingMap.java:3701)
    at com.tangosol.net.cache.ReadWriteBackingMap$WriteThread.run(ReadWriteBackingMap.java:3394)
    at com.tangosol.util.Daemon$DaemonWorker.run(Daemon.java:519)
    at java.lang.Thread.run(Thread.java:595)

Resolution

====== 

You may see this error if you are using the backend datastore functionality in Business Events 2.2 + Hottfix1. This is due to a wrong basetypes.sql that was shipped with BusinessEvents 2.2 - HotFix1. Get the correct basetypes.sql from TIBCO Customer Support and apply it in your database.

java.sql.SQLException: Fail to convert to internal representation: oracle.sql.STRUCT@98062f exception in my TIBCO BusinessEvents Cache Loader/Cache Server process.