Thursday, August 8, 2013

Report Manager pointing to a different environment after database refresh

The link on the List tab in Report Manager comes from PSRF_REPORT_URL field in PSRF_RINFO_TBL. This field gets populated when you run a report and it is posted to report manager. The API that populates the field uses URI_RPT field value in PS_CDM_DIST_NODE table which stores all the report node related setup data to generate a url to access the report. Unfortunately, this field is not on the report node setup page and can easily be overlooked. If you have multiple report node definitions make sure to update this field for all of them in your refresh scripts. Also, If you make some changes to the report node definition this URI_RPT field get updated with the correct value.


P.S.: Applies to Tools 8.49. I have not looked into other releases