IBM Support

Guardium aggregation error in agg_progress.log "Error - Failed creating Today's tables"

Troubleshooting


Problem

During the midnight processes on a Guardium aggregator the message appears in the agg_progress.log: copy table failed (agg_today) - target table

doesnt exist.

Symptom

Example error from the agg_progress.log:


      * 01/03 00:02:09 --- Creating today's tables - START
     * 01/03 00:02:18 --- copy table failed (agg_today) - target table 'GDMS.MESSAGE__N__20160103__coll123_317289' doesn't exist (1)
     * 01/03 00:02:49 --- Creating today's tables - FAILED ( MESSAGE)
         * 01/03 00:02:49   ~ ERROR: Failed creating Today\'s tables

Later in the day a merge runs successfully with messages in agg_progress.log e.g.

    * 01/03 04:00:40 --- AGG_MERGE Verification                          
     (agg_create_turbine_ref.sh) - DONE                                    
     * 01/03 04:00:43 --- Create REF_DB - already exists, nothing to do    
     * 01/03 04:00:43 --- Creating today's tables - START                  
     * 01/03 04:00:55 --- Mounting new entry                              
     (b54b59bd7fd1d46fe689969191e65698)                                    
     * 01/03 04:00:55 --- Creating today's tables - Already exist

Cause

The initial error creating the table may be due to a performance problem. The table was created, but not in time before the check is run.

Environment

Guardium Aggregator

Diagnosing The Problem

The agg_progress.log can be found in fileserver.

Resolving The Problem

If there has been a successful merge since the error, which includes the line:


    * 01/03 04:00:55 --- Creating today's tables - Already exist

This means the table was created successfully and the error is not a cause for concern.

If there are further errors with the merge, or the same error is coming back each day, see - How to troubleshoot Guardium aggregation or archive errors to proceed.

[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Guardium Central Manager and Aggregator","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;9.5","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]

Document Information

Modified date:
16 June 2018

UID

swg21974491

Page Feedback