MSI(inventory_stock_sales_channel,inventory_source_item) tables does not exist error after enabling MSI module

by |Published June 21, 2022

I am trying to enable the MSI module after being disabled for a lot of months. got a lot of MSI tables missing errors while setup upgrade and reindex
like SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mainDB.inventory_source_item’ doesn’t exist

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mainDB.inventory_stock_sales_channel’ doesn’t exist

The current Magento version is 2.4.3p1 EE