Hello,
I'm new to SSRS and I need to deploy reports that exist in Live to our Test environment as soon as possible. Unfortunately, my predecessors did not add any of the custom reports to Test. There's nothing like trial by fire. We're on RAMP. The only instructions I've received from Tessitura are:
1) Go into the BIDS project containing your custom reports in LIVE 2) Change the config to the TEST location and deploy
If someone could step me through this, I'd greatly appreciate it.
Thank you!
--
Regards,
Troy Nelson
Additionally, I receive the following error message when I try to preview the report in Visual Studio. I’ve also attached the error message I receive when I attempt to run the report in Tessitura Test.
Shereen Marino Data Analysis Manager | The Phoenix Symphony | Tel. 602-452-0414 | Fax. (602) 253-1772 SMarino@PHOENIXSYMPHONY.ORG | www.phoenixsymphony.org
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, October 16, 2013 9:36 AM To: Shereen Marino Subject: Re: [Tessitura Technical Forum] Deploying Existing SSRS Reports in Test
I'm not completely familiar with the RAMP architecture, but I assume that it's due to the fact that they have completely separate instances running for SSRS in each environment. When I deploy to Live it is hitting a different server than when I deploy to Test. While I do have only one copy of the SSRS RDL files, the deployed reports live on separate machines for Live and Test.
For Infomaker reports there are actually separate copies of the PBL files for live and test since the reports in the PBLs are the actual files being executed against when the reports are run. For SSRS the deployed reports are not the same files as the RDLs in the Project.
From: Chris Jensen <bounce-chrisjensen8841@tessituranetwork.com> Sent: 10/16/2013 9:23:50 AM
Levi Sauerbrei:The Live to Test copy does bring over your report setup and SQL scripts, but you will need to deploy custom SSRS reports to the Test environment at least once to have them work.
Levi Sauerbrei:
The Live to Test copy does bring over your report setup and SQL scripts, but you will need to deploy custom SSRS reports to the Test environment at least once to have them work.
Strange. As long as I copy the impresario and ReportServer dbs to Test at the same time, my custom SSRS reports work fine w/o deploying again. Is it a RAMP requirement of some sort? Sorry to misinform if so...
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!