I suggest you ...

Fix SSRS 2017 Integration

When rolling out SSRS 2017, once you add the SCOM Report Server role to it, the Reports page only gives a 500 error. Reports work in the console, but can no longer get to the web interface.

104 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Ben Meis shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

12 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Mick commented  ·   ·  Flag as inappropriate

    Same problem too.

    Unsure, but possibly started with latest SQL patches? Can't confirm.

  • Mario commented  ·   ·  Flag as inappropriate

    This is very annoying. We can not move to SCOm 2019 at the Moment, because Reporting is not working. After installation of SCOM Reporting Role, SRRS stops working (http500 Error)

  • Christo Steenkamp commented  ·   ·  Flag as inappropriate

    I am having the exact same issue with my SCOM 2019 Upgrade on SQL SSRS 2017... SSRS works fine until the SCOM Integration - tried a re-install, exact same issue. Before the SCOM Integration, the Web URL for Reports work fine, after just getting the Error 500 issue. The ReportServer Link still works, but not the web interface for the actual reports.

  • Owen Eagers commented  ·   ·  Flag as inappropriate

    I can't move forward with this at the moment as I need to add in custom Audit reports! Very annoying!

  • Henry commented  ·   ·  Flag as inappropriate

    This problem is not only annoying, but also seriously limited the ability to design customized SCOM reporting using Reporting Service Portal. This issue should be fixed as soon as possible.

  • Alexey Semibratov commented  ·   ·  Flag as inappropriate

    From C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSPortal_ ### .log

    RSPortal!reportserverwebapp!RSPortal.exe!3!04/18/2019-11:51:08:: e ERROR: A\alex fe80::c9da:aa65:9c19:5f10%6: GET - 0:00:00.0220485
    Exception: Microsoft.BIServer.Owin.Common.Exceptions.AuthenticationExtensionException: GetUserInfo ---> System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.<>c__DisplayClass1.<GetUserInfo>b__0()
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    --- End of inner exception stack trace ---
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.CreatePortalIdentity(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.Invoke(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() | RequestID = s_be4e2c81-4441-49cc-8e5d-c219bc5ce608
    RSPortal!reportserverwebapp!RSPortal.exe!21!04/18/2019-11:54:37:: i INFO: Received request GET | RequestID = s_366dc647-d85e-4e42-a625-70bb1bbe2327
    RSPortal!reportserverwebapp!RSPortal.exe!21!04/18/2019-11:54:37:: e ERROR: A\alex fe80::c9da:aa65:9c19:5f10%6: GET - 0:00:00.0029722
    Exception: Microsoft.BIServer.Owin.Common.Exceptions.AuthenticationExtensionException: GetUserInfo ---> System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.<>c__DisplayClass1.<GetUserInfo>b__0()
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    --- End of inner exception stack trace ---
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.CreatePortalIdentity(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.Invoke(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() | RequestID = s_366dc647-d85e-4e42-a625-70bb1bbe2327
    RSPortal!reportserverwebapp!RSPortal.exe!21!04/18/2019-11:54:40:: i INFO: Received request GET | RequestID = s_8ac7dbf1-a12a-4669-929d-3871ff28f4d9
    RSPortal!reportserverwebapp!RSPortal.exe!21!04/18/2019-11:54:40:: e ERROR: A\alex fe80::c9da:aa65:9c19:5f10%6: GET - 0:00:00.0025433
    Exception: Microsoft.BIServer.Owin.Common.Exceptions.AuthenticationExtensionException: GetUserInfo ---> System.NullReferenceException: Object reference not set to an instance of an object.
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.<>c__DisplayClass1.<GetUserInfo>b__0()
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    --- End of inner exception stack trace ---
    at Microsoft.BIServer.Owin.Common.Services.AuthenticationService.WrapExtensionCall[T](String methodName, Func`1 func)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.CreatePortalIdentity(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.CustomAuthenticationMiddleware.Invoke(IOwinContext context)
    at Microsoft.BIServer.Owin.Common.Middleware.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() | RequestID = s_8ac7dbf1-a12a-4669-929d-3871ff28f4d9

Feedback and Knowledge Base