My Oracle Support Banner

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 MARCH 27, 2020

Applies to:

Oracle Enterprise Service Bus - Version to
Information in this document applies to any platform.
***Checked for relevance on 05-Oct-2010***


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


at oracle.tip.esb.monitor.manager.database.DBActivityMessageStore.persistMessage( 
at oracle.tip.esb.monitor.manager.ActivityMessageReceiver.handleMessage( ... 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( ... 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.




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.