Magento 2 Upgrade Error SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘magento2.email_abandoned_cart’ doesn’t exist.

When you upgrade Magento version 2.2.2 to 2.3.3, once upgrade is finish and you are trying to run the setup upgrade command, You faced the error at a time of upgrade command,

Upgrading schema.. SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘mage222ce.email_abandoned_cart’ doesn’t exist, query was: DESCRIBE `email_abandoned_cart`

Without Resolved above error, You can’t able to access your front or backend panel.

The cause of the error is that, When you have installed Magento 2.2.2 Version, the Dotdigitalgroup_Email extension version was 2.3.8 and in the latest version of Magento 2.3.3, Dotdigitalgroup module version is 3.3.0.

Version conflict the upgrade error when you run command,
php bin/magento setup:upgrade

First Approach:
1) If you haven’t use Dotdigitalgroup module, just disable it from the config.php file with, ‘Dotdigitalgroup_Email’ => 0 and ‘Dotdigitalgroup_Chat’ => 0

Second Approach:
2) You can manually upgrade the database table, setup_module
with a record, Dotdigitalgroup_Email change schema_version and data_version to 3.3.0 Or run SQL query to upgrade entry.

You can check the latest version of the Dotdigitalgroup_Email from the vendor/dotmailer/dotmailer-magento2-extension/etc/module.xml

Get The setup_version name from the XML file, <module name=”Dotdigitalgroup_Email” setup_version=”3.3.0″>

Use setup_version and replace it with setup_module table entry.