Unable to configure RPE report to work in RTC as a report resource
I have a report template that I generated in RPE that I am trying to deploy in RTC so that people without access to RPE can use it.
I followed the instructions from this page:
and was able to get the template and .dsx file uploaded. However, I I think I have been unable to properly configure it (as described in https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.rational.rrdg.usage.doc%2Ftopics%2Ft_rrdg_make_reports_avail.html)
When I try to run the report in RTC it appears to begin generating, but then errors...
"Details:
Starting run...
Consuming RPE license...
Error in engine No output specified.
Aborting engine execution..."
I'm not sure if the issue is in RPE where I may not have correctly defined the configuration metadata or in RTC, where I may have missed something.
Thanks.
8 answers
It sounds like there is some missing configuration information for the output in the document specification (.dsx). Take a look at this section of the Rational Publishing Engine documentation:
http://pic.dhe.ibm.com/infocenter/rpehelp/v1r2/topic/com.ibm.rational.pe.publishing.doc/topics/c_output.html
It might be that you need to configure an output type, such as Microsoft Word, with an output path, for example.
Note that, in many cases, you don't really need to upload the *.dsx to the server in order to run the report - you can use just the *.dta instead. You can do thing like configure the data source URL and set variable values as parameters of the report in RTC, without needing to upload a *.dsx.
Comments
Hi Sym,
When you import your custom report into RTC and run it, all the data sources will show up as parameters - you can then set values for the data source URLs. You do not need to provide user name/password information - the report will run with the credentials of the user who is logged in to RTC.
Also, you should consider converting your comment to a question - that way, more people will see it and be able to help.
I'm hunting through these forums trying to find data about how to do this. I thought I might comment here since this thread seems relevant to my problem.
I have a report which will work when I explicitly specify user credentials as part of the data source configuration. If I leave those credentials blank, the report runs but is unable to fetch data from work items. The data source is being used dynamically.
I read another post that indicated that if I was using a dynamic data source, I needed to use at least one other data source that was not dynamic. Presumably, this enables one data source to provide authentication credentials for the other. I tried that, but it doesn't seem to be working either.
How does this work?
Hi Nate,
You may want to convert this comment to a question; it will get more visibility than commenting on an old thread.
What version of CLM are you using, and which application are you trying to run your report from? Generally, when running RPE reports on the server, you don't need to upload the *.dsx. Is there a reason that you want to use hard-coded user credentials, instead of running the report as whatever user is logged into CLM? Also, are you getting an error when you run the report, or is it just not returning any data? If you are getting an error, can you post the full text here?
You're correct that there is some extra configuration needed if your report has dynamic data sources (though, I'm actually not sure if that's the case if you're trying to use hard-coded credentials). What have you added as the second data source? When you run the report on the server, what parameters does it have, and what have you entered as values for them?
Alanna, to provide some closure on my participation in this thread, we ended opening a Service Request on this. In our case, the problem was that RTC was configured as a friend of itself. We had read somewhere that this was supposed to be done in certain scenarios. We removed that configuration and it started working.
It was a confusing issue to diagnose, but at least for us that was the solution.
Thanks for the update Nate, and glad your problem was resolved. FYI, as of CLM 5.0.1, reports are now tolerant of the case where an application is a friend of itself - so you wouldn't need to remove the friend anymore to get your reports to run.
Alanna:
I do not use .dsx files when uploading RQM report to server, but it is not responding to a WORD style sheet that is uploaded. The word template is a .dot with the filename the same as the report .dta file. Are there specifics to how this should be done if you are NOT using .dsx files? Report is not responding to styles identified in .dta and .dot file when exported to WORD.
Comments
Hi Michele,
Stylesheets are one case where you will need to upload a *.dsx to the server. See instructions here (step 7 in particular):
https://www-01.ibm.com/support/knowledgecenter/SSYMRC_4.0.3/com.ibm.rational.rrdg.usage.doc/topics/t_rrdg_make_reports_avail.html?lang=en
This forum post also contains some additional advice about using stylesheets.
Also, you didn't mention what version of CLM you're using, but support for stylesheets was only added in 4.0.3 - so keep that in mind as well.