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

how to increase query result limit in RTC 4.0.5

Questions
Tags
Users
Badges
Aparna Sukumaran
(33●37●60) edited
Sep 15 '14, 6:03 p.m.
I want to change the Query result limit in RTC from 1000 to 2000.

Edited -  Server --> Advanced properties --> WorkItem Queries -->Maximum Query Result set size  to 2000.

How to make the changes?

It shows a error "Invalid registry Object" Error

Invalid registry object
hide details
org.eclipse.core.runtime.InvalidRegistryObjectException
org.eclipse.core.internal.registry.RegistryObjectManager.basicGetObject(RegistryObjectManager.java:272)
org.eclipse.core.internal.registry.RegistryObjectManager.getObject(RegistryObjectManager.java:262)
org.eclipse.core.internal.registry.ConfigurationElementHandle.getConfigurationElement(ConfigurationElementHandle.java:26)
org.eclipse.core.internal.registry.ConfigurationElementHandle.getName(ConfigurationElementHandle.java:99)
com.ibm.team.repository.common.transport.AbstractElementDescriptor.safeGetName(AbstractElementDescriptor.java:304)
com.ibm.team.repository.common.transport.AbstractElementDescriptor.getAncestor(AbstractElementDescriptor.java:288)
com.ibm.team.repository.common.transport.AbstractElementDescriptor.getAncestor(AbstractElementDescriptor.java:323)
com.ibm.team.repository.common.transport.internal.registry.ConfigurationPropertyElementDescriptor.getServiceProviderElement(ConfigurationPropertyElementDescriptor.java:172)
com.ibm.team.repository.common.transport.internal.registry.ConfigurationPropertyElementDescriptor.getComponentId(ConfigurationPropertyElementDescriptor.java:113)
com.ibm.team.repository.common.transport.internal.registry.ConfigurationPropertyElementDescriptor.getQualifiedName(ConfigurationPropertyElementDescriptor.java:160)
com.ibm.team.repository.common.transport.internal.registry.ConfigurationManager$ConfigurationPropsRegistry.(ConfigurationManager.java:615)
com.ibm.team.repository.common.transport.internal.registry.ConfigurationManager$1.prePersistHook(ConfigurationManager.java:239)
com.ibm.team.jfs.app.config.internal.ChangeCollection.applyPrePersistHooks(ChangeCollection.java:66)
com.ibm.team.jfs.app.config.internal.OverridablePropertyFileServerConfiguration.persistChanges(OverridablePropertyFileServerConfiguration.java:347)
com.ibm.team.jfs.app.config.internal.ConfigurationPropertyService.persistChangesLocally(ConfigurationPropertyService.java:410)
com.ibm.team.jfs.app.config.internal.ConfigurationPropertyService.applyLocally(ConfigurationPropertyService.java:387)
com.ibm.team.jfs.app.config.internal.ConfigurationPropertyService.applyLocally(ConfigurationPropertyService.java:394)
com.ibm.team.jfs.app.config.internal.ServiceConfigurationUpdate.applyLocally(ServiceConfigurationUpdate.java:47)
com.ibm.team.jfs.app.config.internal.ServiceConfigurationUpdate.apply(ServiceConfigurationUpdate.java:58)
com.ibm.team.repository.common.transport.internal.registry.ServiceConfigurationUpdate.apply(ServiceConfigurationUpdate.java:55)
com.ibm.team.repository.service.internal.ServerConfigurationRestService.postConfigurationUpdates(ServerConfigurationRestService.java:289)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
com.sun.proxy.$Proxy50.postConfigurationUpdates(Unknown Source)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
java.lang.reflect.Method.invoke(Method.java:611)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:530)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2353)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2153)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1963)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
java.lang.Thread.run(Thread.java:761)

 

0 votes

Comments
sam detweiler
Sep 15 '14, 8:00 p.m.

The max is 1000 

Aparna Sukumaran
Sep 15 '14, 8:18 p.m.

I see Forums to edit this value "Maximum Query Result set size"  or to make changes in teamserver.properties file up to 2000. Did we had a higher limit in previous versions?

Donald Nong
Sep 15 '14, 8:37 p.m.

Had a quick test in my RTC 4.0.6 environment and no problems were found. There seems to be some corruption in your deployment. You can "Request Server Rest" (via /ccm/admin?internal=true) to re-deploy the CCM application, or simply modify the teamserver.properties file

com.ibm.team.workitem.query.resultset.limit=2000


Aparna Sukumaran
Sep 16 '14, 11:46 a.m.

  To make changes in Teamserver properties which folder I need to look for the file?

1 answer
3,941 views
0 votes

Accepted answer

Permanent link
Don Yang
(7.7k●21●114●139) Sep 15 '14, 11:05 p.m.
Usually when you see such error, you can restart the server and then save should work.
There is one known defect which you may hit and it is fixed in v5.0.1:

https://jazz.net/jazz/web/projects/Jazz%20Foundation#action=com.ibm.team.workitem.viewWorkItem&id=314907

There is a technote within the above workitem and the workaround is what Donald suggested. You can surely modify the teamserver.properties file directly per Donald's advice.

If you add the query to dashboard's widget, the number showing in the widget will be capped to 1000 no matter whether you have advanced property updated or not. This is a limitation in RTC currently and the existing RFE is as below: please comment there as well if you want the enhancement to be done:
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=266345
A technote regarding this limitation is here: http://www-01.ibm.com/support/docview.wss?uid=swg21684168



Ralph Schoon selected this answer as the correct answer

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.

Ask a question
Guidelines
FAQ
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
× 12,019

Question asked: Sep 15 '14, 4:04 p.m.

Question was seen: 3,941 times

Last updated: Sep 16 '14, 11:46 a.m.

Confirmation Cancel Confirm