KBI 311860 Argent Reports Fails To Generate Data In Alerts-Type Report When Using Recipients Column
Version
Argent Reports 7.0A 2004-A or below
Date
Thursday, 20 August 2020
Summary
Alerts-type report in Argent Reports fails to generate data when adding the built-in column ‘Recipients’ to the report definition
The report works fine without the ‘Recipients’ column
The log contains lines like the following:
18 Aug 2020 19:55:07.672 DND-SUPPORT Triv ::1 Connecting to AT DB
18 Aug 2020 19:55:07.673 DND-SUPPORT Triv ::1 AT DB……………….. ‘Re-using’
18 Aug 2020 19:55:07.677 DND-SUPPORT Triv ::1 *** ERROR *** Failed to execute SQL query
18 Aug 2020 19:55:07.678 DND-SUPPORT Triv ::1 *** ERROR *** [Microsoft][ODBC SQL Server Driver][SQL Server]The data types ntext and varchar are incompatible in the add operator.
18 Aug 2020 19:55:07.679 DND-SUPPORT Triv ::1 *** ERROR *** Microsoft Error Code -2147217900
18 Aug 2020 19:55:07.679 DND-SUPPORT Triv ::1 *** ERROR *** SQL Query……………. ‘
Technical Background
This is a coding error due to an ill-formed SQL query
The issue will be addressed in the next version of Argent Reports
Resolution
N/A