Event Subsystem Issue

Hi,

Teasmite 6.5 , windows

Event Subsystem is configured for the new database oracle. And it was working fine before.
today i find that event services are working but the events are not getting stored in to the database. The last entry in the database is for older date.
But i think database should be updated daily basis.
I have checked the event subsystem service and it is working.

Because of Events system my search is also not working.
Please suggest me.

Thanks
Nidhi...

Find more posts tagged with

Comments

Valentine

Usually if the events are being consumed, the tables will be empty.
Do you see any errors in the eventd log file on the TS? What do you see in the TS Index/Search logs?

cute_guy

Hi,

Teasmite 6.5 , windows

Event Subsystem is configured for the new database oracle. And it was working fine before.
today i find that event services are working but the events are not getting stored in to the database. The last entry in the database is for older date.
But i think database should be updated daily basis.
I have checked the event subsystem service and it is working.

Because of Events system my search is also not working.
Please suggest me.

Thanks
Nidhi...

May your eventsubsystem and search was not restarted in proper order at the same time, so they might be out of sync.

Logs should be indicating something ....

Migrateduser

Search (indexer), if it has the events based updates enables will not start in the first place failing to connect to eventsubsystem after the configurablenumbers of retries. Look for the "event received" text in the indexer logs in the debug mode.

The events are cleared from the DB after they are consumed. Try stopping the search and then publishing something to see them being piled up in DB. Once the search comes back these events are delivered and come back.

There is some time lag in the update event and its reflection in the search indexes (for the processing), so looking for the updated info instantaneously can be misleading.

madhug

Hi Nidhi,

Check the search log , indexer log.

Even we were facing the same problem. Try this it may help you.

1.Stop the Index and Search Managers.
2.Check the Oracle User name and password , wether they are expaired or not and try connection once.
2. Restart the eventsybsytem
3.Start the Inedx and search process.

Nidhi_Agrawal

Hi,

This i have found from the tsreport.log

04 Sep 2007 22:14:18,120 ERROR - Error processing message
java.sql.SQLException: Io exception: Software caused connection abort: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:503)
at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:683)
at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:560)
at com.interwoven.tsreport.server.EventsSummaryTable.insert(EventsSummaryTable.java:66)
at com.interwoven.tsreport.server.TCoreMessage.handleMessage(TCoreMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:113)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)

I have created one workarea and this event is not stored into the database and i found above comment from the log file.

Nidhi...

Migrateduser

Can you check if the oracle database and the Listeners are up and running and are you able to connect to the Oracle Database from the Teasite box

Migrateduser

Hi,

This i have found from the tsreport.log

04 Sep 2007 22:14:18,120 ERROR - Error processing message
java.sql.SQLException: Io exception: Software caused connection abort: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:335)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:503)
at oracle.jdbc.driver.OracleConnection.privateCreateStatement(OracleConnection.java:683)
at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:560)
at com.interwoven.tsreport.server.EventsSummaryTable.insert(EventsSummaryTable.java:66)
at com.interwoven.tsreport.server.TCoreMessage.handleMessage(TCoreMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:113)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)

I have created one workarea and this event is not stored into the database and i found above comment from the log file.

Nidhi...

This has noithing to do with the event subsystem. The reports is not able to proces the message already delivered by the ES. ES db do NOT store the delivered events. Have you tried lookinf for the event received messages in the indexer debug logs ?