locked
SSRS 2016: An Error occurred during execution of a SSRS 2016 MP managed module RRS feed

  • Question

  • New SCOM 1801 deployment and can't seem to find a solution for

    SSRS 2016: An Error occurred during execution of a SSRS 2016 MP managed module

    and

    SSRS 2016: Instance cannot connect to SSRS web service

    Module: Microsoft.SQLServer2016.ReportingServices.Module.Discovery.DeploymentSeed Version: 6.7.31.0 ---------- Exception: ---------- Exception happened during module execution: at Microsoft.SQLServer2016.ReportingServices.Module.Helper.TimeoutThreadExecutor`1.Execute(Func`1 func, Int32 timeout, ManualResetEvent executeFinished) at Microsoft.SQLServer2016.ReportingServices.Module.Helper.ModuleBasePropertyHelper`1.GetOutputData(DataItemBase[] inputDataItems) at Microsoft.SQLServer2016.ReportingServices.Module.Helper.ModuleBaseHelper`1.OnNewDataItems(DataItemBase[] dataItems, Boolean logicallyGrouped, DataItemAcknowledgementCallback acknowledgeCallback, Object acknowledgedState, DataItemProcessingCompleteCallback completionCallback, Object completionState) in Microsoft.SQLServer.2016.ReportingServices.Module.Helper ---------- Inner Exception: ---------- Unable to get database server service state: Got no valid result while trying to run WMI query 'SELECT Name, State, StartMode,PathName FROM Win32_Service WHERE Name = 'MSSQLSERVER'' for the path '\\SQLDB.Domain\root\CIMV2'. Error persisted after 3 tries. at Microsoft.SQLServer2016.ReportingServices.Module.Discovery.DeploymentSeed.GetModuleData(DataItemBase[] inputDataItems) at Microsoft.SQLServer2016.ReportingServices.Module.Helper.TimeoutThreadExecutor`1.<>c__DisplayClass0_0.<Execute>b__0() in Microsoft.SQLServer.2016.ReportingServices.Module.Discovery ---------- Inner Exception: ---------- Got no valid result while trying to run WMI query 'SELECT Name, State, StartMode,PathName FROM Win32_Service WHERE Name = 'MSSQLSERVER'' for the path '\\SQLDB.Domain\root\CIMV2'. Error persisted after 3 tries. at Microsoft.SQLServer2016.ReportingServices.Module.Helper.Wmi.RetryPolicyWmiHelper.Query(String queryString) at Microsoft.SQLServer2016.ReportingServices.Module.Helper.Info.WindowsServiceInfo..ctor(String serviceName, String serverName, String user, String password) at Microsoft.SQLServer2016.ReportingServices.Module.Discovery.DeploymentSeed.GetModuleData(DataItemBase[] inputDataItems) in Microsoft.SQLServer.2016.ReportingServices.Module.Helper The configuration properties are : ServerName = SSRS.Domain InstanceName = MSSQLSERVER DatabaseServerName = SQLDB.Domain DatabaseInstanceName = MSSQLSERVER DatabaseName = ReportServer TempDatabaseName = ReportServerTempDB InstallationID = 00322DDA-1322-4FFB-A2B9-22E51113FB0E ClassId = {5E82317E-9D56-5FE9-C26B-439F5CDEE60F} DiscoverySourceObjectId = {EE1F35DF-1AF0-10E1-1D26-86701A6CDAC8} DiscoverySourceManagedEntityId = {E6607039-99FD-9276-F22F-899530C8D8A2} SQLTimeOut = 200 Publisher = ReportingServices2016 TimeoutSeconds = 300 

    The only SSRS instance is the one for SCOM so far.  I don't know if this will also appear on others.

    SSRS seems to work fine through the console or the web interface

    Date and Time: 3/14/2018 1:33:13 PM 
    Property Name Property Value 
    Status Error 
    StatusCode 500 
    Errors An error occurred when invoking the authorization extension. (rsAuthorizationExtensionError) Value does not fall within the expected range.  
    
    

    Wednesday, March 14, 2018 9:54 PM

Answers

All replies