000022420 - Error: 'An error occurred while compiling the query' in RSA Authentication Manager or ACE/Server

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000022420
Applies ToRSA ACE/Server 5.2.1
RSA Authentication Manager 6.0.2
Microsoft Windows Server 2003
Microsoft Windows 2000 Advanced Server SP4
  Sun Solaris 2.8
  Sun Solaris 2.9
IBM AIX 5.1
HP-UX 11.11
HP_UX 11i
IssueError: "An error occurred while compiling the query" in RSA Authentication Manager or ACE/Server
CauseThis error may be displayed when creating a Custom Query in RSA Authentication Manager or ACE/Server even after a syntax check returns a Syntax is correct message. An example of a query that generates this error is as follows:

    SELECT chClientName, MAX(dtGMTDate) FROM SDLogEntry GROUP BY chClientName

The problem has been identified with an internal procedure which was responsible for MIN() and MAX() statements.
ResolutionThis issue has been resolved in a series of patches for all supported version of RSA Authentication Manager and ACE/Server, and hot fixes can be obtained from RSA Security for the appropriate version for both Windows and UNIX:

RSA ACE/Server 5.2.1                                   patch ID B020872
RSA Authentication Manager 6.0.2                patch ID B020746
Legacy Article IDa28452

Attachments

    Outcomes