SSRS Subscription issue - fail with permission issue

Eshwar 196 Reputation points
2021-10-25T09:36:16.163+00:00

HI,
I am facing issue with SSRS subscription, it use to work for different user but I have changed the user/owner and it is not working.

It is giving below error and the new user has same role as old user.
143404-image.png

The user used for shared location has all permission and it is same user used during old subscription also.

Also the subscription on same report with different users, one works and one doesn't:
143357-image.png

In the report logs I see below:
library!WindowsService_3!3d5c!10/25/2021-09:02:26:: i INFO: Call to CleanBatch() ends
library!ReportServer_0-3!2960!10/25/2021-09:03:55:: i INFO: Call to GetSubscriptionPropertiessAction(c62dab5b-8cbb-449c-8ba7-0170233c22bd). User: ramch.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:55:: i INFO: Call to GetItemTypeAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:55:: i INFO: Call to GetReportParametersAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
schedule!WindowsService_3!343c!10/25/2021-09:03:55:: i INFO: Handling event with data: TimeEntered: 10/25/2021 09:03:55, Type: Event, EventType: TimedSubscription, SubscriptionID: c62dab5b-8cbb-449c-8ba7-0170233c22bd.
library!WindowsService_3!343c!10/25/2021-09:03:55:: i INFO: Schedule faed939c-32e4-4950-85c0-37c1bdc66967 executed at 10/25/2021 09:03:55.
schedule!WindowsService_3!343c!10/25/2021-09:03:55:: i INFO: Creating Time based subscription notification for subscription: c62dab5b-8cbb-449c-8ba7-0170233c22bd
library!WindowsService_3!343c!10/25/2021-09:03:55:: i INFO: Schedule faed939c-32e4-4950-85c0-37c1bdc66967 execution completed at 10/25/2021 09:03:55.
library!WindowsService_3!3d5c!10/25/2021-09:03:56:: i INFO: Initializing EnableExecutionLogging to 'False' as specified in Server system properties.
notification!WindowsService_3!3d5c!10/25/2021-09:03:56:: i INFO: Handling subscription c62dab5b-8cbb-449c-8ba7-0170233c22bd to report Tag Action Report, owner: ramch, delivery extension: Report Server FileShare.
library!WindowsService_3!3d5c!10/25/2021-09:03:56:: i INFO: RenderForNewSession('/Debt Manager Custom Reporting/Tag Action Report')
library!WindowsService_3!3d5c!10/25/2021-09:03:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'ramch' are insufficient for performing this operation.;
library!WindowsService_3!3d5c!10/25/2021-09:03:56:: i INFO: Initializing EnableExecutionLogging to 'False' as specified in Server system properties.
subscription!WindowsService_3!3d5c!10/25/2021-09:03:56:: i INFO: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The permissions granted to user 'ramch' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'ramch' are insufficient for performing this operation.
notification!WindowsService_3!3d5c!10/25/2021-09:03:56:: e ERROR: Error occurred processing subscription c62dab5b-8cbb-449c-8ba7-0170233c22bd: Failure writing file Tag Action Report : The permissions granted to user 'ramch' are insufficient for performing this operation.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:56:: i INFO: Call to GetItemTypeAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:56:: i INFO: Call to GetReportParametersAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:56:: i INFO: Call to GetItemTypeAction(/Debt Manager Custom Reporting/Monthly Collections Breakdown). User: ramch.
library!ReportServer_0-3!3bf8!10/25/2021-09:03:56:: i INFO: Call to GetReportParametersAction(/Debt Manager Custom Reporting/Monthly Collections Breakdown). User: ramch.
library!ReportServer_0-3!2960!10/25/2021-09:03:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly ReportingServicesSharePointDeliveryExtension, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesSharePointDeliveryExtension' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name)
--- End of inner exception stack trace ---;
extensionfactory!ReportServer_0-3!2960!10/25/2021-09:03:56:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesSharePointDeliveryExtension' or one of its dependencies. The system cannot find the file specified..
library!ReportServer_0-3!2960!10/25/2021-09:03:56:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
extensionfactory!ReportServer_0-3!2960!10/25/2021-09:03:56:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. .
library!ReportServer_0-3!1660!10/25/2021-09:04:10:: i INFO: Call to GetItemTypeAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
library!ReportServer_0-3!1660!10/25/2021-09:04:10:: i INFO: Call to GetReportParametersAction(/Debt Manager Custom Reporting/Tag Action Report). User: ramch.
library!ReportServer_0-3!3170!10/25/2021-09:04:10:: i INFO: Call to GetItemTypeAction(/Debt Manager Custom Reporting/Monthly Collections Breakdown). User: ramch.
library!ReportServer_0-3!3170!10/25/2021-09:04:10:: i INFO: Call to GetReportParametersAction(/Debt Manager Custom Reporting/Monthly Collections Breakdown). User: ramch.
library!ReportServer_0-3!2fc8!10/25/2021-09:04:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly ReportingServicesSharePointDeliveryExtension, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesSharePointDeliveryExtension' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.LoadAssembly(String name)
--- End of inner exception stack trace ---;
extensionfactory!ReportServer_0-3!2fc8!10/25/2021-09:04:10:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesSharePointDeliveryExtension' or one of its dependencies. The system cannot find the file specified..
library!ReportServer_0-3!2fc8!10/25/2021-09:04:10:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
extensionfactory!ReportServer_0-3!2fc8!10/25/2021-09:04:10:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. .

