Y Drive not coming up

trying to reinstall 6.7.1 on a windows box, just to see if i can get by CSSDK work. But i am back to basic problem where Y drive doesn't get configured. this is happening because of event sub system, i did see this error in even error logs.

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)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:730)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

Can anyone let meknow the work around.

Thanks

Find more posts tagged with

Comments

nipper

When you reinstalled, did you point to the correct drivers ? They appear to be off.

What DB are you using ?

Bhargav Coca

I am using MSSQL.

Yes i am pointing to the right drivers.

Thanks

pdasarat

If you are using MySQL which is your jmsconfignew.xml pointing to MS SQL server. Post your jmsconfignew.xml

Pradeep

Bhargav Coca

[html]

driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://DLINT05:1433;databaseName=TSEVENTS_ver_6.7.1_TEST;selectMethod=cursor"
user="necweb"
password="gjag12mt"
maxActive="10"
maxIdle="5"
minIdleTime="1800"
evictionInterval="3600" />

[/html]

Here is the config file.its pointing to the right database.

Thanks

pdasarat

I'm sorry I misread MSSQL to MYSQL. Alright which version of MS SQL are you using?

Pradeep

cute_guy

trying to reinstall 6.7.1 on a windows box, just to see if i can get by CSSDK work. But i am back to basic problem where Y drive doesn't get configured. this is happening because of event sub system, i did see this error in even error logs.

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)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:730)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

Can anyone let meknow the work around.

Thanks

Do you have the driver jar files and the location of the jar files added to the PATH variable in your environment variable.

I think the TS is not able to find the MSSQl drivers and load them.

MAK

