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. |
4 answers
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. |
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. |
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.
|
Please disregard this topic, I have reposted it in RTC forum. Thank you
|
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.