It's all about the answers!

Ask a question

clm - error about timesheet reports on v4.0.5


Eray İzgin (1161423) | asked Feb 24 '14, 8:49 a.m.
edited Feb 24 '14, 8:55 a.m. by Krzysztof Kaźmierczyk (7.4k34693)
 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.

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 sitory.service.internal.oauth.OAuthServiceProvider  -       Creating new accessor for pre-authorized consumer with empty token
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 sitory.service.internal.oauth.OAuthServiceProvider  -       [ENTERING] validateMessage
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 sitory.service.internal.oauth.OAuthServiceProvider  -         OAuthMessage 
"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: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]  getAccessor
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]  handleProxiedRequest
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]  handleOAuthRequest
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



permanent link
Krzysztof Kaźmierczyk (7.4k34693) | 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.

Your answer


Register or to post your answer.