SCSM The report server cannot process the report or shared dataset

7:33 am in SytemCenter by alkin

 

I encountered the following issue while trying to run a report from the Service Manager console:

scsm

This was a total new installation (done by the Power Depoloyment Toolkit) and everything was installed fine without any errors so I doubled check my SQL, my datawarehouse server, my SQL reporting Service and by digging deeper and deeper into the reports themself on the SQL report I discovered the following error:

 

image

So that was the culprit!  To solve this issue, open the configuration of each report, go to data sources and select the DWDataMart Data source:

image

 

click OK and now you will be able to run reports again!

 

Thanks,

Alexandre Verkinderen