It's all about the answers!

Ask a question

clm - error about timesheet reports on v4.0.5


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


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.