IBM Support

Error in SQL statement for all reports in Guardium GUI

Troubleshooting


Problem

All predefined and custom reports in the Guardium GUI have a long delay when selecting them. After the delay you see the same error on every page: Error in generating report/monitor: Error in sql statement. There are a lot of interactive reports in the Running Query Monitor.

Symptom

  • On all reports in the GUI, some time clicking you get the error:
  • In the GUI->Guardium Monitor-> Running Query Monitor you see many interactive reports running. Note the difference between interactive reports and Audit processes, both of which appear in the monitor.
      Example of interactive report:

      Example of audit process:

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Guardium Database Activity Monitor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"8.2;9.0;9.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
16 June 2018

UID

swg21687003