It's all about the answers!

Ask a question

Corrupt date value


Neha Malviya (623) | asked Oct 29 '14, 3:12 a.m.

While fetching the workitems from older RTC template we are getting the error reported at the end of the post. Due to which we are unable to fetch all the workitems.

For me is quite straightforward that it was a date misconfigured, but i need to solve this, as we often use the Eclipse Client, and it's a very troublesome error.

Any Helps?

com.ibm.team.repository.common.TeamRepositoryException: org.eclipse.emf.ecore.resource.Resource$IOWrappedException: Value '0,113-07-31T12:00:00.000Z' is not legal. (, 38395, 48)

2 answers



permanent link
Ralph Schoon (63.1k33646) | answered Oct 29 '14, 4:49 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
It is unclear to me, in which context that happens. Is it a built in attribute?
If the items load in the Web UI, I would expect them to load in the Eclipse UI as well.

I would try to find one or two examples, look at the values and try to figure out what they contain and if it is possible to fix the dates should they be wrong. You could potentially use automation (based on Java) or bulk updates in the Web UI, I assume.

It might be also a good idea to approach support with the examples you found and ask for a solution.

Comments
Neha Malviya commented Oct 29 '14, 4:58 a.m. | edited Oct 29 '14, 5:00 a.m.

Thanks for the response.

We automated (using java) the procedure to migrate the data from older RTC template to latest one . So there when we are trying to get the data from the old project area then the below error is stopping the java code.

com.ibm.team.repository.common.TeamRepositoryException: org.eclipse.emf.ecore.resource.Resource$IOWrappedException: Value '0,113-07-31T12:00:00.000Z' is not legal. (, 38395, 48)


Ralph Schoon commented Oct 29 '14, 5:19 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

If this is automation, you should be able to get the ID of the work item. I would also expect that you can get at the raw data and find out what is wrong with it.

You can always wrap the statement with try/catch and use debugging to find out what is wrong - if there is anything wrong with it.

Date values are funny. I have described some experiences I had here: http://rsjazz.wordpress.com/2014/07/22/manage-scheduled-absences-using-the-plainjava-client-libraries/


Neha Malviya commented Oct 30 '14, 7:00 a.m. | edited Oct 30 '14, 7:08 a.m.

Yes we kept the try catch and all other exceptions.

Problem here is that while fetching the data from code it fetches upto 1724th record successfully and stops at 1725 record but everytime the workitem is changed so we are unable to find like due to which workitem this is giving error.Also the error remains same everytime. To debug these much records is also difficult so put breakpoint at the exception and got that corrupt date message.

Do you have any solution how can we resolve through this?


Ralph Schoon commented Oct 30 '14, 7:11 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

You can try to use a minimal item load profile e.g. one that only loads the ID and print that. Then load the full profile. See http://rsjazz.wordpress.com/2013/03/20/understanding-and-using-the-rtc-java-client-api/ for load profiles.


permanent link
Neha Malviya (623) | answered Nov 05 '14, 3:25 a.m.

The problem here is when we are trying to get the full data from RTC Eclipse client then it is showing the below error:

com.ibm.team.repository.common.TeamRepositoryException: org.eclipse.emf.ecore.resource.Resource$IOWrappedException: Value '0,204-02-13T12:00:00.000Z' is not legal. (, 22845, 48)

If we run the query from web then we are able to get the full data in csv file but from RTC Eclipse client it is shwoing illegal date error every time for different record.

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.