It's all about the answers!

Ask a question

Error on work item query for specific team area criteria


Kevin Ramer (4.5k8183200) | asked May 16 '12, 10:02 a.m.
If users specify one particular team area on query (only criteria) the Web UI
responds with:

The server is not responding or a page navigation occurred before an operation completed. Check that your server connection is working and that the server is operational, then try the action again or refresh the page.


Eclipse client gives nullPointerException


com.ibm.team.repository.common.transport.ServiceMethodInvocationError: java.lang.NullPointerException
at com.ibm.team.repository.transport.client.RemoteTeamService.getAppropriateException(Unknown Source)
at com.ibm.team.repository.transport.client.RemoteTeamService.executeMethod(Unknown Source)
at com.ibm.team.repository.transport.client.RemoteTeamService.invoke(Unknown Source)
at com.ibm.team.repository.transport.client.ServiceInvocationHandler.invoke(Unknown Source)
at $Proxy37.fetchQueryResults(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invokeServiceCall(Unknown Source)
at com.ibm.team.repository.client.internal.ServiceInterfaceProxy.invoke(Unknown Source)
at $Proxy37.fetchQueryResults(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryCommon$3.run(Unknown Source)
at com.ibm.team.workitem.client.internal.ClientServiceContext$1.run(Unknown Source)
at com.ibm.team.repository.client.internal.TeamRepository$3.run(Unknown Source)
at com.ibm.team.repository.common.transport.CancelableCaller.call(Unknown Source)
at com.ibm.team.repository.client.internal.TeamRepository.callCancelableService(Unknown Source)
at com.ibm.team.workitem.client.internal.ClientServiceContext.callCancelableService(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryCommon.fetchQueryResults(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.fetchFirstPage(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.update(Unknown Source)
at com.ibm.team.workitem.common.internal.query.QueryResultIterator.getResultSize(Unknown Source)
at com.ibm.team.workitem.rcp.ui.internal.viewer.QueryWorkItemRetrievalStrategy.retrieveRootsBackground(Unknown Source)
at com.ibm.team.workitem.rcp.ui.internal.viewer.QueryWorkItemRetrievalStrategy$1.retrieve(Unknown Source)
at com.ibm.team.workitem.rcp.ui.internal.viewer.ResultRetrievalStrategy$RetrievalTask.run(Unknown Source)
at com.ibm.team.workitem.rcp.ui.internal.viewer.ResultRetrievalStrategy$RetrievalJob.runProtected(Unknown Source)
at com.ibm.team.foundation.client.util.FoundationJob.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Unknown Source)
Caused by: java.lang.NullPointerException
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.getPredicate(TeamAreaEqualsOperation.java:123)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.createExpressionPredicate(ASTTransformer.java:387)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:297)
at com.ibm.team.workitem.common.expression.AttributeExpression.accept(AttributeExpression.java:126)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:250)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:143)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:250)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:143)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:250)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:143)
at com.ibm.team.workitem.common.expression.Statement.accept(Statement.java:91)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.transform(ASTTransformer.java:189)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults(QueryRepositoryService.java:182)
at sun.reflect.GeneratedMethodAccessor414.invoke(null)
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:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy365.fetchQueryResults(null)
at sun.reflect.GeneratedMethodAccessor414.invoke(null)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleMethod(AbstractTeamServerServlet.java:1285)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.executeMethod(AbstractTeamServerServlet.java:882)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doPost(AbstractTeamServerServlet.java:672)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:1871)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:1725)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.access$0(AbstractTeamServerServlet.java:1710)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet$1.service(AbstractTeamServerServlet.java:198)
at com.ibm.team.repository.internal.service.auth.impl.JAuthHandler.handleRequest(JAuthHandler.java:95)
at sun.reflect.GeneratedMethodAccessor115.invoke(null)
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:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy154.handleRequest(null)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1578)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
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:729)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:581)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:811)
at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(Unknown Source)
at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeExceptions(Unknown Source)
at com.ibm.team.repository.common.internal.marshal.util.MarshallerUtil.decodeFault(Unknown Source)
at com.ibm.team.repository.transport.client.RemoteTeamService.constructExceptionFromFault(Unknown Source)


The team area does have a work item category assigned. That category does
have similar name to another category associated with sub-team of first. Using
Filed Against works.

Server 3.0.1.3, AIX 6.1, Apache Tomcat, DB2 back end.

Kevin

8 answers



permanent link
Daniel Pool (2644) | answered May 18 '12, 12:56 p.m.
JAZZ DEVELOPER
I have tested this 4.0 RC 4a and was unable to reproduce it. I plan to install a 3.0.1.3 client and see if I can reproduce it with that setup.

