sqlwatch icon indicating copy to clipboard operation
sqlwatch copied to clipboard

Published 20 hours ago • verified publisher icon marcingminski

Report Contains No Data

Open charles-candale-myob opened this issue 2 years ago • 0 comments

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 <X64> (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.

charles-candale-myob avatar Sep 27 '21 03:09 charles-candale-myob