Troubleshooting
Problem
You receive an error similar to "SQL error" or "Error in SQL" when trying to see the Aggregation/Archive Log report on IBM InfoSphere Guardium GUI web Interface. Scheduled Job Exceptions Report shows an error like the following: [timestamp] Guard Report Generator Error: Table 'AGGREGATOR_ACTIVITY_LOG' is marked as crashed and should be repaired
Symptom
- You can not see the Aggregation/Archive Log report in the GUI. v9 Guardium Monitor -> Aggregation/Archive Log. v10 Reports -> Guardium Operational Reports -> Aggregation/Archive Log.
- An error is observed. Error "Guard Report Generator Error: Table 'AGGREGATOR_ACTIVITY_LOG' is marked as crashed and should be repaired" is reported in the Scheduled Job Exceptions Report.
[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.0;10.0.1;8.0;8.0.1;8.1;8.2;9.0;9.1;9.5","Edition":"All Editions","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
swg21619455