Learn how to fix “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
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.
To fix it, you just need to move your file to the computer where you use QuickBooks: