Error on work item query for specific team area criteria
If users specify one particular team area on query (only criteria) the Web UI
responds with:
Eclipse client gives nullPointerException
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
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.
|
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. |
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. |
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 installed 3.0.1.3 and was unable to reproduce the problem. 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 |
I tried to duplicate following steps given kamil. But was unable to reproduce.
|
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. |
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
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.