July 2, 2015 at 11:13 am
Hi,
We have bunch of SSRS reports. We have a website where the end customer can login and run the reports from frontend.
Some of the reports are not working from them (From fronentend) but those are working in report manager url.
Any thing need to check here (Some reports are working but not all)
July 2, 2015 at 3:52 pm
I would start with comparing the differences between the reports that are working and those that are not. What errors do you get when you try to run the reports that don't work?
July 2, 2015 at 3:58 pm
When I execute the report from the frontend I found the below message from logs and
from the frontend I am getting the msg like sorry an error occured while processing your request Notfound
From SSRS Logs:
library!ReportServer_0-1!2e04!07/02/2015-16:15:42:: i INFO: Call to GetPermissionsAction(/).
library!ReportServer_0-1!1a2c!07/02/2015-16:15:42:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-1!2e04!07/02/2015-16:15:42:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-1!2e04!07/02/2015-16:15:42:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-1!1a2c!07/02/2015-16:15:42:: i INFO: Call to ListChildrenAction(/, False).
library!ReportServer_0-1!2e04!07/02/2015-16:15:42:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!2e04!07/02/2015-16:15:42:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1a2c!07/02/2015-16:15:42:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1a2c!07/02/2015-16:15:43:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!19a0!07/02/2015-16:15:43:: i INFO: Call to GetPermissionsAction(/).
library!ReportServer_0-1!1a2c!07/02/2015-16:15:43:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-1!19a0!07/02/2015-16:15:43:: i INFO: Call to GetPropertiesAction(/, PathBased).
library!ReportServer_0-1!1a08!07/02/2015-16:15:43:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-1!19a0!07/02/2015-16:15:43:: i INFO: Call to ListChildrenAction(/, False).
library!ReportServer_0-1!1a2c!07/02/2015-16:15:43:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1a2c!07/02/2015-16:15:43:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!19a0!07/02/2015-16:15:43:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!19a0!07/02/2015-16:15:43:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!2d50!07/02/2015-16:16:48:: i INFO: Call to GetReportParametersAction(/Test Report).
library!ReportServer_0-1!1250!07/02/2015-16:16:51:: i INFO: Call to GetReportParametersAction(/Test Report).
library!ReportServer_0-1!1250!07/02/2015-16:16:53:: i INFO: RenderForNewSession('/Test Report')
library!ReportServer_0-1!1250!07/02/2015-16:17:25:: i INFO: Using folder D:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
library!ReportServer_0-1!1250!07/02/2015-16:17:31:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!1250!07/02/2015-16:17:32:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!2d50!07/02/2015-16:17:34:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!1284!07/02/2015-16:17:35:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!2d50!07/02/2015-16:17:36:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!1284!07/02/2015-16:17:38:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!2d50!07/02/2015-16:17:39:: i INFO: RenderFromSession('/Test Report')
library!ReportServer_0-1!1284!07/02/2015-16:17:41:: i INFO: RenderFromSession('/Test Report')
But when I ran the same report from report manger, I got the msg like below and it ran fine
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Call to CleanBatch()
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Using folder C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 31 chunks, 0 running jobs, 0 persisted streams, 41 segments, 41 segment mappings, 0 edit sessions.
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Call to CleanBatch() ends
library!ReportServer_0-1!1a08!07/02/2015-16:32:59:: i INFO: Call to GetPermissionsAction(/Test Report).
library!ReportServer_0-1!1a08!07/02/2015-16:32:59:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1a08!07/02/2015-16:32:59:: i INFO: Call to GetPropertiesAction(/Test Report, PathBased).
library!ReportServer_0-1!1a08!07/02/2015-16:32:59:: i INFO: Call to GetSystemPermissionsAction().
ui!ReportManager_0-2!1478!07/02/2015-16:32:59:: i INFO: PageCountMode 'Estimate' read from config file
library!ReportServer_0-1!1a08!07/02/2015-16:33:00:: i INFO: Call to GetSystemPropertiesAction().
wcfruntime!ReportServer_0-1!1250!07/02/2015-16:33:01:: i INFO: Entering ExeuteCommand - Command = StyleSheet
library!ReportServer_0-1!e7c!07/02/2015-16:33:19:: i INFO: Call to GetPermissionsAction(/Test Report).
library!ReportServer_0-1!e7c!07/02/2015-16:33:19:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!e7c!07/02/2015-16:33:19:: i INFO: Call to GetPropertiesAction(/Test Report, PathBased).
library!ReportServer_0-1!e7c!07/02/2015-16:33:19:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-1!e7c!07/02/2015-16:33:19:: i INFO: Call to GetSystemPropertiesAction().
wcfruntime!ReportServer_0-1!15b8!07/02/2015-16:33:19:: i INFO: Entering ExeuteCommand - Command = StyleSheetImage
library!ReportServer_0-1!1a08!07/02/2015-16:33:19:: i INFO: Call to GetPermissionsAction(/Test Report).
library!ReportServer_0-1!1a08!07/02/2015-16:33:19:: i INFO: Call to GetSystemPropertiesAction().
library!ReportServer_0-1!1a08!07/02/2015-16:33:19:: i INFO: Call to GetPropertiesAction(/Test Report, PathBased).
library!ReportServer_0-1!1a08!07/02/2015-16:33:19:: i INFO: Call to GetSystemPermissionsAction().
library!ReportServer_0-1!1a08!07/02/2015-16:33:20:: i INFO: Call to GetSystemPropertiesAction().
wcfruntime!ReportServer_0-1!1a08!07/02/2015-16:33:20:: i INFO: Entering ExeuteCommand - Command = Render
library!ReportServer_0-1!1a08!07/02/2015-16:33:20:: i INFO: RenderForNewSession('/Test Report')
webserver!ReportServer_0-1!1a08!07/02/2015-16:33:51:: i INFO: Processed report. Report='/Test Report', Stream=''
July 2, 2015 at 4:29 pm
I didn't find any source difference, snapshot options or processing options
July 2, 2015 at 4:35 pm
Did you notice this difference?
D:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
But when I ran the same report from report manger, I got the msg like below and it ran fine
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Call to CleanBatch()
library!WindowsService_0!2a38!07/02/2015-16:24:21:: i INFO: Using folder C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\RSTempFiles for temporary files.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 2, 2015 at 5:20 pm
Sorry actually it was D only but when I editing the report name changed in place the path C:/ instead of D:/
July 4, 2015 at 5:16 pm
Do the reports that don't work reference local resources (e.g. images)?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 5, 2015 at 8:46 pm
Yes. It has to show some graphs. Dates in X-axis and correspond values in Y-axis.
Is there anything needs to be change for graphs (images)? We are using Native mode not the sharepoint
July 5, 2015 at 10:14 pm
ramana3327 (7/5/2015)
Yes. It has to show some graphs. Dates in X-axis and correspond values in Y-axis.Is there anything needs to be change for graphs (images)? We are using Native mode not the sharepoint
Graphs are generated on the fly.
When I ask about images, I am asking if you are referencing anything like a png, gif, or jpg file from disk resource on the server.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 5, 2015 at 11:15 pm
Can you please let me how to check this
When I open the .RDL in VisualStudio, it is showing that it executing sp. I didn't see further details. How can we know the report is using external image (.Jpg) or not?
July 6, 2015 at 3:17 pm
It is in the Report Data section. Left-hand side. There is a folder called "Images".
Joie Andrew
"Since 1982"
July 6, 2015 at 9:56 pm
I didn't see any images there.
I find the link
It showing the images will be stored in 3 ways.
In that case the images tab that we check from .RDL is embedded images. So I think there is no embed images for this report but I am not sure about the external images we might have any!
July 15, 2015 at 2:59 am
Any help on this issue. The issue is still continuning. Some reports are working from the website but some not.
Is this related to the memory or any other resource issue?
July 15, 2015 at 9:23 am
Do the reports try to access any on disk xml files?
It seems like you are relatively new to SSRS and Report development. This is an issue that just may be best served by getting a consultant on premise.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 15, 2015 at 10:00 pm
I don't think it is trying to access any xml. It is using sp as dataset
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply