Forum Discussion
DGMalcolm
Aug 29, 2022Iron Contributor
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...
Yannick__
Oct 13, 2022Copper Contributor
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.
DGMalcolm
Oct 13, 2022Iron Contributor
I've run the queries included in the report and they work. But I can't run the report even from Report Builder.
- Yannick__Oct 13, 2022Copper ContributorThat'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.