16

After I've upgraded my Magento to EE 1.14.2.0 the cron enterprise_refresh_index always gets this error:

exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'catalog_product_entity_tmp_indexer' doesn't exist' in /var/www/public_html/lib/Zend/Db/Statement/Pdo.php:228

I don't get why this table doesn't exist. Shouldn't Magento create it in the process of the refresh index?

4
  • 1
    If you've got EE I believe you'll get support?
    – Richard
    Aug 6, 2015 at 15:39
  • Yes, I could try it that way.
    – Joke Puts
    Aug 7, 2015 at 8:12
  • 1
    @Richard which shows you never used EE support.
    – user487772
    Jun 24, 2016 at 8:04
  • @TimBezhashvyly Hi Tim, no, I've never used EE either though
    – Richard
    Jun 24, 2016 at 8:27

5 Answers 5

5

There's a Magento patch SUPEE-5984, which addresses these kind of Enterprise Refresh Index problems.

3
5

We encountered this error after a database restart in production and after a first reindex on a local development environment, running EE 1.14.2.3.

What worked for us was the following:

  1. Disable the flat product catalog
  2. Observe that the indexer runs successfully
  3. Enable the flat product catalog
  4. Observe that the indexer runs successfully
2
  • 1
    I tested this workaround and it appeared to work for me, allowing the enterprise_refresh_index job to complete successfully
    – mttjohnson
    Feb 10, 2016 at 17:56
  • Works for me too.
    – df2k2
    Nov 17, 2016 at 23:03
4

I can't comment yet on the existing comments/answers, but I can confirm that SUPEE-5984 appears to resolve the issue, at least for our client who encountered this issue (they have over a million products, so it still hasn't finished running, but it IS running now... ). We opened a ticket with Magento through our client's support contract with them and Magento got us the patch in less than an hour.

2
  • 1
    Caution, if you updated to 1.14.2.3 after patching, you have to apply the patch again because it is not included in the latest release Jan 25, 2016 at 10:30
  • For the record, in 1.14.3 the issue seems to be fixed in a different way and the patch is not needed anymore Jul 13, 2017 at 13:35
4

For future reference: The error doesn't occur when I revert the file app/code/core/Enterprise/Catalog/Model/Index/Action/Product/Flat/Refresh.php to our previous version 1.14.0.1.
The new parameter $resetFlag in the function _reindex seems to cause the problem.

9
  • "Awesome", just ran into the same issue. Will try if that solves also our problem. Aug 10, 2015 at 15:13
  • I can confirm that reverting the file solves the error. Did an update from 1.14.0.1 to 1.14.2.0 and just created a patch file with the modified content of Refresh.php. Next: contacting EE support. Aug 10, 2015 at 15:38
  • @AnnaVölkl did they provide you any update on this?
    – Sergei Guk
    Aug 18, 2015 at 14:26
  • 2
    @Sergei Guk: So far I did only reset the file and did not ask for official support or patch. An Update to 1.14.2.1 (maybe solved there?) is in the queue. Need to investigate further when there is time to. Aug 18, 2015 at 14:28
  • 1
    An update to 1.14.2.1 does not fix this. The Magento support has a patch for it but I still have to test it.
    – Joke Puts
    Aug 19, 2015 at 19:51
1

I had the same problem with Magento EE 1.14.2.3, but the above solutions didn't work for me. I found out the problem was in Enterprise_Catalog_Helper_Product::getFlatColumns. I solved it by changing the line

if ($columns !== null) {

to

if ($columns !== null && $columns !== false) {

Of course: don't edit the core file directly, but do a rewrite.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.