Troubleshooting
Problem
Data Archive and Data Export jobs fails with following error in "Aggregation/Archive Debug Log" report.
ERROR - Cannot create AGG_EXPORT_TMP_DB database "call AGG_POST_EXPORT - FAILED. AGG_EXPORT_TMP_DB.GDM_CONSTRUCT_INSTANCE repair Error File './AGG_EXPORT_TMP_DB/GDM_CONSTRUCT_INSTANCE.MYD' not found (Errcode: 2 - No such file or directory)"
Cause
AGG_EXPORT_TMP_DB is a temporary database created each time the "data export" job runs. If the old temp DB exists, it is dropped and recreated.
Sometimes this temp database is not dropped because of table level corruption and data export job fails to create new temp db and logs the error "ERROR - Cannot create AGG_EXPORT_TMP_DB database" in "Aggregation/Archive Debug Log" report.
Resolving The Problem
The temp database needs to be dropped manually by using root.
You have to engage support team in usual manner by referring this tech note and upload "support must_gather agg_issue" logs over the case.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0JAAS","label":"APPLIANCE"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
15 September 2020
UID
ibm16257971