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.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21687003