Query error in RTC
Hi
Everytime I try to run a query throws an error but only with an specific condition, everytime I use this condition "Team Area = Workqueue" it throws an error. any other condition on any other team area works fine
In a widget a user got this error
CRRDV5024E The work item query could not be retrieved from the server. The server encountered an unexpected error that prevented it from retrieving the work item query. To find more details about this issue, open the JavaScript console of your browser by pressing F12, refresh the widget, and check the JavaScript console for any resulting errors.
I see this on the logs :
2016-05-17 16:38:31,905 [WebContainer : 145 @@ 16:38 dstacces@us.ibm.com <com.ibm.team.workitem.newQuery/Run@54618061-ce49-4c68-8965-05279640be36> /ccm/service/com.ibm.team.workitem.common.internal.rest.IQueryRestService/getResultSet] WARN .team.repository.servlet.AbstractTeamServerServlet - CRJAZ1163I NullPointerException processing POST request for com.ibm.team.workitem.common.internal.rest.IQueryRestService.postGetResultSet(). CRJAZ1170I The request was made by user "dstacces@us.ibm.com" from "9.80.223.163".CRJAZ1166I The stack trace hash is 70F5172D0B053859DB2CF624A868CA07E9C553F4.
java.lang.NullPointerException
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.createPredicate(TeamAreaEqualsOperation.java:178)
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.getPredicate(TeamAreaEqualsOperation.java:88)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.createExpressionPredicate(ASTTransformer.java:580)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:415)
at com.ibm.team.workitem.common.expression.AttributeExpression.accept(AttributeExpression.java:136)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.common.expression.Statement.accept(Statement.java:90)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.transform(ASTTransformer.java:302)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults2(QueryRepositoryService.java:206)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults(QueryRepositoryService.java:197)
at sun.reflect.GeneratedMethodAccessor393.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy699.fetchQueryResults(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(QueryCommon.java:160)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(QueryCommon.java:1)
at com.ibm.team.workitem.service.internal.ServerServiceContext.callCancelableService(ServerServiceContext.java:31)
at com.ibm.team.workitem.common.internal.query.QueryCommon.fetchQueryResults(QueryCommon.java:157)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.fetchFirstPage(QueryResultIterator.java:151)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.update(QueryResultIterator.java:129)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.getResultSize(QueryResultIterator.java:113)
at com.ibm.team.workitem.common.internal.query.ResolvingQueryResultIterator.getResultSize(ResolvingQueryResultIterator.java:111)
at com.ibm.team.workitem.service.internal.rest.QueryResultConverter.createResultSetDto(QueryResultConverter.java:140)
at com.ibm.team.workitem.service.internal.rest.QueryResultConverter.convertQueryResultToResultSetDTO(QueryResultConverter.java:88)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.postGetResultSet(QueryRestService.java:988)
at sun.reflect.GeneratedMethodAccessor391.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy786.postGetResultSet(Unknown Source)
at sun.reflect.GeneratedMethodAccessor390.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:573)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2525)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2316)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:939)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
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:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Can you please advice?
Regards
Everytime I try to run a query throws an error but only with an specific condition, everytime I use this condition "Team Area = Workqueue" it throws an error. any other condition on any other team area works fine
In a widget a user got this error
CRRDV5024E The work item query could not be retrieved from the server. The server encountered an unexpected error that prevented it from retrieving the work item query. To find more details about this issue, open the JavaScript console of your browser by pressing F12, refresh the widget, and check the JavaScript console for any resulting errors.
I see this on the logs :
2016-05-17 16:38:31,905 [WebContainer : 145 @@ 16:38 dstacces@us.ibm.com <com.ibm.team.workitem.newQuery/Run@54618061-ce49-4c68-8965-05279640be36> /ccm/service/com.ibm.team.workitem.common.internal.rest.IQueryRestService/getResultSet] WARN .team.repository.servlet.AbstractTeamServerServlet - CRJAZ1163I NullPointerException processing POST request for com.ibm.team.workitem.common.internal.rest.IQueryRestService.postGetResultSet(). CRJAZ1170I The request was made by user "dstacces@us.ibm.com" from "9.80.223.163".CRJAZ1166I The stack trace hash is 70F5172D0B053859DB2CF624A868CA07E9C553F4.
java.lang.NullPointerException
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.createPredicate(TeamAreaEqualsOperation.java:178)
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.getPredicate(TeamAreaEqualsOperation.java:88)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.createExpressionPredicate(ASTTransformer.java:580)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:415)
at com.ibm.team.workitem.common.expression.AttributeExpression.accept(AttributeExpression.java:136)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:363)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.common.expression.Statement.accept(Statement.java:90)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.transform(ASTTransformer.java:302)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults2(QueryRepositoryService.java:206)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults(QueryRepositoryService.java:197)
at sun.reflect.GeneratedMethodAccessor393.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy699.fetchQueryResults(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(QueryCommon.java:160)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(QueryCommon.java:1)
at com.ibm.team.workitem.service.internal.ServerServiceContext.callCancelableService(ServerServiceContext.java:31)
at com.ibm.team.workitem.common.internal.query.QueryCommon.fetchQueryResults(QueryCommon.java:157)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.fetchFirstPage(QueryResultIterator.java:151)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.update(QueryResultIterator.java:129)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.getResultSize(QueryResultIterator.java:113)
at com.ibm.team.workitem.common.internal.query.ResolvingQueryResultIterator.getResultSize(ResolvingQueryResultIterator.java:111)
at com.ibm.team.workitem.service.internal.rest.QueryResultConverter.createResultSetDto(QueryResultConverter.java:140)
at com.ibm.team.workitem.service.internal.rest.QueryResultConverter.convertQueryResultToResultSetDTO(QueryResultConverter.java:88)
at com.ibm.team.workitem.service.internal.rest.query.QueryRestService.postGetResultSet(QueryRestService.java:988)
at sun.reflect.GeneratedMethodAccessor391.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy786.postGetResultSet(Unknown Source)
at sun.reflect.GeneratedMethodAccessor390.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModelledRestService(AbstractTeamServerServlet.java:573)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2525)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2316)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1230)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:779)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:478)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:939)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1818)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
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:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Can you please advice?
Regards
Comments
Donald Nong
May 18 '16, 1:00 a.m.Can you please clarify whether the condition is "Team Area = Workqueue" or "Team Area is Workqueue"? Also, which version of RTC?
Jorge Alarcon
May 18 '16, 11:08 p.m.Hi Donald
The condition is Team Area is Workqueue and it is on RTC version 6.0 with iFix 6.0
Regards
Donald Nong
May 18 '16, 11:11 p.m.I don't see such problem in my own RTC 6.0.1 environment or the sandbox on jazz.net (6.0.2). The stack trace suggests that the error does occur when constructing the condition, so I suspect there is something wrong with the team areas (perhaps data corruption?) in your project . Do you see this in all the projects?
1 vote
Jorge Alarcon
May 18 '16, 11:52 p.m.Yeah, I'm beginning to suspect the same, I have tested on some other project areas using the same template than this one and I'm not seeing any problem like this one, and it only happens on this team area, not other one. The team area will have to be reviewed.
Thanks so much for the help Donald.