SharePoint 2010, 2013, 2016 RSReportViewer SQL Report Viewer not rendering error

Posted in: SharePoint 2010, SharePoint 2010 Errors, SharePoint 2013, SharePoint 2013 Errors |

No comments

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

Written by

A web solution expert who has passion in website technologies. Tommy has been in the web industry for more than 10 years. He started his career as a PHP developer and has now specialized in ASP.NET, SharePoint and MS CRM. During his career he has also been in many roles: system tester, business analyst, deployment and QA manager, team and practice leader and IT manager.

No Comments Yet.

Leave a Reply

You must be logged in to post a comment.

Our Services

We provides you the best Services in our themes.

  • Click on the link below to see a full list of clients which we have developed solutions and provided consultancy for.

    READ MORE

  • We are solution-centered and not application-centered.

    READ MORE

  • Being creative and having fun and yet still delivering a fantastic service is the center of our values.

    READ MORE

  • TFS Consulting Services guarantees delivery that is within budget and deadline or you engage us for free.

    READ MORE

Implementing IT does not have to be difficult.

As long as you have the right methodologies

We have heard a lot of complaints from our clients that IT a lot of the times give them headache. The issues range from over-budget implementation, server is too hard to maintain, application is not user friendly, features not complete and many others. If you have ever experienced similar situations, don’t worry. This is why TFS Consulting Services is here. We exist to help clients implementing a successful IT solution. We have various methodologies which we have proven working in delivering a successful IT implementation. Below is the list of some of our key service offerings:
  • Planning and Methodologies

    Implementing IT solution does not have to be difficult. TFS Consulting Services has a lot of resources on planning and methodologies that will ensure successful delivery of your IT solution. TFS Consulting Services has been around in the web industry for more than 10 years and has experienced all the successes and failures of various type of IT deployment.

    read more

  • Technical Resource

    Do you need a technical resource? TFS Consulting Services can also provide you with technical resource for developing ASP.NET (C# and VB.NET), SharePoint (2003, 2007, 2010, 2013) and MS CRM applications. Our resource is an Microsoft Certified Personnel (MVP) and Microsoft Certified Technology Specialist (MCTS) in all ASP.NET, SharePoint and CRM.

    read more

  • IT Consulting & Advice

    Make sure your IT implementation is robust and scalable. TFS Consulting Services can provide consulting and advice on industry’s best practice on various web-related areas such as website security, design and usability, application-specific (such as SharePoint)’s best practice, Search Engine Optimisation (SEO), coding standards and many others.

    read more

  • Solution Development

    Finally TFS Consulting Services provides you with solution development service. We mainly work with Microsoft technologies (ie. .NET and SQL Server), however we are also capable of developing with PHP and MySQL. If you ever need any business process automation, integration and solution development work,  we are the trusted expert you should go to.

    read more

For more detailed service offerings please visit our Solutions page.

Testimonials

  • I’m happy to recommend Tommy as a knowledgeable and diligent developer.

    Mike Stringfellow, Vivid Group
  • Tommy has a lot of great ideas that can be delivered into great products. It’s a pleasure working with him because he has a broad knowledge about available technologies out there and he knows what’s best for the client’s needs. He just knows how to work effectively and efficiently.

    Teddy Segoro, Student Edge
  • I’ve worked with Tommy over the past 6 months and have found his approach to development (especially SharePoint) absolutely outstanding. Tommy goes beyond the boundries of typical software development with his ability understand what a client requires and then build it into fully fledged software solution. Coupled with his professional “Best Practice” approach, you get Continue Reading

    Michael Bonham, DSC-IT

Contact us

Tommy Segoro
tommy@tfsconsulting.com.au
+61 404 457 754

   

© TFS Consulting Services 2024. All rights reserved.

www.incorporator.com.au