It's all about the answers!

Ask a question

Work items export data truncated when parent link column inc


Mark Ingebretson (58515236) | asked May 19 '09, 3:42 p.m.
We're trying to export work item information including parent/child
status. We created a query in the web client which allows the addition
of "Parent" as a data column.

Doing an Export function in the Eclipse client specifying that query and
csv format results in a file being created. But when we look at the
data in Excel, we see that the data is truncated part way through.
After some experimentation we realized that the csv file is always
exactly a multiple of 8K. Almost always the file size is 24K, but we've
also seen it be 8K.

This doesn't happen with the Parent column not part of the display results.

I see that each time the truncated data file is created there are two
errors in the server system log. Here are the first few lines of each
trace (full traces available)

Throwable
java.lang.IllegalStateException
at
org.apache.catalina.connector.ResponseFacade.sendError(ResponseFacade.java:405)
at
com.ibm.team.workitem.service.internal.query.ResultSetSerializer.serializeItem(ResultSetSerializer.java:86)
at
com.ibm.team.gateway.service.internal.AbstractRestService.serializeItem(AbstractRestService.java:323)
at
com.ibm.team.gateway.service.internal.ItemRestService.doReadResponse(ItemRestService.java:191)
at
com.ibm.team.gateway.service.internal.ItemRestService.perform_GET(ItemRestService.java:105)
at
com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:81)

Location

com.ibm.team.foundation.common.util.FoundationLog.unexpectedError(FoundationLog.java:140)
ERROR - Query _efu64ERwEd6Aad2iW8wEcQ expired
Tuesday, May 19, 2009 7:28 AM
Query _efu64ERwEd6Aad2iW8wEcQ expired.

Throwable

com.ibm.team.repository.common.QueryExpiredException: Query
_efu64ERwEd6Aad2iW8wEcQ expired.
at
com.ibm.team.repository.service.internal.QueryService.doFetchPage(QueryService.java:559)
at
com.ibm.team.repository.service.internal.QueryService.fetchPage(QueryService.java:241)
at sun.reflect.GeneratedMethodAccessor245.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)

Location
com.ibm.team.foundation.common.util.FoundationLog.unexpectedError(FoundationLog.java:140)

The server is V1.0.1.

Thanks!

2 answers



permanent link
Patrick Streule (4.9k21) | answered May 21 '09, 6:46 a.m.
JAZZ DEVELOPER
We're trying to export work item information including parent/child
status. We created a query in the web client which allows the addition
of "Parent" as a data column.

Doing an Export function in the Eclipse client specifying that query and
csv format results in a file being created. But when we look at the
data in Excel, we see that the data is truncated part way through. After
some experimentation we realized that the csv file is always exactly a
multiple of 8K. Almost always the file size is 24K, but we've also seen
it be 8K.

This doesn't happen with the Parent column not part of the display
results.

You are running into
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/62878

I would recommend to upgrade from 1.0.1 to 1.0.1.1 where the problem is
fixed.

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Mark Ingebretson (58515236) | answered May 21 '09, 7:29 a.m.
Patrick Streule wrote:
We're trying to export work item information including parent/child
status. We created a query in the web client which allows the
addition of "Parent" as a data column.

Doing an Export function in the Eclipse client specifying that query
and csv format results in a file being created. But when we look at
the data in Excel, we see that the data is truncated part way through.
After some experimentation we realized that the csv file is always
exactly a multiple of 8K. Almost always the file size is 24K, but
we've also seen it be 8K.

This doesn't happen with the Parent column not part of the display
results.

You are running into
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/62878


I would recommend to upgrade from 1.0.1 to 1.0.1.1 where the problem is
fixed.


Thanks, Patrick. We were wondering if that was the issue, but we hadn't
seen any mention of this truncation problem before.

We'll upgrade our server to 1.0.1.1.

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.