IBM Support

How to troubleshoot Guardium aggregation or archive errors

Question & Answer


Question

What do I do if I see failures in the Aggregation/Archive log? What do I do if I get Aggregation/Archive Error Alerts? What details should I collect before engaging Guardium support about Aggregation/Archive problems?

Cause

The Aggregation/Archive log is found under Guardium Monitor in v9 and Reports -> Guardium Operational Reports in v10. It contains information about several processes that can be configured to run on Guardium appliances, including archive, export, purge, import, merge, backup and restore.

There can be many causes for errors in these processes. Use this technote as a guide for how to troubleshoot. You should collect the information outlined below before contacting technical support.

Answer

1. Basics
1.1 What unit type is reporting a problem?

  • Different processes run on aggregators and collectors. Check in the top right corner of the GUI for your unit type. For example:
        v9 v10

1.2 What process is reporting a problem?
  • Check the "Activity Type" column in Aggregation/Archive log. What activity types have status "Failed"?
  • What is the exact error message?

1.3 When did the problem start?
  • Typically the processes in this report are configured to run on a schedule. When was the first time the process failed?

2. Common problems

2.1 Is the Guardium internal database full or close to full?


2.2 Schedule and timing
  • If processes are scheduled close together, temporary increases in process duration can result in overlap and cause problems. Check in the Aggregation/Archive log for the process with the error and the last time it completed successfully. Is there any difference in process durations before the error? If so, increasing the time gap between processes might resolve the problem.
  • If the same process is failing every day when run on a schedule, does running "once now" from the GUI at another time work? If so, increasing the time gap between scheduled processes might resolve the problem.

2.3 Other known issues
3. Must Gather

If you require assistance from technical support for your problem please provide the must gather information listed below.

3.1 For all aggregation problems provide:

  • The file produced when you run CLI: support must_gather agg_issues
  • Details of your investigation from points 1 and 2.
  • Any other relevant information, for example screenshots, steps to reproduce problem.

3.2 For backup or purge errors provide:

  • support must_gather backup_issues (for backup)
  • support must_gather purge_issues (for purge)

3.3 For problems you are able to reproduce when running "once now" provide:

  • support must_gather app_issues
  • Set the debugger to run for a number of minutes and reproduce the problem when the debugger is running.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"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":"10.0;8.2;9.0;9.1","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21698234