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 10.1.3.1 to 10.1.3.4.0Information 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 ]]>
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |