It's all about the answers!

Ask a question

repoTools -createTables fails with odd error in RTC 2.0 beta


Rajasimhan Mandayam (3811144) | asked Apr 17 '09, 8:16 p.m.
JAZZ DEVELOPER
Here is the problem.

Steps
1. I create a db2 database 'JAZZ0406'
2. I modify the teamserver.properties to point to the location.
3. I run repoTools.bat -createTables
4. It runs successfully,
5. I create a datasource on WebSphere to this database..
6. I run jazz/setup use the data source and I deploy RTC on WebSphere and I have a successfull configuration.
5. Few days later I stopped the WebSphere server.
6. I dropped the db2 database 'JAZZ0406'
7. I try to run repoTools.bat -createTables again.
8. It gives a strange error

Error
--------

D:\ram\rtcSS2beta1Express\jazz\server>repotools.bat -createTables
Repo Tools, Version 2.0 M2 - I20090316-0438
Provisioning using "D:\ram\rtcSS2beta1Express\jazz\server\\provision_profiles".
Rational Jazz Team Server - Express
Loading configuration from "file:teamserver.properties".
CRJAZ1093I Service failed to activate.
CRJAZ1238I Jazz has detected another server process is connected to the reposito
ry database location "db2:/localhost:50000/JAZZ0406". The server must not be ru
nning when running repotools data commands. Check that only one process is conn
ecting to the database.
The database tables were not created.

Contents of teamserver.properties
-----------------------------------
#Fri Apr 17 17:38:46 EDT 2009
com.ibm.team.repository.server.repourl.port.http=9085
com.ibm.team.repository.db.jdbc.location=//localhost\:50000/JAZZ0406\:user\=db2admin;password\={password};
com.ibm.team.repository.db.jdbc.password=
com.ibm.team.repository.db.type=J2EE
com.ibm.team.repository.db.db2.content.tablespace.numpages=250000
com.ibm.team.repository.db.vendor=DB2
com.ibm.team.repository.db.j2ee.dataSource=jdbc/JAZZ_Con
com.ibm.team.repository.user.registry.type=UNSUPPORTED
com.ibm.team.repository.ws.allow.admin.access=true
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace
com.ibm.team.repository.server.repourl.port.https=9448



