Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

repoTools -createTables fails with odd error in RTC 2.0 beta

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.

0 votes



4 answers

Permanent link
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.

0 votes


Permanent link
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.

0 votes


Permanent link
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.

0 votes


Permanent link
Please disregard this topic, I have reposted it in RTC forum. Thank you

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 17 '09, 8:16 p.m.

Question was seen: 8,056 times

Last updated: Apr 17 '09, 8:16 p.m.

Confirmation Cancel Confirm