ssmssql-server-2016ssms-16

#Errors in SSMS built-in reports

From my local computer I am using SQL Server 2016 Management Studio client (SSMS) to connect to a SQL Server installed on a remote computer. I connect using Windows Authentication method.

My SQL Server Management Studio 2016 installed in my local computer shows below versions installed:

Microsoft SQL Server Management Studio                      13.0.16100.1
Herramientas cliente de Microsoft Analysis Services         13.0.1700.441
Microsoft Data Access Components (MDAC)                     10.0.17763.1
Microsoft MSXML                                             3.0 4.0 5.0 6.0 
Microsoft Internet Explorer                                 9.11.17763.0
Microsoft .NET Framework                                    4.0.30319.42000
Sistema operativo                                           6.3.17763

SQL Server version installed on remote computer is as below:

enter image description here

When I build reports I get a lot of "#Error" printed on it. As an example, to build a report about all blocked transactions I go to Server node -> Reports -> Standard Reports -> Activity – All Blocked Transactions. It shows "#Error", see below screenshot (in this screenshot there are no blocking transactions):

enter image description here

Solution

  • It seems it is caused by an out-of-memory exception. Restarting SSMS corrected the problem. After restarting SSMS, built-in reports are correctly generated, no more #Errors are shown.

    I found this solution here.