Navigate
Wasp Helpdesk
  • Register

  • or
  • Login
    Need a password reminder?
or
Contact Us
  • Get in touch

    Send us an email

  • Start a chat session

  • Knowledgebase Read help articles
  • News News & updates
  • Contact Us We are here to help
  • Training View our options
  • Product Sunsets Non-Supported Products
Barcode System Consult
Barcode Printer Consult
Barcode Label Consult
  • Portal
  • Knowledgebase
  • Discontinued Products
  • MobileAsset
  • MobileAsset: "WT1002: Error executing sql statement" when trying to Dispose, Check Out, or Check In an asset
Subscribe Download PDF

MobileAsset: "WT1002: Error executing sql statement" when trying to Dispose, Check Out, or Check In an asset

Internal User
2023-01-19
in MobileAsset

If you get an error reading "WT1002: Error executing sql statement. Database timeout period elapsed prior to completion of a SQL query or the server is not responding" when trying to Dispose, Check Out, or Check In an asset, check the MobileAsset.log file. If it contains a line reading "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_asset_transactions_departments". The conflict occurred in database "WaspTrackAsset", table "dbo.departments", column 'department_id'. The statement has been terminated." you will need to download and extract the linked file on the database server machine and run Upgrade.bat.

https://dl.waspbarcode.com/wasp/supportfiles/updatedepartment.zip

This will correct the error in the department table of the database that is preventing those transactions from being processed properly.

Rate the quality of this page

This page was helpful :) :( This page was not helpful

21 of 37 people found this page helpful


Quick Jump
  • Wasp Helpdesk
  • Knowledgebase
  • News
  • Contact Us
Top
Helpdesk software provided by Deskpro