Forum Discussion
SCOM 2019 Reporting Error - "Cannot execute report"
Running SCOM 2019 with UR4 on a single DB server with 2 management servers. A bit baffled - I have a logical disk space report that has been running in my SCOM environment since SCOM 2016 and I'v...
- Hi, the error "Object reference not set to an instance of an object" typically can mean that the object e.g. a Server that is selected for the report to show does not exist anymore in the SCOM databases. I would suggest to load the report in SSRS Report Builder or Visual Studio and validate and verify its configuration and functionality.
- I've run the queries included in the report and they work. But I can't run the report even from Report Builder.
- That's strange, I would suggest to validate all parameters of the report. In case the query contains report parameters I would try to replace for testing the report builder query with the query which is working outside of report builder. I can only imagine some minor issue in the report specific parameters or mapping of these values into the query, I do realize that the report itself was not changed and suddenly stopped working, but for such issues step by step troubleshooting is the only way. You can also try to create a new report in report builder with the working query to further pinpoint the root cause.
