It's all about the answers!

Ask a question

Query error in RTC


Jorge Alarcon (3119) | asked May 17 '16, 6:37 p.m.
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

Comments
Donald Nong commented 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 commented May 18 '16, 12:06 p.m. | edited 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


1
Donald Nong commented 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?


Jorge Alarcon commented 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.

2 answers



permanent link
Daisy Huang (428) | answered May 27 '17, 2:09 a.m.

I met the same problem.

Within one specific project area, I got error creating a query from web client using team area is "a team area"and log is as yours. I reviewed all the team areas in this project area and didn't find any problem. How did you get this problem resolved in the end?


permanent link
Lawrence Smith (3764) | answered May 07, 12:34 p.m.
JAZZ DEVELOPER

 This is an old question but this issue appears to occur should there be a team area which is not part of any development line. The development line is null and this causes the query to fail with an NPE. The fix should be to associate the team area with the development line.


Comments
Kevin Ramer commented May 17, 10:07 a.m.

Or IIRC, have a Project timeline,

Your answer


Register or to post your answer.