Really appreciate any inputs!

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,988 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,601 Reputation points
    2021-10-26T02:08:50.487+00:00

    Hi @Eshwar ,
    I see many errors in your log file.

    Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'ramch' are insufficient for performing this operation.

    The Reporting Services error rsAccessedDenied occurs when a user does not have permission to perform an action. For example, they don't have a role assignment that allows them to open a report, or they didn't open their browser with the required permissions.
    Permission to access report server content and operations are granted through role assignments. On a new installation, only local administrators have access to a report server. To grant access to other users, a local administrator must create a role assignment that specifies a domain user or group account, one or more roles that define the tasks the user can perform, and a scope (usually the Home folder or root node of the report server folder hierarchy). You can use the web portal to create role assignments. For more information, see Role Assignments .

    This error is also caused by local administration of the report server. For more information, see Configure a Native Mode Report Server for Local Administration (SSRS).

    Exception caught instantiating Report Server DocumentLibrary report server extensio

    I researched it, and the problem may be in your rsreportingservice.config file.
    Check whether the configuration file contains the SharePoint delivery extension, if so, please delete it:

     <!--<Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">  
                <MaxRetries>3</MaxRetries>  
                <SecondsBeforeRetry>900</SecondsBeforeRetry>  
                <Configuration>  
                    <DocumentLibraryConfiguration>  
                        <ExcludedRenderFormats>  
                            <RenderingExtension>HTMLOWC</RenderingExtension>  
                            <RenderingExtension>NULL</RenderingExtension>  
                            <RenderingExtension>RGDI</RenderingExtension>  
                        </ExcludedRenderFormats>  
                    </DocumentLibraryConfiguration>  
                </Configuration>  
            </Extension>-->  
    

    If not, please ignore. If you have manually modified the rsreportingservice.config file before, please delete your changes and enter the previous values, or if you have a backup, restore the previous version.

    Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly ReportingServicesSharePointDeliveryExtension, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesSharePointDeliveryExtension' or one of its dependencies. The system cannot find the file specified.

    This is a general purpose error that occurs when either the report server or a report authoring tool has invalid configuration settings. The error is usually accompanied by a second message that states the actual cause of the error. An assembly is missing here, but it is not clear which assembly it is. It may not be the one mentioned in the error. You need to figure out what assembly is missing. . You can run FusionLog to get more detailed information. The Assembly Binding Log Viewer displays details for assembly binds. This information helps you diagnose why the .NET Framework cannot locate an assembly at run time. These failures are usually the result of an assembly deployed to the wrong location, a native image that is no longer valid, or a mismatch in version numbers or cultures. The common language runtime's failure to locate an assembly typically shows up as a TypeLoadException in your application.This tool is automatically installed with Visual Studio. To run the tool, use Visual Studio Developer Command Prompt or Visual Studio Developer PowerShell with administrator credentials.Note:You must run fuslogvw.exe with administrator privileges.
    If this error began to occur after you manually edited a configuration file, remove your changes and enter the previous value, or restore a previous version if you have a backup.
    For more information, please see: https://stackoverflow.com/questions/255669/how-to-enable-assembly-bind-failure-logging-fusion-in-net
    For rsServerConfigurationError, please refer to: rsServerConfigurationError-Reporting Services Error.

    Hope this helps.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


  2. Nathan Bolstad 0 Reputation points
    2025-01-31T10:41:49.08+00:00

    I Just same across something similar to this tonight.

    TL;DR - If the "owner" of the subscription is a disabled account (former employee), and the output path is to a location where the user authorizes to, (e.g. a UNC path), then you get this error.

    To fix, edit the subscription and update the owner to an account that exists and isn't disabled.

    Hope this helps any future person with a similar error.

    N.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.