permanent link
Kevin Ramer (4.5k8183200) | answered May 18 '12, 4:05 p.m.
I have tested this 4.0 RC 4a and was unable to reproduce it. I plan to install a 3.0.1.3 client and see if I can reproduce it with that setup.


User has queried via BIRT and found NULL values in couple of "default" columns.

permanent link
Daniel Pool (2644) | answered May 20 '12, 6:51 p.m.
JAZZ DEVELOPER
I installed 3.0.1.3 and was unable to reproduce the problem.

I created a team area.
Set up a category to be associated with the team area.
Created a user in the team area.
Created a new work item.
Set the filed against attribute to the category associated with the team area. Created a query to return work items with the given team area.
Ran the query.
Got back the work item I had created.

If an attribute has not had a value set it can be null. So I am not sure what that might have to do with this issue.

So I don't really have anything to suggest other than that query by category should work for you, and you can use that instead of query by team area.

permanent link
Kevin Ramer (4.5k8183200) | answered May 21 '12, 8:51 a.m.
Query by category works as I pointed that out as alternative to user.

The null column was DEFAULT_TEAM_AREA_ITEM_ID in the MODEL.CATEGORY table, not on a work item attribute. There are only 4 such
rows in this particular repository database at the moment. I think there were more than 10.

Thanks for your replies.

I installed 3.0.1.3 and was unable to reproduce the problem.

I created a team area.
Set up a category to be associated with the team area.
Created a user in the team area.
Created a new work item.
Set the filed against attribute to the category associated with the team area. Created a query to return work items with the given team area.
Ran the query.
Got back the work item I had created.

If an attribute has not had a value set it can be null. So I am not sure what that might have to do with this issue.

So I don't really have anything to suggest other than that query by category should work for you, and you can use that instead of query by team area.

permanent link
Kamil Smoron (21) | answered May 22 '12, 9:25 a.m.
I installed 3.0.1.3 and was unable to reproduce the problem.

I created a team area.
Set up a category to be associated with the team area.
Created a user in the team area.
Created a new work item.
Set the filed against attribute to the category associated with the team area. Created a query to return work items with the given team area.
Ran the query.
Got back the work item I had created.

If an attribute has not had a value set it can be null. So I am not sure what that might have to do with this issue.

So I don't really have anything to suggest other than that query by category should work for you, and you can use that instead of query by team area.


Hi,

Referring to your test on 3.0.1.3. Could you please try additionally the following steps, as I suspect this triggered the original problem:

1. Create additional Work Item Category plus Team Area, User and a Work Item as before
2. Create a new query for the above Team Area - it should work just fine at this point
3. Now, for the first Team Area you have created, please reassign the work item category from Team Area to Project Area (in Eclipse you can do it in the Project Area view using buttons called "Disassociate" or "Associate Project Area").
4. Try to run the query

permanent link
Daniel Pool (2644) | answered May 23 '12, 4:43 p.m.
JAZZ DEVELOPER
I tried to duplicate following steps given kamil. But was unable to reproduce.

permanent link
Kamil Smoron (21) | answered May 25 '12, 7:01 a.m.
I tried to duplicate following steps given kamil. But was unable to reproduce.


I don't have any other ideas as what might have caused this.
Thank you for trying the steps.

permanent link
Oliver Vinn (261) | answered Dec 14 '12, 5:38 a.m.
 This still happens (4.0.0.1). Query sometimes fails with null pointer exception when querying the team area.

...
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.lang.NullPointerException
at com.ibm.team.workitem.common.internal.query.TeamAreaEqualsOperation.getPredicate(TeamAreaEqualsOperation.java:125)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.createExpressionPredicate(ASTTransformer.java:405)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:296)
at com.ibm.team.workitem.common.expression.AttributeExpression.accept(AttributeExpression.java:135)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:249)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:249)
at com.ibm.team.workitem.common.expression.Term.accept(Term.java:163)
at com.ibm.team.workitem.service.internal.query.ASTTransformer.visit(ASTTransformer.java:249)
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:188)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults2(QueryRepositoryService.java:202)
at com.ibm.team.workitem.service.internal.query.QueryRepositoryService.fetchQueryResults(QueryRepositoryService.java:193)

...

At the very least you should improve the error report to allow some meaningful attempt at resolving it - or provide guidance on how to investigate. It isn't good enough to say it works in a clean environment.

Comments
Oliver Vinn commented Dec 14 '12, 5:58 a.m.

Likewise using the Rest Reporting it is possible to see that some work itemsĀ didn'tĀ have a team area association?


I then went to the <any> timeline and assigned the category to a specific team area away from the <project area> association. This resolved the issue.

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.