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

RQM2.0 configuration problems with WAS 6.1 FP23

Hi All,

I have configured RQM2.0 with WAS 6.1 FP23 by following the help documents from information center. After configuring I was trying to run setup wizard using the URL https://localhost:9445/jazz/setup, but I was getting some errors related to Data Base in the 4th step i.e. Setup User Registry. The error is

The database service is not available. Database status:<br>CRJAZ1061I The database is responding, but the Jazz repository schemas and tables cannot be found. Check that the database JDBC location is correct. If this is a new database, stop the server and use the "repotools" command to create the tables.

I have followed all the steps , still getting the above error.

Any help would be appriciated.
Regards,
Rajesh

0 votes



4 answers

Permanent link
Rajesh,

Are you using the default Derby database? If so, make sure that your teamserver.properties file points to the database using an absolute path. For example, in

C:\Program Files\IBM\RQM20\server\conf\jazz\teamserver.properties

The default path to the Derby database is:

com.ibm.team.repository.db.jdbc.location=C\:\\Program Files\\IBM\\RQM20\\server\\repositoryDB


Hope this helps,
Glenn

0 votes


Permanent link
Rajesh,

Are you using the default Derby database? If so, make sure that your teamserver.properties file points to the database using an absolute path. For example, in

C:\Program Files\IBM\RQM20\server\conf\jazz\teamserver.properties

The default path to the Derby database is:

com.ibm.team.repository.db.jdbc.location=C\:\\Program Files\\IBM\\RQM20\\server\\repositoryDB


Hope this helps,
Glenn



Hi Glenn,

Thanks for your reply. I'm using default Derby database only. This time I have given the absolute path for jdbc location eg: D\:\\IBM\\RQM20\\server\\repositoryDB
this time I'm getting diffrent errors setup user registry page and in step 2 i.e. Create an Administrator account. after I enter the values for fields USER ID, Password,Name and email, I have selected Rational QualityManager-QualityManager check box in the 4th step and pressed Next Button , now I'm getting the following errors in the browser
[color=red][/color]There was an error attempting to create the new user:Hide Details

CRJAZ1173I Service "com.ibm.team.repository.service.internal.IAdminRestService" is not available.
java.lang.Exception
com.ibm.team.repository.common.transport.ServerHttpUtil.serializeError(ServerHttpUtil.java:1057)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleException(AbstractTeamServerServlet.java:1143)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1603)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1471)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1143)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:591)
com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3453)
com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:267)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)
com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)[color=red][/color]


The Exception details from rqm.log are :
08 Aug 2009 14:37:35,349 [WebContainer : 2]  INFO .repository.service.internal.rdb.ConnectionFactory  - CRJAZ1365I Attempting Initial Database Connection Using

