Skip to content
  • There are no suggestions because the search field is empty.

How to Fix the “Statement Has Been Terminated” Error When Accessing Quantity Out of Sync in Webgility Desktop (BigCommerce)

This article helps Webgility Desktop users troubleshoot the “statement has been terminated” error encountered when accessing the Quantity Out of Sync list Webgility Desktop in case of BigCommerce. This error typically indicates an underlying application or SQL database configuration problem. The guide offers step-by-step instructions to identify, troubleshoot, and effectively resolve the issue.

Causes of the Issue

Below are the common causes that can lead to the “statement has been terminated” error in Webgility Desktop:

  • Database Schema Mismatch: Corrupt or missing tables, views, or procedures related to inventory sync.

  • Data Corruption: Bad or incomplete data in the local database can trigger this error.

  • Connectivity Issues: Improper SQL connectivity can interrupt operations, especially for inventory functions.

  • System/Application Updates Missing: Not running the latest version of Webgility or your OS can cause compatibility issues.

Steps to Resolve the Issue

1. Confirm Error Consistency

  • Try clicking on Quantity Out of Sync again.

  • Note when and how the error appears.

2. Backup the Webgility Database

  • Open SQL Server Management Studio (or the applicable SQL management tool).

  • Right-click the Webgility database > Tasks > Back Up.

  • Choose the destination and complete the backup process.

  • Store the backup in a secure location for safekeeping.

3. Validate Database Connection

  • Ensure your database server is reachable.

  • Use SQL tools to run simple queries (SELECT, INSERT) on the Webgility database to confirm connectivity.

4. Apply System or Application Updates

  • Check for pending updates for Webgility Desktop and your operating system.

  • Install all updates and restart your computer, and services.

5. Clear Partial Downloads and Re-download Sales Channel Data

  • Navigate to:
    Connections > Get Latest Data & Settings > Download Sales Channel Settings

  • Re-download the data from your BigCommerce sales channel.

Note

If the error is tied to very old or incomplete data in the local system, clearing the cache and ensuring full data integrity in your database is often enough to fix the issue.

Always ensure your Webgility Desktop is on the latest version to avoid compatibility issues.