“Error in reload.sql at line XXXXX” messages when opening a portable company file or accountant’s copy transfer file in QuickBooks for Windows.There are different kinds of reload.sql error messages you might see when opening your file. Select the error that applies to you to find out how to fix it.
“Error in reload.sql at line 29886. Sybase message: can not convert hex string to a varbinary” or “Error in reload.sql at line 25514. Sybase message: Right truncation of string data”
You see these errors when you open an accountant’s copy transfer file (.QBX). To fix these, you just need to recreate and resend the file to your accountant:
- Open the company file from which you created the accountant’s copy transfer file.
- Remove the accountant’s copy restriction.
- Create and send the new accountant’s copy to your accountant.
Error in reload.sql at line 40454. Sybase message: The file [file_name] is invalid when the disk sandbox feature is enabled for database ‘[database]’
You might see this error when your portable company file (.QBM), or accountant’s copy transfer file (.QBX) is larger than 3MB and you try to open it while it’s saved on a different computer or through a network.
The “Portable or Accountant’s copy is being restored over the network” means that a copy is restored on a different computer where QuickBooks is not installed locally. You’ll need to make sure that you have your own copy stored on the computer where QuickBooks is located to prevent this error.
Also, restoring .QBB file refers to the copy that will be deleted automatically once a backup copy is completely stored. For more details about this process, please refer to this article: Resolve error in reload.sql at line #####. Sybase message: the disk sandbox feature is enabled.
If you are unable to resolve the error using the basic troubleshooting steps mentioned above, your data file is most likely to be corrupted and will need to be repaired using a Quickbooks Data Recovery Service. We work with all versions of Quickbooks from DOS version 1.0 to Quickbooks Enterprise/Premier/Pro/Pro Plus 2016. We also work with all international versions of Quickbooks: Quickbooks US, Quickbooks Canada, Quickbooks UK, Quickbooks Australia and NZ (Reckon Accounts) just click https://quickbooksrepairpro.com/Error-in-reload.sql-at-line-xxx.aspx