Not Able to See Any ESB Instances in ESB Control Due to [POL-5205] or ORA-00904 Column SEQ Not Found Error

(Doc ID 567167.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle ESB - Version: 10.1.3.1 to 10.1.3.4.0 - Release: AS10gR3 to
Information in this document applies to any platform.
***Checked for relevance on 05-Oct-2010***

Symptoms

On Basic installation, when attempting to deploy and run an ESB instance, it is not visible in ESB console and the following error occurs:

ERROR STACK

at oracle.tip.esb.monitor.manager.database.DBActivityMessageStore.persistMessage(DBActivityMessageStore.java:340) 
at oracle.tip.esb.monitor.manager.database.DBActivityMessageStore.store(DBActivityMessageStore.java:128) 
at oracle.tip.esb.monitor.manager.ActivityMessageReceiver.handleMessage(ActivityMessageReceiver.java:83) ... 7 more 
Caused by: java.sql.SQLException: [POL-5205] column SEQ not found 
at oracle.lite.poljdbc.LiteThinJDBCConnection.thinSQLError(Unknown Source) 
at oracle.lite.poljdbc.LiteThinJDBCStatement.thinSqlPrepare(Unknown Source) 
at oracle.lite.poljdbc.LiteThinJDBCPreparedStatement.prepare(Unknown Source) 
at oracle.lite.poljdbc.POLJDBCPreparedStatement.(Unknown Source) 
at oracle.lite.poljdbc.POLJDBCPreparedStatement.(Unknown Source) 
at oracle.lite.poljdbc.OraclePreparedStatement.(Unknown Source) 
at oracle.lite.poljdbc.POLJDBCConnection.prepareStatement(Unknown Source) 
at oracle_lite_poljdbc_OracleConnection_Proxy.prepareStatement() 
at oracle.tip.esb.monitor.manager.database.DBActivityMessageStore.persistMessage(DBActivityMessageStore.java:185) ... 9 more ]]> 


Activity monitor manager received an unexpected exception while processing the activity messages.
Due to the error "[POL-5205] column SEQ not found", the activity message could not be stored.

This error is relevant for OLITE databases; for "regular" database the error would be ORA-00904.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms