KBI 311868 Issue Addressed: SQL Query Rules Fail To Get Processed When Saved From Argent Global Manager
Version
Argent Global Manager 5.1A-R12 and below
Date
Tuesday, 22 September 2020
Summary
SQL Query Rules fail to get processed when saved from Argent Global Manager
Technical Background
This is a coding issue in Argent Global Manager
The issue happens when SQL query with the tab character is saved from Argent Global Manager
The tab character affects the parsing of data from database and hence Argent AT and Argent Global Manager fails to display the part of the SQL query following the tab character
The original SQL Query (with the tab character) is given below:
SELECT cpu,physical_io,spid,getdate() as tme
FROM sysprocesses
WHERE spid <>@@spid
The issue has been addressed in Argent Global Manager 5.1A-R13
Resolution
Upgrade to Argent Global Manager 5.1A-R13 or above