I have a report in sqlwatch which when executed as part of a check alert says in the email "Report Id: 54 contains no data." but when I run the query associated with the report I get data.
I expected the email to contain the data that is produced in SSMS when I run the query behind the report.
OS Version: Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)
SQL Version and Edition: Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit)
SQL Server Management Studio (SSMS -> about -> copy info):
SQL Server Management Studio 15.0.18384.0
SQL Server Management Objects (SMO) 16.100.46367.54
Microsoft Analysis Services Client Tools 15.0.19535.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.14393
SQLWATCH version (from DACPAC or from sysinstances)
2.6
Hi there.
I have a report in sqlwatch which when executed as part of a check alert says in the email "Report Id: 54 contains no data." but when I run the query associated with the report I get data.
It is not mentioned at https://docs.sqlwatch.io/known-issues/.
I expected the email to contain the data that is produced in SSMS when I run the query behind the report.
OS Version: Windows Server 2016 Datacenter 10.0 (Build 14393: ) (Hypervisor)
SQL Version and Edition: Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64) Nov 30 2018 12:57:58 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit)
SQL Server Management Studio (SSMS -> about -> copy info): SQL Server Management Studio 15.0.18384.0 SQL Server Management Objects (SMO) 16.100.46367.54 Microsoft Analysis Services Client Tools 15.0.19535.0 Microsoft Data Access Components (MDAC) 10.0.14393.0 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.14393
SQLWATCH version (from DACPAC or from sysinstances) 2.6
Thanks.
Charles.