Troubleshooting
Problem
Patch p9997 installation fails with a corrupt DATAMART table.
The error typically looks like this:
MYSQL TABLE VALIDATION STARTED....
List of crashed tables:
Database TURBINE: No issue found.
Database GDMS: No issue found.
Database CUSTOM: No issue found.
Database DATAMART . The following tables are corrupted:
A DATAMART TABLE NAME for example: ENTERPRISE_STAP_VERIFICATION_0_13996919
Database DIST_INT: No issue found.
MYSQL TABLE VALIDATION ENDED.
List of crashed tables:
Database TURBINE: No issue found.
Database GDMS: No issue found.
Database CUSTOM: No issue found.
Database DATAMART . The following tables are corrupted:
A DATAMART TABLE NAME for example: ENTERPRISE_STAP_VERIFICATION_0_13996919
Database DIST_INT: No issue found.
MYSQL TABLE VALIDATION ENDED.
Symptom
Health check log has an error like:
MYSQL TABLE VALIDATION STARTED....
List of crashed tables:
Database TURBINE: No issue found.
Database GDMS: No issue found.
Database CUSTOM: No issue found.
Database DATAMART. The following tables are corrupted:
A DATAMART TABLE NAME for example: ENTERPRISE_STAP_VERIFICATION_0_13996919
Database DIST_INT: No issue found.
MYSQL TABLE VALIDATION ENDED.
List of crashed tables:
Database TURBINE: No issue found.
Database GDMS: No issue found.
Database CUSTOM: No issue found.
Database DATAMART. The following tables are corrupted:
A DATAMART TABLE NAME for example: ENTERPRISE_STAP_VERIFICATION_0_13996919
Database DIST_INT: No issue found.
MYSQL TABLE VALIDATION ENDED.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0NAAS","label":"INSTALL UPGRADE MIGRATION"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
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.
Historical Number
TS013606949, TS013306783
Was this topic helpful?
Document Information
Modified date:
27 November 2023
UID
ibm17012677