It's all about the answers!

Ask a question

how to increase query result limit in RTC 4.0.5


Aparna Sukumaran (333760) | asked Sep 15 '14, 4:04 p.m.
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)

 

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

The max is 1000 


Aparna Sukumaran commented 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 commented 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 commented Sep 16 '14, 11:46 a.m.

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

Accepted answer


permanent link
Don Yang (7.7k21114139) | answered 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

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.