Contents of repoTools_createTables.log
----------------------------------------
2009-04-17 20:06:29,875 repotools -createTables
2009-04-17 20:06:33,703 Repo Tools, Version 2.0 M2 - I20090316-0438
2009-04-17 20:06:33,703 Provisioning using "D:\ram\rtcSS2beta1Express\jazz\server\\provision_profiles".
2009-04-17 20:06:45,000 Rational Jazz Team Server - Express
2009-04-17 20:06:45,015 Loading configuration from "file:teamserver.properties".
2009-04-17 20:06:47,171 CRJAZ1093I Service failed to activate.
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.rdb.ConnectionPoolService" failed during activation.
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:208)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:494)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:134)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.activate(BundleActivationManager.java:290)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.performActivation(BundleActivationManager.java:1584)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.access$2(BundleActivationManager.java:1569)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager$3.acquired(BundleActivationManager.java:573)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.serviceAcquired(ImportServiceRecordContainer.java:587)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.access$1(ImportServiceRecordContainer.java:571)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer$5.serviceAcquired(ImportServiceRecordContainer.java:352)
at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.acquire(ImportServiceRecord.java:114)
at org.eclipse.soda.sat.core.internal.record.ImportServiceRecord.handleRegisteredService(ImportServiceRecord.java:317)
at org.eclipse.soda.sat.core.internal.record.ServiceRecord.serviceChanged(ServiceRecord.java:443)
at org.eclipse.soda.sat.core.internal.record.ServiceRecord.access$0(ServiceRecord.java:425)
at org.eclipse.soda.sat.core.internal.record.ServiceRecord$1.serviceChanged(ServiceRecord.java:130)
at org.eclipse.osgi.framework.internal.core.FilteredServiceListener.serviceChanged(FilteredServiceListener.java:94)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:1224)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:195)
at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:141)
at org.eclipse.osgi.framework.internal.core.Framework.publishServiceEventPrivileged(Framework.java:1603)
at org.eclipse.osgi.framework.internal.core.Framework.publishServiceEvent(Framework.java:1578)
at org.eclipse.osgi.framework.internal.core.ServiceRegistrationImpl.<init>(ServiceRegistrationImpl.java:103)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.createServiceRegistration(BundleContextImpl.java:657)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:609)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.registerService(BundleContextImpl.java:675)
at com.ibm.team.repository.jndi.internal.Activator.start(Activator.java:93)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$2.run(BundleContextImpl.java:999)
at java.security.AccessController.doPrivileged(AccessController.java:246)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:993)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:974)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:346)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:260)
at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:400)
at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:111)
at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:417)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:189)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findLocalClass(BundleLoader.java:340)
at org.eclipse.osgi.framework.internal.core.SingleSourcePackage.loadClass(SingleSourcePackage.java:37)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClassInternal(BundleLoader.java:405)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:369)
at org.eclipse.osgi.framework.internal.core.BundleLoader.findClass(BundleLoader.java:357)
at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:83)
at java.lang.ClassLoader.loadClass(ClassLoader.java:597)
at org.eclipse.osgi.framework.internal.core.BundleLoader.loadClass(BundleLoader.java:289)
at org.eclipse.osgi.framework.internal.core.BundleHost.loadClass(BundleHost.java:227)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.loadClass(AbstractBundle.java:1269)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.ensureClassIsLoaded(AbstractActivationManagerOwner.java:527)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:267)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:480)
at com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
at com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:253)
at com.ibm.team.repotools.rcp.AbstractCommand.isServerRunning(AbstractCommand.java:303)
at com.ibm.team.repotools.rcp.internal.command.CreateTablesCommand.execute(CreateTablesCommand.java:82)
at com.ibm.team.repotools.rcp.AbstractCommand.execute(AbstractCommand.java:158)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:611)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:668)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:169)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:106)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:76)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:363)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:176)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:508)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:447)
at org.eclipse.equinox.launcher.Main.run(Main.java:1173)
at org.eclipse.equinox.launcher.Main.main(Main.java:1148)
Caused by:
java.lang.RuntimeException: CRJAZ0520I Failed to create the connection pool.
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.activate(ConnectionPoolService.java:101)
at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:180)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:202)
... 68 more
Caused by:
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0527I Failed to lookup datasource.
at com.ibm.team.repository.service.internal.rdb.DataSourceConnectionPool.<init>(DataSourceConnectionPool.java:47)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.getJ2EEConnectionPool(ConnectionPoolService.java:372)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.connectToProvider(ConnectionPoolService.java:249)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.activate(ConnectionPoolService.java:98)
... 70 more
Caused by:
javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
at org.apache.naming.NamingContext.lookup(NamingContext.java:769)
at org.apache.naming.NamingContext.lookup(NamingContext.java:152)
at org.apache.naming.SelectorContext.lookup(SelectorContext.java:136)
at javax.naming.InitialContext.lookup(InitialContext.java:363)
at com.ibm.team.repository.jndi.internal.ContextImpl.lookup(ContextImpl.java:261)
at com.ibm.team.repository.service.internal.rdb.DataSourceConnectionPool.<init>(DataSourceConnectionPool.java:42)
... 73 more
2009-04-17 20:06:47,406 CRJAZ1238I Jazz has detected another server process is connected to the repository database location "db2:/localhost:50000/JAZZ0406". The server must not be running when running repotools data commands. Check that only one process is connecting to the database.
2009-04-17 20:06:47,406 The database tables were not created.

4 answers



permanent link
Tan Nguyen (761) | answered Apr 17 '09, 10:01 p.m.
It looks like the DB2 process is running and connecting to the database.
You may have to kill the process before running the repotools. One way to find the process ID is to execute the netstat command from command prompt:
netstat -a -o -n
Find the PID that is using port 50000 then kill it using the following command:
taskkill /F /PID ###
where ### is the PID that you find in the previous step.

permanent link
Rajasimhan Mandayam (3811144) | answered Apr 19 '09, 6:03 p.m.
JAZZ DEVELOPER
I do not think any other process is connected to it, I had already stopped the server, I do not have any java processes running. I also ran the command netstat -a -o -n
The only thing with 50000 in the command output is the db2syscs.exe which is listening on 50000.

I think I know how this happened, when I configured RTC to point to my datasource on WebSphere it made changes to the teamserver.properties file. Not sure what changes but
ever since then I cannot use that property file to re-create the database.

Seems like the repoTools might be trying to use the datasource to create the database (from the error log) no idea why it would do that.

permanent link
Rajasimhan Mandayam (3811144) | answered Apr 20 '09, 11:30 a.m.
JAZZ DEVELOPER
I have mistakenly posted on the RQM forum. THis is a problem with RTC 2.0 beta1. How can I move this post there so that it gets more coverage.

permanent link
Rajasimhan Mandayam (3811144) | answered Apr 20 '09, 11:46 a.m.
JAZZ DEVELOPER
Please disregard this topic, I have reposted it in RTC forum. Thank you

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.