Hi:
I have an ssrs report that was working, but now when I try and run it, a message shows up: "Navigation to the webpage was canceled". Other ssrs reports run just fine. I can run the report in BIDS and on the Reports webpage.
I tried redeploying the report, but this one report will not display in Tessitura. Has anyone else experienced this?
Thanks in advance,
James
I have discovered that if I rename the report in the Tessitura report setup, the report displays again without any issues (very strange). This report is using some custom code inside it, I do not see the connection with the problem, but it is the only report that has custom code.
The code:
Public Function DivideBy(ByVal Exp1, ByVal Exp2)
If Exp2 = 0 Then
DivideBy = 0
Else : DivideBy = Exp1 / Exp2
End If
End Function
I don’t think this would be the issue, unless it was causing the report not to render properly. If this was the case, you wouldn’t be able to run it properly outside of Tessitura. I would check the SSRS log to see if you see anything differently there.
The other thing to check is that the path set in the Tessitura Report Setup is correct.
+Ryan Creps
+Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of James FairfieldSent: Thursday, February 02, 2012 12:47 PMTo: Ryan CrepsSubject: Re: [Tessitura Technical Forum] SSRS: Navigation to the webpage was canceled
I have discovered that if I rename the report in the Tessitura report setup, the report displays again without any issues (very strange). This report is using some custom code inside it, I do not see the connect with the problem, but it is the only report that has custom code.
From: James Fairfield <bounce-jamesfairfiled8203@tessituranetwork.com>Sent: 2/1/2012 5:16:25 PM
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!
Hi Ryan:
In the tessitura Report Setup System Name field, I only changed the report name from ATTPAC Perf Sales Summary by PT Category to ATTPAC Perf Sales Summary by PT Category_ , and suddenly the report works.
I am looking at the log, but it doesn't make much sense to me.
Is there some setting I need to flush out so I do not have to change the name? I am concerned that this could start happening to all of my SSRS reports, and I will have to keep changing names to keep the reports working.
-James
Here is the last log entry where I tried both names:
library!WindowsService_192!874!02/03/2012-10:44:18:: i INFO: Call to CleanBatch() ends
library!ReportServer_0-121!1b2c!02/03/2012-10:47:54:: Call to GetItemTypeAction(/Reports/ATTPAC Performance Sales Summary by PT Category).
library!ReportServer_0-121!1b2c!02/03/2012-10:47:54:: i INFO: RenderForNewSession('/Reports/ATTPAC Performance Sales Summary by PT Category')
library!ReportServer_0-121!7a4!02/03/2012-10:51:19:: Call to GetItemTypeAction(/Reports/ATTPAC Performance Sales Summary by PT Category).
library!ReportServer_0-121!7a4!02/03/2012-10:51:19:: i INFO: RenderForNewSession('/Reports/ATTPAC Performance Sales Summary by PT Category')
library!WindowsService_192!166c!02/03/2012-10:54:18:: i INFO: Call to CleanBatch()
library!WindowsService_192!166c!02/03/2012-10:54:18:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
library!WindowsService_192!166c!02/03/2012-10:54:18:: i INFO: Call to CleanBatch() ends
Hi
I came across similar issues when recreating our InfoMaker reports in SSRS. If the SSRS and IM report names are the same I get the navigation cancelled error. If I change the names of either report it corrects it. This came to light when I looked at the page properties of a report which had failed load.
Mark
This is a small, but known issue. There’s a spot in the Report processing path that uses the name of the report instead of the underlying ID of the report (the report id defined in the Report Setup). What you’re seeing is the Report window trying to use the URL from the definition used for the Infomaker datawindow. Since there is no URL it simply fails the page navigation. The workaround (for now) is to either rename the old (deprecated, e.g.), or rename the new.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Mark SteelSent: Thursday, March 15, 2012 6:56 AMTo: Ryan CrepsSubject: RE: [Tessitura Technical Forum] SSRS: Navigation to the webpage was canceled
From: James Fairfield <bounce-jamesfairfiled8203@tessituranetwork.com>Sent: 2/3/2012 11:11:00 AM