How to Resolve Database Memory Errors During Order Download in Webgility Desktop
This article helps Webgility Desktop users resolve database memory errors encountered while downloading orders in Webgility Desktop. It provides a step-by-step process that includes performing software updates, conducting database maintenance, and running system checks to restore smooth and uninterrupted order downloads.
Causes of the Memory Error
-
Outdated Webgility: Older versions of the application or related system files may cause performance issues.
-
Database Limitations: A bloated or outdated database structure can lead to memory errors.
-
Connectivity Issues: Problems with database or network connections can interrupt the download process.
Steps to Resolve the Issue
1. Update Webgility and System Components
-
Open Webgility Desktop.
-
Navigate to Help > Check for Updates.
-
Download and install all available updates.
💡 Tip: Before updating, create a backup by copying the entire
Webgility
folder, typically located atC:\Webgility
. -
Check for pending Windows Updates.
-
Ensure critical components like .NET Framework, SQL Server drivers, or other dependencies are up to date.
2. Upgrade the Webgility Database
-
Go to the installation path:
C:\Webgility\UnifyEnterprise
. -
Run the following tools in order:
-
UnifyDBUtility.exe
-
UnifyDBUpgrade.exe
-
-
Follow on-screen prompts to complete the upgrade.
⚠️ Always back up your database before performing upgrades.
3. Verify All Connections
-
Database Connection
-
Ensure the database server is reachable and credentials are correct.
-
If using a remote database, confirm there are no firewall rules or network issues blocking access.
-
-
Sales Channel Connection
-
Navigate to Connections > Sales Channel > Manage Sales Channels.
-
Click the Edit icon next to the sales channel.
-
Select Connect to Store and complete the authentication.
-
Note
Running UnifyDBUtility
periodically can help shrink the database and maintain optimal performance.