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

Error on work item query for specific team area criteria

Questions
Tags
Users
Badges
Kevin Ramer
(4.5k●9●186●201) 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

0 votes

8 answers
7,788 views
0 votes

8 answers

Permanent link
Daniel Pool
JAZZ DEVELOPER (264●4) May 18 '12, 12:56 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.

0 votes

Permanent link
Kevin Ramer
(4.5k●9●186●201) 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.

0 votes

Permanent link
Daniel Pool
JAZZ DEVELOPER (264●4) May 20 '12, 6:51 p.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.

0 votes

Permanent link
Kevin Ramer
(4.5k●9●186●201) 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.

0 votes

Permanent link
Kamil Smoron
(21) 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

0 votes

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

0 votes

Permanent link
Kamil Smoron
(21) 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.

0 votes

Permanent link
Oliver Vinn
(26●1) 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.

0 votes

Comments
Oliver Vinn
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 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

Question asked: May 16 '12, 10:02 a.m.

Question was seen: 7,788 times

Last updated: Dec 14 '12, 5:58 a.m.

Confirmation Cancel Confirm