Have I found a bug in the eventsubsystem for 7.1?

My biggest hope for 7.1 was that I would never, ever have another event subsystem issue. Unfortunately, it looks like my nemesis is back to fight another battle.

With 7.1 installed on 32bit W2k3 using MSSQL 2008 as the DB, I noticed shortly after installation that my event subsystem was not running. Thinking it might be an install problem, I looked through the installer log and didn't find anything.

After a lot of grepping, I found the log for it (conveniently located in \ApplicationContainer\server\default\deploy\activemq-ear-5.3.0.ear\activemq-ra.rar [where else would you think it might be?]), and found messages similar to this inside it:

[INDENT] ERROR BrokerService - Failed to start ActiveMQ JMS Message Broker. Reason: java.io.IOException: Failed to get last broker message id: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ACTIVEMQ_MSGS'.[/INDENT]

I checked the database, and found that I only had two tables, ACTIVEMQ_LOCKS and ACTIVEMQ_ACKS. Further exploration of the log revealed a failure to create the tables. After some research, I discovered that ActiveMQ will initialize the database on startup if it doesn't find the tables it is looking for, but I could not find a clear reason for it to fail to do so (especially since it was creating two of the tables).

Digging in the issue log for ActiveMQ, I found this:
https://issues.apache.org/activemq/browse/AMQ-2496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=55586#action_55586

Apparently this issue (or at least one very similar to it) can be caused by an incorrect dataSource attribute on the persistence layer. I am currently waiting to hear back from support about their recommendation for fixing the problem.

Has anyone else run into an issue using MSSQL2008 for the iwevent database, and if so, what did you do to fix it?

I'm currently

Find more posts tagged with

Comments

Rob76

I have seen something similar on Windows 2003.

Check the install log... C:\Interwoven\TeamSite\install\install_webapps_eventsubsystem.log

You should see something like
Running command "C:\Interwoven\TeamSite/tools/java/bin/java -classpath blah blah blah

I tired running that command as defined in the log file then got the error
The input line is too long.

B/c I used the default "Interwoven" folder vs. "iw-home" that command length is 2,542 characters

I tried copying those jar files to another directory "C:\a" but I got the same error.

Then I removed the quotes at the begining and end of the command.

After removing the quotes in that command and providing the full path to eventsubsystem.war (C:\Interwoven\TeamSite\httpd\webapps\eventsubsystem.war) I was able to run that command from the cmd prompt. It completed with no errors.

However, I still don't see the eventsubsystem installed.

How can I manually install the event subsystem after fixing the issue with the command above?

Migrateduser

Oops. I thought I had replied to my own thread with this earlier, but it looks like I left it out. What I was experiencing is in fact a known issue, and there is DDL included with the installer that you can use to manually create the tables.

Here's what I got from support, which worked
**********
Please do following:

1. Pl check ddl script which will be under /eventsubsystem/conf dir for sql server which has sql script for creating ACTIVEMQ_MSGS table manually.

2. After manually create that table using the script in conf/ddl dir
restart services, run iwreset -a.
************

thatfish

I believe this is mentioned as a step in the install PDF.

On the same environment I had some issues with the administration console. So, purely out of interest does you administration console behave correctly ?