trying to reinstall 6.7.1 on a windows box, just to see if i can get by CSSDK work. But i am back to basic problem where Y drive doesn't get configured. this is happening because of event sub system, i did see this error in even error logs.

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)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:730)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:518)
at org.exolab.jms.persistence.DBCPConnectionManager.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.getConnection(Unknown Source)
at org.exolab.jms.persistence.RDBMSAdapter.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.createRdbmsAdapter(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.(Unknown Source)
at org.exolab.jms.persistence.DatabaseService.instance(Unknown Source)
at org.exolab.jms.server.JmsServer.registerServices(Unknown Source)
at org.exolab.jms.server.JmsServer.init(Unknown Source)
at org.exolab.jms.server.JmsServer.main(Unknown Source)

Can anyone let meknow the work around.

Thanks

Hi,
Eventsubsystem is unable to get the class file.
Put the jar file in the eventsubsystem/lib directory and restart.

Migrateduser

The error you are getting is because in windows one needs to additionally add the registry entry for the driver jar files. See the following KB article.
https://support.interwoven.com/kb/kb_show_article2.asp?ArticleID=54178

Also just to test every thing is fine. You can use the following DatabaseConfiguration tag to use the flatfile DB. (Just the test, NEVER for production). See jmsconfignew.xml.example

JdbmDatabaseConfiguration name="openjms.db"

Bhargav Coca

Thank You all, event subsystem is up and running, the only service which is not running is TeamSite. and i am getting this error from logs

iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting
iwtock: restarting iwserver
iwtock: could not start iwserver - exiting

Thanks

nipper

Which log is that from ?

Did you try a complete restart after you fixed the event subsystem ?

Any other logs with more info ? Like maybe the iwserver log ?

Bhargav Coca

The one which i posted was from iwserver logs. this is from iwtrace.

[Mon Aug 06 09:23:20 2007] Error...TStorageHandle: unexpected EOF
[Mon Aug 06 09:24:27 2007] infinite wait completed
[Mon Aug 06 09:24:27 2007] [Mon Aug 06 09:24:27 2007] TEnvironment::Flush flushed 0, unlinked 0
[Mon Aug 06 09:24:27 2007] TEnvironment::Flush flushed 0, unlinked 0
[Mon Aug 06 09:24:27 2007] TEnvironment::Freeze freeze until Tue Aug 05 09:24:27 2008
TEnvironment::Flush flushed 0, unlinked 0
[Mon Aug 06 09:24:27 2007] TEnvironment::Freeze freeze until Tue Aug 05 09:24:27 2008
[Mon Aug 06 09:24:27 2007] TEnvironment::Freeze freeze until Tue Aug 05 09:24:27 2008
[Mon Aug 06 09:24:27 2007] TeamSite Server Stopped.[Mon Aug 06 09:24:35 2007] Stopped Hopi manager
[Mon Aug 06 09:24:35 2007] Stopped License Monitor
[Mon Aug 06 09:24:35 2007] Completed operations statistics dump:
Store:

OpName count avgDuration minDuration maxDuration
CVOL_ROOT_svc 1 0 0 0
ChangeUserAttributes 3 15666 15000 16000
ChangeUsersInGroup 2 8000 0 16000
CreateGroup 1 11547000 11547000 11547000
CreateUser 1 15000 15000 15000
DiscardQuery 235 268 0 16000
FaultInEntity 8 7875 0 31000
FindArchiveByID 238 134 0 16000
FlushOutEntityProperties 772 5172 0 125000
GetAdministrableBranchesOfUserFromArchive 230 347 0 32000
GetAllOperationCategories 6 0 0 0
GetAllOperations 1 0 0 0
GetAllPermEntriesOfUser 3 5333 0 16000
GetAllRoles 10 0 0 0
GetDelegableRolesOfRole 2 0 0 0
GetGlobalRolesFromArchive 738 146 0 16000
GetGroupAttributes 7 0 0 0
GetOperationCategoryInfo 66 0 0 0
GetOperationInfo 1253 1728 0 16000
GetOperationsOfRole 157 203 0 16000
GetQueryStatus 7918 388 0 1672000
GetRoleAttributes 1664 28 0 16000
GetUserAttributes 149 100 0 15000
GroupInfoQuery 1424 15668 0 5609000
IterateArchive 42 1857 0 16000
ParseVersionPath 6369 27 0 16000
QueryGroups 10 3100 0 16000
QueryGroupsInGroup 8 0 0 0
QueryGroupsOfPrincipal 694 2518 0 203000
QueryUsers 31 1000 0 16000
QueryUsersInGroup 185 8918 0 109000
ResetEntityDatabase 5 0 0 0
UserInfoQuery 472 519741 0 6000000

Store: default

OpName count avgDuration minDuration maxDuration
BackgroundJobsThawAll 22484 0 0 0
BatchJobs 22484 0 0 0
CFILE_ACCESS_svc 18356471 17 0 6000000
CFILE_CREATE_svc 41 7658 0 63000
CFILE_GETATTR_svc 27790549 17 0 141000
CFILE_GETPAGE_svc 4277176 324 0 453000
CFILE_GETSECURITY_svc 419 0 0 0
CFILE_LOOKUP_svc 193179362 28 0 63000
CFILE_MKDIR_svc 4 0 0 0
CFILE_PUTPAGE_svc 962 662 0 31000
CFILE_READDIR_svc 2270053 110 0 312000
CFILE_REMOVE_svc 1 32000 32000 32000
CFILE_SETATTR_svc 3281448 16 0 156000
CFILE_SETSECURITY_svc 123 373 0 16000
CreateBranch 1 78000 78000 78000
CreateFSE 9 17555 0 47000
CreateTag 1 15000 15000 15000
CreateWorkarea 1 0 0 0
FSEsInDirQuery 242 1157 0 125000
FindAreaByID 336 47 0 16000
FindBranchByID 338 233 0 16000
FindEditionByID 1917 219 0 63000
FindEditionByName 2 0 0 0
FindFSEByID 1049 223 0 16000
FindFSEByName 3 0 0 0
FindStagingAreaByID 16 2937 0 47000
FindTagByID 1 0 0 0
FindWorkareaByID 2530 228 0 109000
FreezeArchive 1 515000 515000 515000
GetArchiveStatus 1 0 0 0
GetBranchPermissionInfo 3 5333 0 16000
GetDelegableRoles 3 0 0 0
GetExtAttr 16 0 0 0
GetOpenApiFSEInfo 791 1226 0 16000
GetQueryData 242 1028 0 16000
GetRoles 1303 48 0 16000
GetStoreAttributes 1286 24 0 16000
IterateBranch 146 1609 0 94000
IterateWorkarea 18 1777 0 16000
LookupEA 32 0 0 0
LookupObjids 5545 169 0 110000
LookupVpathFSEInfo 739 549 0 78000
QueryFSEsInDir_initiate 242 12239 0 141000
ReadFile 688 521 0 78000
SetBranchPermEntry 1 0 0 0
SetExtAttr 19 842 0 16000
SetFSEAttributes 4 0 0 0
TBranchGetFullPath 59 0 0 0
TFSEnvironmentConstructor 1 2399000 2399000 2399000
ThawArchive 5 0 0 0
TruncateFile 1 16000 16000 16000
WriteFile 19 0 0 0
trp__IsPermitted 3365 117 0 16000
trp__IsPermittedDelegateCheck 1 0 0 0

Store: iwadmin

OpName count avgDuration minDuration maxDuration
BackgroundJobsThawAll 22484 0 0 16000
BatchJobs 22484 0 0 0
FreezeArchive 1 31000 31000 31000
GetArchiveStatus 1 0 0 0
GetRoles 8 2000 0 16000
GetStoreAttributes 991 2472 0 16000
GetStorePermissionInfo 1 0 0 0
IterateBranch 7 0 0 0
LookupObjids 10 0 0 0
TFSEnvironmentConstructor 1 10363000 10363000 10363000
ThawArchive 5 3200 0 16000
trp__IsPermitted 8 3875 0 16000

Store: workflow

OpName count avgDuration minDuration maxDuration
ConstructArchive 1 7469000 7469000 7469000
CreateWorkFlow 1 78000 78000 78000
FreezeArchive 1 531000 531000 531000
GetFileTasksAndWorkFlows 5 25000 0 125000
QueryWorkFlows 1 266000 266000 266000
ThawArchive 5 0 0 0

[Mon Aug 06 09:24:36 2007] Watch Event Thread stopping
[Mon Aug 06 09:24:36 2007] Shut down store 0x65 at "E:\iw-store\iwadmin" (next id = 0x400).
[Mon Aug 06 09:24:36 2007] Shut down store 0x64 at "E:\iw-store\default" (next id = 0x1265e).
[Mon Aug 06 09:24:36 2007] Shut down store 0x1 at "E:\iw-store\workflow" (next id = 0xcb01).

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

TeamSite I18N initialization successful!

Thanks

nipper

Did you do anything to the backingstore ? Copy ? Move ?

It *appears* the backingstore is not happy.

Is this a new store ?

Bhargav Coca

Yes i did mess with iwstore. Well while uninstalling TeamSite. I totally deleted iwstore and let the installation recrete iwstore from scratch.

Thank You

nipper

Then try to delete everything again and restart. It should rebuild it without any trouble

I am not certain if iwstoreadm can run without TS running, but you can also try to use that to deactivate the store.

Andy

Migrateduser

Then try to delete everything again and restart. It should rebuild it without any trouble

I am not certain if iwstoreadm can run without TS running, but you can also try to use that to deactivate the store.

Andy

Good suggestion. Take the backup for teh current store content and delete everything, this will be recreated.

iwstoreadm will help you mount/unmount the stores once the TS server is up sucessfully.

Bhargav Coca

I tried everything

C:\Documents and Settings\Administrator>iwstoreadm -a E:/iw-store
ERROR:5000013: Unable to establish connection with server

I opened a case with support. They are looking inot it.

Thank You