Report Center is not running

Our TS 6.5.0 Report Center running on Unix hasn't been running for over a month. The log returns something like the following:

01 Aug 2007 14:29:27,113 ERROR - Error processing message
java.sql.SQLException: Io exception: Broken pipe
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.WorkflowEventsTable.insert(WorkflowEventsTable.java:146)
at com.interwoven.tsreport.server.TWorkflowMessage.handleMessage(TWorkflowMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:118)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)
01 Aug 2007 14:29:27,113 ERROR - Error processing message
java.sql.SQLException: Io exception: Broken pipe
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.WorkflowEventsTable.insert(WorkflowEventsTable.java:146)
at com.interwoven.tsreport.server.TWorkflowMessage.handleMessage(TWorkflowMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:118)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)
01 Aug 2007 14:29:27,212 ERROR - Error processing message
java.sql.SQLException: Io exception: Broken pipe
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.WorkflowEventsTable.insert(WorkflowEventsTable.java:146)
at com.interwoven.tsreport.server.TWorkflowMessage.handleMessage(TWorkflowMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:118)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)
01 Aug 2007 14:29:27,212 ERROR - Error processing message
java.sql.SQLException: Io exception: Broken pipe
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.WorkflowEventsTable.insert(WorkflowEventsTable.java:146)
at com.interwoven.tsreport.server.TWorkflowMessage.handleMessage(TWorkflowMessage.java:29)
at com.interwoven.tsreport.server.TeamsiteListener.onMessage(TeamsiteListener.java:118)
at com.interwoven.tsreport.server.JmsListener.run(JmsListener.java:153)
at java.lang.Thread.run(Thread.java:534)

Any ideas ?

Find more posts tagged with

Comments

nipper

check the event subsystem is that running ? What DB do you use ?

John742

appears your connection to your oracle DB schema supporting reporting was dropped. Restarting the reporting process will reconnect. Have you tried that? RC in 6.5 has this as a known issue. 6.7.1 reporting will reestablish the connection if it is lost

rob_liem

I restarted RC by doing a "iw.tsreport stop" and "iw.tsreport start", and RC seems to be running now.

Prior to that I verified that the event subsystem is up by doing a "ps -ef | grep eventsubsytem", but how do I restart it ? Do I need to run "iweventsubd" followed by "iwreset -ui command.e" ?

BTW, any idea why I'm now getting a new error of "Caught CSException in getEvents: com.interwoven.cssdk.common.CSObjectNotFoundException: (Object being looked up was not found)" ? My iw.cfg file already has this line of [workflow] delete_jobs_on_completion=false in it which was a recommendation by Tech Support.

Again, thx for all your help.

John742

So the error you are seeing is not because the Workflow has been deleted, but because the EA's of the file it is trying to lookup is gone. most likely the file , directory, or WA was removed in between the event being persisted and reposting trying to consume. Sounds like all is working ok. I would go into the tseventsubsys table and check message handle count for the reporting consumer to confirm all is working well(confirm handles are being consumed). Let me know if you need help with that.

rob_liem

Thx John.

BTW, is my procedure correct for restarting the event subsystem ? And any idea on the error that I posted ?

And yes, will need your help. How do I check the message handle count for the reporting consumer ? Is it just matter of a SQL query to check if the count was revised ?

John742

you can use the iweventsubd script to restart eventsubsystem. doing a iwreset -ui is always safe, since serveltd brokers requests for eventsubsystem. But it sounds like from your error message that it is consuming. The explanation provided above is in regard to the error you are receiving. check jmsconfignew.xml for connection string information to use for the following SQL query, if you do not already know it. As far as the checking of messages handles you will need to obtain the consumerid for reporting. Check the consumers table. You should find tsreport registered. Use the consumerid to plug into the following sql query instead of "reporting id"

select count (*) FROM MESSAGE_HANDLES where consumerid = "reporting id"

Hope this helps.