How can report templates be extracted from RTC ?
Follow on to:
https://jazz.net/forum/questions/108730/how-to-troubleshoot-birt-reports-that-consume-excessive-timecpu
One group has successfully determined how to bring their RTC application to a crashing halt apparently due to their report resources. I can find Active Services like this:
Active Services
Service Name Running Time Requested By More Information
com.ibm.team.repository.service.internal.ServerStatusRestService.getActiveServiceInfo 00:00:00:000 Kevin Ramer Show Details
com.ibm.team.reports.service.internal.ReportRestService.postRenderReport 02:18:51:855 LU XIAO Show Details
com.ibm.team.reports.service.internal.ReportRestService.postRenderReport 03:21:17:363 LU XIAO Show Details
[ Those are *small* running time compared to most, before the application died almost 20h for one and several going with minimum 14h ]
I need to get all the non-ootb report design out of the RTC database to at least try to find the smoking gun. Who can help ?
https://jazz.net/forum/questions/108730/how-to-troubleshoot-birt-reports-that-consume-excessive-timecpu
One group has successfully determined how to bring their RTC application to a crashing halt apparently due to their report resources. I can find Active Services like this:
Active Services
Service Name Running Time Requested By More Information
com.ibm.team.repository.service.internal.ServerStatusRestService.getActiveServiceInfo 00:00:00:000 Kevin Ramer Show Details
com.ibm.team.reports.service.internal.ReportRestService.postRenderReport 02:18:51:855 LU XIAO Show Details
com.ibm.team.reports.service.internal.ReportRestService.postRenderReport 03:21:17:363 LU XIAO Show Details
[ Those are *small* running time compared to most, before the application died almost 20h for one and several going with minimum 14h ]
I need to get all the non-ootb report design out of the RTC database to at least try to find the smoking gun. Who can help ?
One answer
There is no direct way but you can narrow down by checking the <user> against the postRenderReport Active Service.
Then narrow down the recently run reports by that <user>
https://<server>:<port>/ccm/view-history?type=com.ibm.team.reports.ReportViewer&type=com.ibm.team.reports.ReportTemplateEditor&size=10&user=<user>
The long running report should be one of these (hopefully it won't be a long list)
Then narrow down the recently run reports by that <user>
https://<server>:<port>/ccm/view-history?type=com.ibm.team.reports.ReportViewer&type=com.ibm.team.reports.ReportTemplateEditor&size=10&user=<user>
The long running report should be one of these (hopefully it won't be a long list)
