SSRS - Object reference not set to an instance of an object

Question

SSRS - Object reference not set to an instance of an object

SQLSACT

SSC-Insane

Points: 21838
More actions
March 9, 2021 at 11:14 am

#3855430
Hi All
SQL Server version: 2016 SP2 CU13
I have one particular report that keeps giving me the error below....All other reports work just fine.
```
An unexpected error occurred in Report Processing. (rsInternalError)
 Object reference not set to an instance of an object.
```
According to the Execution log, the report ran last a month ago and as far as I know, nothing in the environment has changed.
The Reporting Services log shows the same error.
Uploading the same report to a different instance (SQL 2017) produces no issues.

Has anyone seen this before?
Where do I start looking?

Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

Is there anything obviously different about this report, when compared with other reports which are working OK?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

SQLSACT SSC-Insane Points: 21838 More actions · Answer 2

Thanks

I had a look at the XML of the problematic report and I cannot see anything obvious. My knowledge of developing reports is very limited though.

I took the ReportServer & ReportServerTempDB databases and plugged them into another reporting server of the same version and the report worked there.

I ran a trace on the problematic server and it seems that the report isn't even hitting the ReportServer database so based on that, I'm guessing the problem is specific to that report server.