I’m getting this errorafter finishing all the migration steps successfully.
“One or more indexers are invalid. Make sure your Magento cron job is running.”
I tried to reindex it using the SSH but no luck. I also asked the hosting company to help me and they checked the operation of the cron job and it’s working properly except the product price indexer?
The hosting company suggested that the migration might corrupt something in the database because it shows this
“Catalog Product Rule index has been rebuilt successfully in 00:00:00
No linked stock found”
after running this command php bin/magento indexer:reindex
would you please look into this issue and let me know if you can help me resolve it.
Thank you in advance.
11 answers
Hi there,
“Catalog Product Rule index has been rebuilt successfully in 00:00:00
No linked stock found”
That is strange. Lets try reset the catalog rule indexer and reindex the data on it once more:
php -f bin/magento indexer:reset catalogrule_rule
php -f bin/magento indexer:reindex catalogrule_rule
In case the issue still persists, lets provide me information about your instance:
+ Admin credentials and URL to back-end
+ SSH credentials and path to M2 folder
I will help to check further and get back you then.
Regards,
Mall.
Hi there,
I couldn’t access to M2 instance with the URL you provided. I got this: http://i.prntscr.com/djQObcP9RlSsmCpurJXGSA.png
Meanwhile, I couldn’t open a SSH connection to your server too: http://i.prntscr.com/2dL0bxrXRUCOUItHz0YwyA.png
Please help to check again.
Regards,
Mall.
[mtwotest@sip4-1134 html]$ php -f bin/magento indexer:reset catalogrule_rule
Catalog Rule Product indexer has been invalidated.
[mtwotest@sip4-1134 html]$ php -f bin/magento indexer:reindex catalogrule_rule
Catalog Rule Product index has been rebuilt successfully in 00:00:00
No linked stock found
Catalog Search index has been rebuilt successfully in 00:00:00
[mtwotest@sip4-1134 html]$ php bin/magento indexer:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:01
Category Products index has been rebuilt successfully in 00:00:00
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Product EAV index has been rebuilt successfully in 00:00:01
Stock index has been rebuilt successfully in 00:00:00
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
No linked stock found
Catalog Search index has been rebuilt successfully in 00:00:00
[mtwotest@sip4-1134 html]$ php bin/magento indexer:status
+———————-+——————+———--+———————+———————+
| Title | Status | Update On | Schedule Status | Schedule Updated |
+———————-+——————+———--+———————+———————+
| Catalog Product Rule | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:05 |
| Catalog Rule Product | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:32 |
| Catalog Search | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:35 |
| Category Products | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:32 |
| Customer Grid | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:31 |
| Design Config Grid | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:30 |
| Inventory | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:34 |
| Product Categories | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:05 |
| Product EAV | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:34 |
| Product Price | Reindex required | Schedule | idle (0 in backlog) | 2018-12-12 13:55:34 |
| Stock | Ready | Schedule | idle (0 in backlog) | 2018-12-12 13:55:34 |
+———————-+——————+———--+———————+———————+
Hi there,
| Product Price | Reindex required | Schedule | idle (0 in backlog) | 2018-12-12 13:55:34 |
Let’s try reindex the Product Price indexer by run below CLI commands:
php -f bin/magento indexer:reset catalog_product_price
php -f bin/magento indexer:reindex catalog_product_price
And tell me know how it goes then.
Regards,
Mall.
[mtwotest@sip4-1134 html]$ php -f bin/magento indexer:reset catalog_product_price
Product Price indexer has been invalidated.
[mtwotest@sip4-1134 html]$ php -f bin/magento indexer:reindex catalog_product_price
No linked stock found
Catalog Search index has been rebuilt successfully in 00:00:00
[mtwotest@sip4-1134 html]$ php -f bin/magento index:reindex
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:00:01
Category Products index has been rebuilt successfully in 00:00:01
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:00
Product EAV index has been rebuilt successfully in 00:00:01
Stock index has been rebuilt successfully in 00:00:00
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
No linked stock found
Catalog Search index has been rebuilt successfully in 00:00:00
[mtwotest@sip4-1134 html]$ php -f bin/magento index:status
+———————-+——————+———--+———————+———————+
| Title | Status | Update On | Schedule Status | Schedule Updated |
+———————-+——————+———--+———————+———————+
| Catalog Product Rule | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Catalog Rule Product | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Catalog Search | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Category Products | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Customer Grid | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Design Config Grid | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Inventory | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Product Categories | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Product EAV | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Product Price | Reindex required | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
| Stock | Ready | Schedule | idle (0 in backlog) | 2018-12-12 14:21:04 |
+———————-+——————+———--+———————+———————+
[mtwotest@sip4-1134 html]$
Hi there,
If you want I can whitelist your IP if you send it to me.
Please whitelist for our office IPs below:
113.190.252.133
118.70.176.221
113.190.254.239
I will help to check further and get back you then.
Regards,
Mall.
I whitelisted all of the IP’s above.
Hi Aswan Alhamdani,
We’ve just checked and notice that you’re using UB Data Migration Pro 3.1.5 which is not compatible with the Magento 2.3.0 that you’re using.
We’ve sent you an email regarding your subscription renewal, please check and follow up further with us there.
Regards,
Ubertheme team
