- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Fix Error in reload.sql
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
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.
To fix it, you just need to move your file to the computer where you use QuickBooks:
Step 1: Update QuickBooks to the latest release
Step 2: Move the file locally
- Open a local folder where you want to save your file. Then, right-click anywhere.
- Select New, then Folder.
- Enter your desired folder name. Make sure not to use special characters (! " # $ % & ‘ * + , - . / : ; < = > ? @ [ ] ^ { | } ~).
- Go to the folder where your portable company file or accountant’s copy is saved in.
- Right-click on the file, then select Copy.
- Open the folder you created. Right-click anywhere, then select Paste.
- If the file name has special characters, delete them:
- Right-click on the file, then select Rename.
- Make the necessary changes, then click anywhere.
Step 3: Open or restore the file
- Hold the Ctrl key, then open QuickBooks.
- Restore your portable company file or open the accountant's copy.
- If you still can’t restore the file, proceed to step 4.
Step 4: Repair QuickBooks
- Close QuickBooks, then repair it.
- Once you’re done, open QuickBooks and retry to restore the file.
- If you still can’t open it, your QuickBooks installation files might be damaged. Proceed to step 5.
Step 5: Clean install QuickBooks
- Close QuickBooks.
- Uninstall, then clean install QuickBooks.
- Once you’re done, retry to open the file.
- If you still can’t restore it, proceed to step 6.