SCSM The report server cannot process the report or shared dataset

less than 1 minute read

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

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:

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:

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

Thanks,

Alexandre Verkinderen

Share on

Twitter Facebook LinkedIn

Create an Automatic Service Principal Azure RM Service Connection in Azure DevOps via Azure CLI

3 minute read

With more and more of our development and infrastructure projects being built and released via Azure DevOps, I find myself creating a few DevOps projects whi...

The curious case of an Azure Application Gateway showing no metrics and logs

1 minute read

This is the curious case of an Azure Application Gateway showing no metrics and logs at all. Even thought this was one of the main customer’s production Appl...

Publish the new Azure API Management Service Developer Portal behind an Application Gateway

3 minute read

There are currently 2 developer portals for the Azure API Management service: a legacy portal and the new portal experience. We deployed our Azure APIM insta...

Setting an Azure AD group to Azure SQL Database with ARM templates

2 minute read

I was recently looking at a way to automatically set an Azure AD group as the SQL admin for our Azure SQL databases with ARM tempplates. We use SQL authentic...