SSRS Error: Object reference not set to an instance of an object

Question

Hi Guys
I'm stablishing SQL Server 2019 with SSRS, I'm new in this.
As I installed report server, I opened the Report Server Configuration Manager, and I applied the default setting which seemed ok. The SQL Server Reporting Services is up and running now, but when I try to Browse into the Web Services URL, I get this Error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError).
Object reference not set to an instance of an object.

As I recall the previous editions of SQL server, there was no need for further configuration. and with the report server installation within the SQL server installation itself, it was ready to go. But not It's not working.

Any help would be appreciated.

Answer 1

Hi again
Fortunately, I found the problem. Apparently in SQL Server 2017 and 2019 which SQL Server setup and report server setup are separated, I should have created a database in Report Server Configuration Manager manually, because It would not be created automatically anymore. After configuring the appropriate database, Now there is no issue with the report server.

Answer 2

RSPortal!reportserverwebapp!RSPortal.exe!9!01/20/2024-04:55:24:: e ERROR: OData exception occurred: System.NullReferenceException: Object reference not set to an instance of an object.    at Microsoft.ReportingServices.Portal.Services.ServicesUtil.CreateRsService(IPrincipal principal)    at Microsoft.ReportingServices.Portal.Services.SystemResources.SystemResourceService.InternalGetSystemResourceByTypeName(IPrincipal userPrincipal, String typeName)    at Microsoft.ReportingServices.Portal.Services.SystemResources.SystemResourceService.TryGetPayload(IPrincipal userPrincipal, String typeName, String itemName, String& contentType, String& filename, Byte[]& bytes)    at Microsoft.ReportingServices.Portal.ODataWebApi.V1.Controllers.UnboundFunctionController.SafeGetSystemResourceContent(String type, String key)    at lambda_method(Closure , Object , Object[] )    at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)    at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown ---    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)    at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext(). 
   at Microsoft.ReportingServices.Portal.Services.ServicesUtil.CreateRsService(IPrincipal principal)

I am getting the above Exception, when trying to use the Anonymous authentication, but when I use the windows authentication I am able to see the portal, but this specific use case we wanted anonymous authentication, and Idea how can I resolve this issue?

Also, in my web.config file I have below code for Microsoft Analysis Services but the path present in the codebase href is not present on the Windows Server where I am deploying the SSRS.

I wanted to know is there any connection between the exception that I am getting above and the below missing path.

Also when I am accessing the ReportServer , that is working fine, I am able to generate the report, only when I try to access the Portal I am getting the above exception in the Logfiles.

      <dependentAssembly>
        <assemblyIdentity name="msmgdsrv" publicKeyToken="89845dcd8080cc91" />
        <bindingRedirect oldVersion="9.0.0.0-14.0.0.0" newVersion="14.0.0.0" />
        <codeBase version="14.0.0.0" href="%ProgramFiles%\Microsoft Analysis Services\AS OLEDB\140\msmgdsrv.dll" />

Answer 3

Hi @MiladHooshyari ,
Glad to hear that you have resolved the issue.
The report server database provides storage for one or more report server instances. Because the report server database schema can change with each new release of Reporting Services, it is required that the database version match the version of the report server instance you are using. In most cases, a report server database can be upgraded automatically with no specific action on your part.
If you have any questions, please feel free to let me know.
Regards,
Joy