clm - error about timesheet reports on v4.0.5

Eray İzgin (116●16●23) | asked Feb 24 '14, 8:49 a.m.
edited Feb 24 '14, 8:55 a.m. by Krzysztof Kaźmierczyk (7.4k●3●54●99)

hi,

we are receiving following error message on timesheet reports.In detail we use tomcat as app.server, SQL server as databases, version CLM 4.0.5 . One of that reports works successfully that is "workitem Timesheet Summary". Other of them(personal timesheet, personal timesheet by project area, personal timesheet by workitem) result with the error:

Table (id = 1367):
+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Work Items
Failed to prepare the following query for the data set type (com.ibm.team.reports.generic.advancedDataSet).
[PROJECT_AREA_NAME = ProjectArea AND CATEGORY_ITEMID IN Category AND DEV_LINE_NAME IN Timeline AND ITERATION_NAME IN Iteration]
org.eclipse.datatools.connectivity.oda.OdaException: Parse error near: PROJECT_AREA_NAME = ProjectArea AND CATEGORY_ITEMID IN

Thanks

Comments

Krzysztof Kaźmierczyk commented Feb 24 '14, 8:54 a.m.

Hi Eray,
What is full stack trace of the issue? You will find it in ccm.log file on your server.

Eray İzgin commented Feb 24 '14, 9:02 a.m. | edited Feb 24 '14, 9:10 a.m.

Hi Kaźmierczyk,

When I run the reports , jts.log has changed.

"OAuthMessage(GET, https://gtjazzdev:9443/jts/service/com.ibm.team.repository.service.internal.license.ILicenseRestService/assertLicense, [oauth_nonce=-190445588764981988, oauth_token=, oauth_consumer_key=bf47d3e85b784b92828cdb5dd2b273b0, oauth_signature_method=HMAC-SHA1, oauth_timestamp=1393250208, oauth_version=1.0, oauth_signature=xB9E6j69Q6f4QCIvkCJKbU1IWFw%3D, operationId=com.ibm.team.reports.service.report.display, user=https%3A%2F%2Fgtjazzdev%3A9443%2Fjts%2FcontributorIdentity%2F_KGRY4CFWEdq-WY5y7lROQw, assign=true])"

2014-02-24 16:56:48,774 [http-bio-9443-exec-340 @@ 16:56 RTCBUILDUSR /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderReport] DEBUG m.team.repository.service.internal.oauth.Validator - Not tracking nonce value "-190445588764981988" in request for "https://gtjazzdev:9443/jts/service/com.ibm.team.repository.service.internal.license.ILicenseRestService/assertLicense" because a secure protocol is used.

2014-02-24 16:56:48,790 [http-bio-9443-exec-340 @@ 16:56 RTCBUILDUSR /jazz/service/com.ibm.team.reports.common.internal.service.IReportRestService/renderReport] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - [EXITING] validateMessage

2014-02-24 16:57:13,485 [jts: AsynchronousTaskRunner-4 @@ 16:57] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - [ENTERING] pruneExpiredTokens

2014-02-24 16:57:13,485 [jts: AsynchronousTaskRunner-4 @@ 16:57] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - [ENTERING] isAccessorExpired

2014-02-24 16:57:13,485 [jts: AsynchronousTaskRunner-4 @@ 16:57] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - Returning false for expired token

2014-02-24 16:57:13,485 [jts: AsynchronousTaskRunner-4 @@ 16:57] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - [EXITING] isAccessorExpired

2014-02-24 16:57:13,485 [jts: AsynchronousTaskRunner-4 @@ 16:57] DEBUG sitory.service.internal.oauth.OAuthServiceProvider - [EXITING] pruneExpiredTokens

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Krzysztof Kaźmierczyk (7.4k●3●54●99) | answered Feb 24 '14, 9:16 a.m.

Hi Eray,
I would not expect any error in jts.log. I think it is not related. We had couple of issues with Java version embedded in WAS which caused error when reports running. It is described on http://www-01.ibm.com/support/docview.wss?uid=swg21616615.
This might be affecting you as well.
If it does not help, then please open new PMR.

Comments

Eray İzgin commented Feb 24 '14, 9:35 a.m. | edited Feb 25 '14, 1:18 a.m.

Thank you for your helping but the link is not related to our problem and we also use tomcat for CLM. I will open PMR.

It's all about the answers!

Related questions

clm - error about timesheet reports on v4.0.5

One answer

Your answer