Magento 1.9 : Category Flat Data index error

When reindexing "Category Flat Data " gives error Cannot initialize the indexer process.

I run the below query and the issue resolved.

ALTER TABLE catalog_category_entity ENGINE=INNODB;

ALTER TABLE core_store ENGINE=INNODB;