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?

Improve this question
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

Reset to default
5

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

Improve this answer
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
Improve this answer
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.

Improve this answer
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
    – Fabian Schmengler
    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
    – Fabian Schmengler
    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.

Improve this answer
9
  • "Awesome", just ran into the same issue. Will try if that solves also our problem.
    – Anna Völkl
    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.
    – Anna Völkl
    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.
    – Anna Völkl
    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.

Improve this answer

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.