Magento 2.3 to 2.3.6 - help - urgent

Question

I just updated my Magento instalation from 2.3.3 to 2.3.6.

PHP version 7.3

Everything seamed to fine except when I do reindex. I get this error:

PHP Fatal error:  Uncaught Error: Cannot instantiate interface Magento\InventoryCatalogApi\Model\GetProductTypesBySkusInterface in /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121
Stack trace:
#0 /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/Compiled.php(108): Magento\Framework\ObjectManager\Factory\AbstractFactory->createObject('Magento\\Invento...', Array)
#1 /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/Compiled.php(150): Magento\Framework\ObjectManager\Factory\Compiled->create('Magento\\Invento...')
#2 /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/Compiled.php(79): Magento\Framework\ObjectManager\Factory\Compiled->get('Magento\\Invento...')
#3 /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/Compiled.php(150): Magento\Framework\ObjectManager\Factory\Compiled-> in /chroot/home/a96f0e0b/stores.etailhandel.no/html/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php on line 121

Do anyone know what this means? And can anyone help me please.

Answer 1

-> if error in indexing after upgrade then run below sql query in phpmyadmin

CREATE
SQL SECURITY INVOKER
VIEW `inventory_stock_1`
AS
SELECT
DISTINCT
legacy_stock_status.product_id,
legacy_stock_status.website_id,
legacy_stock_status.stock_id,
legacy_stock_status.qty quantity,
legacy_stock_status.stock_status is_salable,
product.sku
FROM `cataloginventory_stock_status` `legacy_stock_status`
INNER JOIN `catalog_product_entity` product
ON legacy_stock_status.product_id = product.entity_id;

and run below commands

• Clear var/generation
• Clear var/cache
• Enable Magento modules: bin/magento module:enable --all
• Compile DI bin/magento setup:di:compile

hope this helps you:)

Answer 2

Thank you all for all the help I got from you guys,

@Gohil Rajesh, your script worked but was also an issue with a module that also caused the problem. Disabled that and all indexes are now working.

Thanks, everyone!!