Db Name/Location: D:\IBM\RQM20\server\repositoryDB
08 Aug 2009 14:37:37,817 [WebContainer : 2] INFO .repository.service.internal.rdb.ConnectionFactory - CRJAZ1364I Initial database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.3.1 - (677131)
Db URL: jdbc:derby:D:\IBM\RQM20\server\repositoryDB
Jdbc Driver Name: Apache Derby Embedded JDBC Driver
Jdbc Driver Version: 10.3.3.1 - (677131)
08 Aug 2009 14:37:38,786 [WebContainer : 2] INFO m.team.fulltext.service.internal.index.IndexConfig - CRJAZ8192E: Fulltext Index Location: workitemindex\fulltext_index\
08 Aug 2009 14:37:46,239 [WebContainer : 2] WARN com.ibm.team.repository - CRJAZ0956I The server's license will expire on Oct 7, 2009 2:37 PM.
08 Aug 2009 14:37:51,349 [WebContainer : 2] WARN com.ibm.team.repository.servlet.TeamServerServlet - CRJAZ1181I Security notice during initialization: Allowing ADMIN user access. It is recommended that you disable the ADMIN user and create a real user with administrative rights.
08 Aug 2009 14:39:37,724 [WebContainer : 2] ERROR t.internal.registry.AbstractActivationManagerOwner - CRJAZ1093I Service failed to activate.
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.userregistry.ExternalUserRegistryService" failed during activation.
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:217)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:543)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:143)
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.container.ImportServiceRecordContainer$1.execute(ImportServiceRecordContainer.java:64)
at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForService(ServiceRecordContainer.java:352)
at org.eclipse.soda.sat.core.internal.record.container.ServiceRecordContainer.doForEach(ServiceRecordContainer.java:319)
at org.eclipse.soda.sat.core.internal.record.container.ImportServiceRecordContainer.acquire(ImportServiceRecordContainer.java:303)
at org.eclipse.soda.sat.core.internal.framework.bundle.BundleActivationManager.acquireImportedServices(BundleActivationManager.java:234)
at com.ibm.team.repository.common.transport.internal.registry.ServiceConfigurationUpdate.apply(ServiceConfigurationUpdate.java:158)
at com.ibm.team.repository.service.internal.ServerConfigurationRestService.postConfigurationUpdates(ServerConfigurationRestService.java:236)
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.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy33.postConfigurationUpdates(Unknown Source)
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 com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:555)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1655)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1471)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:75)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:121)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1143)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:591)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3453)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:267)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:267)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1037)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink.readyInboundPostHandshake(SSLConnectionLink.java:725)
at com.ibm.ws.ssl.channel.impl.SSLConnectionLink$MyHandshakeCompletedCallback.complete(SSLConnectionLink.java:412)
at com.ibm.ws.ssl.channel.impl.SSLUtils.handleHandshake(SSLUtils.java:841)
at com.ibm.ws.ssl.channel.impl.SSLHandshakeIOCallback.complete(SSLHandshakeIOCallback.java:70)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
Caused by:
java.lang.RuntimeException: CRJAZ0710I Failed to get the registry provider for user import. Check the server configuration and verify the property "user.registry.type".
at com.ibm.team.repository.service.internal.userregistry.ExternalUserRegistryService.activate(ExternalUserRegistryService.java:131)
at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:180)
at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:211)
... 65 more
Caused by:
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0797I Unable to lookup Tomcat user database.
at com.ibm.team.repository.service.internal.userregistry.TomcatUserRegistryProvider.initUserDb(TomcatUserRegistryProvider.java:61)
at com.ibm.team.repository.service.internal.userregistry.TomcatUserRegistryProvider.createRegistry(TomcatUserRegistryProvider.java:79)
at com.ibm.team.repository.service.userregistry.provider.AbstractUserRegistryProvider.getRegistry(AbstractUserRegistryProvider.java:29)
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.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:378)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:364)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy395.getRegistry(Unknown Source)
at com.ibm.team.repository.service.internal.userregistry.ExternalUserRegistryService.activate(ExternalUserRegistryService.java:127)
... 67 more
Caused by:
javax.naming.NameNotFoundException: Name "GlobalUserDatabase" not found in context "java:comp/env".
at com.ibm.ws.naming.ipbase.NameSpace.lookupInternal(NameSpace.java:1095)
at com.ibm.ws.naming.ipbase.NameSpace.lookup(NameSpace.java:991)
at com.ibm.ws.naming.urlbase.UrlContextImpl.lookup(UrlContextImpl.java:1263)
at com.ibm.ws.naming.java.javaURLContextImpl.lookup(javaURLContextImpl.java:384)
at com.ibm.ws.naming.urlbase.UrlContextImpl.lookup(UrlContextImpl.java:1307)
at com.ibm.ws.naming.java.javaURLContextImpl.lookup(javaURLContextImpl.java:353)
at com.ibm.team.repository.service.internal.userregistry.TomcatUserRegistryProvider.initUserDb(TomcatUserRegistryProvider.java:59)
... 78 more
08 Aug 2009 14:47:48,536 [AsynchronousTaskRunner-3] WARN com.ibm.team.workitem - CRRTC0240W: E-mail notification is disabled, see the Server Setup Guide for details on enabling it.


please provide any pointers.
Thanks,
Rajesh

0 votes


Permanent link
My understanding is that with WAS you either need to use LDAP or a custom registry for user authentication -- Tomcat user authentication is not supported. The custom registry option is only valid for test environments, in production environments LDAP should be used.

The directions in the RQM + WAS setup document (https://jazz.net/help-dev/rational-quality-manager/topic/com.ibm.rational.test.qm.install.doc/topics/t_instl_config_rqm_was.html) give instructions on following either of these two options.

When done, you'll want to run https://localhost:9445/jazz/setup (or https://localhost:9443/jazz/setup) and choose the user registry option you picked.

At that point I restarted the WAS server for good measure. But my server errors disappeared at that point.

We're testing against WAS 7.x instead of 6.x, so things might work a little differently for you.

0 votes


Permanent link
Hi Glenn,

I have selected NON-LDAP External User Registry Option in Setup User Registry page, this Solved our problem. Thanks alot for your Help .

Regards,
Rajesh

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: Aug 07 '09, 6:46 a.m.

Question was seen: 6,105 times

Last updated: Aug 07 '09, 6:46 a.m.

Confirmation Cancel Confirm