Overview:
The error "Can not drop the index 'Store_Manufacturer.ManufacturerID'" typically arises during an attempt to update Webgility Desktop (WD). This issue often occurs when logging in after an update, as the database update process fails to complete properly. To resolve this error, you need to run the DBUtility and DBUpgrade tools. These tools help optimize the Webgility database, resolve errors, and improve performance.
Steps to resolve the issue:
01. Run DBUtility
The DBUtility is used to optimize and shrink the Webgility database when its size increases or when performance issues or database-related errors occur. Follow these steps to run the DBUtility and resolve the error:
Steps:
1. Close Webgility Software and Scheduler:
Close all Webgility Software and Scheduler instances running on any computers where Webgility is installed.
Use Task Manager to kill any related processes that may still be running in the background.
2. Locate the UnifyDBUtility File:
On the primary Webgility machine (where the database is installed), navigate to:
C:\Webgility\UnifyEnterpriseFind the file named "UnifyDBUtility."
3. Run the UnifyDBUtility Tool:
Open UnifyDBUtility and follow the prompts to execute the utility.
Confirm that all instances of Webgility Software and Scheduler are closed, then click OK.
The tool will prompt you to perform a backup. Click OK and select a valid backup location (usually in the Webgility application folder).
4. Optimize the Database:
Once the backup process is complete, the optimization will begin. Do not stop the process or restart the computer during this phase.
Wait until the optimization is finished.
5. Verify Success:
After receiving the success notification, close the DBUtility and log back into Webgility. Check to ensure the performance issue or error has been resolved.
02: Run UnifyDBUpgrade
The UnifyDBUpgrade tool reindexes and optimizes the Webgility database and is typically used when Webgility returns an error or when a database upgrade is needed.
Steps:
1. Close Webgility Software and Scheduler:
Close all instances of Webgility Software and Scheduler on every machine where Webgility is installed.
Use Task Manager to kill any related processes.
2. Locate the UnifyDBUpgrade File:
On the primary Webgility machine, go to:
C:\Webgility\UnifyEnterpriseLook for the file named "UnifyDBUpgrade."
3. Run the UnifyDBUpgrade Tool:
Open UnifyDBUpgrade and wait for the process to complete.
Once you receive the success notification, close the tool and log back into Webgility.
Need More Help?
If you're still experiencing issues or need further assistance, feel free to reach out to Webgility Support via chat, email, or phone. Our team is here to help!