INTRODUCTION
A client of mine is upgrading their SP 2010 environment to SP 2016. As part of the migration work, the RDL files also need to be migrated.
Installing and configuring the SQL Report Service for SharePoint is rather easy. You just run the SQL Install wizard and choose the SQL Reporting for SharePoint features. After that, you provision the Service Application and that’s it.
I then downloaded the RDL files from the old server and re-upload to the new farm. Using the new Report Designer, the RDL file loads fine. However, when I tried to view it as a user, the report does not render. None of the filter buttons work either. I also got the following errors in the browser console:
Refused to apply style from ‘<URL>’ because its MIME type (”) is not a supported stylesheet MIME type, and strict MIME checking is enabled.
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/CorrespondenceProcessingDetailsForStaff – Copy.rdl:1 Refused to execute script from ‘http://intranet/Reserved.ReportViewerWebPart.axd?OpType=Resource&Version=13.0.4001.0&Name=Microsoft.ReportingServices.Rendering.HtmlRenderer.RendererResources.jquery.min.js’ because its MIME type (”) is not executable, and strict MIME type checking is enabled.
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/CorrespondenceProcessingDetailsForStaff – Copy.rdl:1 Refused to execute script from ‘http://intranet/Reserved.ReportViewerWebPart.axd?OpType=Resource&Version=13.0.4001.0&Name=Microsoft.ReportingServices.Rendering.HtmlRenderer.RendererResources.jqueryui.min.js’ because its MIME type (”) is not executable, and strict MIME type checking is enabled.
Reserved.ReportViewerWebPart.axd:1 Failed to load resource: the server responded with a status of 404 (Not Found)
RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/CorrespondenceProcessingDetailsForStaff – Copy.rdl:1 Refused to execute script from ‘http://intranet/Reserved.ReportViewerWebPart.axd?OpType=Resource&Version=13.0.4001.0&Name=Microsoft.ReportingServices.Rendering.HtmlRenderer.RendererResources.Html5Renderer.js’ because its MIME type (”) is not executable, and strict MIME type checking is enabled.
ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:45 Uncaught Error: Sys.ArgumentUndefinedException: Value cannot be undefined.
Parameter name: method
at Function.Error$create [as create] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:237)
at Function.Error$argumentUndefined [as argumentUndefined] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:361)
at Function$_validateParameterType [as _validateParameterType] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:161)
at Function$_validateParameter [as _validateParameter] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:130)
at Function$_validateParams [as _validateParams] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:84)
at Function$createDelegate [as createDelegate] (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:41)
at new ReportingServices.WebFormsClient._Toolbar (Reserved.ReportViewerWebPart.axd?OpType=Resource&Version=13.0.4001.0&Name=ViewerScript:5403)
at Sys$Component$create (ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:3811)
at Array.<anonymous> (RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/CorrespondenceProcessingDetailsForStaff – Copy.rdl:704)
at ScriptResource.axd?d=ObD4p27Ocfljw18PB7KdznZSplSvoS6tJOmwvz-KY9WcGgg1RkAnAGP8lZeSQ9CadKWliarHm4H7-lwbPciuMLP7yPKcf99E_OgqMdy7qWNu_TkKaX_Awbmf4oidL7y2_4zrlbghnOUxvsg67aDzZZKhOFDgFMniwOeCOKMDlL4Wk__820o5R59E4J0xAN1C0&t=ffffffffad4b7194:3484
/favicon.ico:1 Failed to load resource: the server responded with a status of 404 (Not Found)
RESOLUTION
The resolution turns out to be very simple. Basically, the viewer won’t work if you turn on debugging ON in web.config.
So, just set the following:
<SafeMode …CallStack=”true”
<customErrors mode=”On” />
<compilation batch=”false” debug=”false”>
Hope this helps,
Tommy
