Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

clm - error about timesheet reports on v4.0.5

Questions
Tags
Users
Badges
Eray İzgin
(116●1●17●24) edited
Feb 24 '14, 8:55 a.m.
 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

0 votes

Comments
Krzysztof Kaźmierczyk
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
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


1 answer
4,939 views
0 votes

One answer

Permanent link
Krzysztof Kaźmierczyk
(7.5k●4●80●103) 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.

0 votes

Comments
Eray İzgin
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 log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 481
× 324

Question asked: Feb 24 '14, 8:49 a.m.

Question was seen: 4,939 times

Last updated: Feb 25 '14, 1:18 a.m.

Confirmation Cancel Confirm