EventSubsystem 6.7.1 - MSSQL

Okay - not sure what's changed but I'm having some issues with the EventSubsystem after we upgraded to TS 6.7.1 from TS 6.5.

TS 6.7.1
Windows 2003 Enterprise Server

I did a fresh install of the OS, TeamSite 6.7.1 did the following for a manual setup of the EventSubsystem

1) copied the msbase.jar, msutil.jar and mssqlserver.jar files into C:\iw-home\eventsusbsystem\lib (all taken from SP3 of the JDBC MS drivers)

2) Edited the eventsubsystem.properties file so that it looks like as follows:
----------------------------
# (e.g. jdbc_classpath=D:\\jdbc_vendor\\jdbc_vendor.jar)
jdbc_classpath=C:\\iw-home\\eventsubsystem\\lib\\mssqlserver.jar
-----------------------------

3) Modifed my jmsconfignew.xml file (under the DatabaseConfiguration and RdbmsDatabaseConfiguration sectoin) to read as follows:
---------------------

driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://cms-server:1433;databasename=TSEVTSUB;SelectMethod=Cursor;user=sa;password=cantsay"
databasename="TSEVTSUB"
user="sa"
password="cantsay"
maxActive="10"
maxIdle="5"
minIdleTime="1800"
evictionInterval="3600" />

----------------

After that, I start the eventSubsystem service and it works like a charm on our previous environment (TS 6.5 SP2 on Windows 2K). But with the new version of TS and the new OS - I get the following error (in the eventsuberr.log file)

--------------------------------
OpenJMS 0.7.6.1
The OpenJMS Group. (C) 1999-2004. All rights reserved.
http://openjms.sourceforge.net
org.exolab.jms.server.ServerException: org.exolab.jms.persistence.PersistenceException: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver', cause:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
----------------------------------

I tinkered with the jdbc_classpath, copied the files back in and I keep on getting the same error. My eyes are a little buggy looking at it and I'm sure it's something simple but I've been looking at it for too long Ithink.

Can someone throw a fresh set of eyes on this?

Thanks in advance,
/FF

Find more posts tagged with

Comments

RajatChopra

Try these:
A)
Edit the registry key to include the path of the JDBC driver file: \\HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\iweventsubd\Parameters\JVM Option Number 0

Delete the events.lock file if it is located under the iw-home\eventsubsystem directory

-R

Migrateduser

This is surely the problem with the classpath.
Here is the sample entry for the 6.7.1 MSSQL server relevant regitry key (\\HKEY_LOCAL_MACHINE\SYSTEM\Current ControlSet\Services\iweventsubd\Parameters\JVM Option Number 0).

-Djava.class.path=C:\Interwoven\TeamSite\eventsubsystem\lib\ant-1.5.3-1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\ant-optional-1.5.3-1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\antlr-2.7.2.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\castor-0.9.5.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\classes12.zip;C:\Interwoven\TeamSite\eventsubsystem\lib\commons-collections-2.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\commons-dbcp-1.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\commons-logging-1.0.3.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\commons-pool-1.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\concurrent-1.3.2.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\exolabcore-0.3.7.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\hsqldb-1.6.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\jdbc-2.0.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\jdbm.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\jms-1.0.2a.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\jndi-1.2.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\jta-1.0.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\junit-3.7.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\log4j-1.2.7.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\openjms-0.7.6.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\openjms-client-0.7.6.1.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\openjms.war;C:\Interwoven\TeamSite\eventsubsystem\lib\oro-2.0.7.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\servletapi-2.3.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\xerces-2.3.0.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\xml-apis-1.0.b2.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\mssqlserver.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\msutil.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\msbase.jar;

Please see configuring a database for the EventSubsystem after the install is done for the teamsite eventsubsystem.

Migrateduser

Here's the support article for this
Configuring MSSQL Server as the Database for Event Subsystem
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=54178

FurnaceFace

Hi HermantGaur and RajatChopra,

Sorry for my late reply, I was away for a week and a bit and just got back. That said, you both hit the nail on the head and thank you for the information - I added the following to the path and things worked like clockwork after that.

------------------
C:\Interwoven\TeamSite\eventsubsystem\lib\mssqlserver.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\msutil.jar;C:\Interwoven\TeamSite\eventsubsystem\lib\msbase.jar;
------------------

Thanks again!
/FF