Editing user-defined application yields an 'Unknown Column' error

Products

• CA Application Delivery Analysis (NetQoS / ADA)

Issue/Introduction

When attempting to save an edited a user-defined application, the following error message is returned:

Unknown column 'Y' in 'field list'

The changes are not successfully saved when this is observed.

Environment

ADA 11.2+

Cause

Defect in ADA 11.2 that leaves out the single quotes needed in the update queries.

Resolution

Development has identified the queries that need to be edited.  They will be releasing an update with a permanent fix in place.  The ETA is not yet available.  They have provided a workaround.

Workaround:

1. Locate the latest w3wp_Query_<Date>.log file in the <InstallDirectory>/Super/logs folder
   
   
2. Open this file and search for the latest occurrence of the following string:
   a.UserModified = Y
   
   
3. This line will contain a sql update statement similar to the following:
   UPDATE applications AS a  SET a.inactive=0, a.port_list = '<ApplicationPort#>', a.client_side = 0, a.master_app_id = 0, a.special_type = 0, a.flags = 1, a.url = NULL, a.applications_desc = CASE a.segment_type WHEN 1 THEN CONCAT('<ApplicationName>', ' [Client]') WHEN 2 THEN CONCAT('<ApplicationName>', ' [WAN]') WHEN 3 THEN CONCAT('<ApplicationName>', ' [Server]') ELSE '<ApplicationName>' END, a.virtual_host = null, a.UserModified = Y WHERE a.app_id = 29844 OR a.segment_parent_id = 29844;
4. Copy out this sql update statement and add the single quotes around the Y as follows: 
   UPDATE applications AS a  SET a.inactive=0, a.port_list = '<ApplicationPort#>', a.client_side = 0, a.master_app_id = 0, a.special_type = 0, a.flags = 1, a.url = NULL, a.applications_desc = CASE a.segment_type WHEN 1 THEN CONCAT('<ApplicationName>', ' [Client]') WHEN 2 THEN CONCAT('<ApplicationName>', ' [WAN]') WHEN 3 THEN CONCAT('<ApplicationName>', ' [Server]') ELSE '<ApplicationName>' END, a.virtual_host = null, a.UserModified = 'Y' WHERE a.app_id = 29844 OR a.segment_parent_id = 29844;
5. Log into MySQL and execute this edited statement.  One row should be affected.  After completing this statement, the application can be viewed in the ADA GUI and the edit will be completed.