In this article, we will provide you the assistance to resolve Error in reload.sql at line XXXXX issue while opening a portable company file or accountant’s copy transfer file in QuickBooks Desktop for Windows.

Fix Error In Reload.sql

There can be various errors and issues related to the reload.sql issue and you can face multiple error messages while opening your company file. Select the error that you are getting and resolve 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

Error in reload.sql at line 25514. Sybase message: Right truncation of string data

You can face this error if the size of your portable company file or accountant’s copy transfer file is larger than 3 MB and you are trying to open it when it is stored on a different system or through a network.

  • Access your QuickBooks Company File from which the accountant’s copy transfer file.
  • Remove the accountant’s copy restriction.
  • Now, create and send 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 can resolve this error by moving your file to the local system where you are using QuickBooks Desktop:

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

You need to update the QuickBooks Desktop to the latest release. It is recommended for you to update your QuickBooks Desktop to the 2020 version.

Step 2: Move the file locally

  • Open Windows Explorer by pressing Windows + E keys and navigate to the folder where you want to save your folder.
  • Right-click anywhere in the folder and select New > Folder.
  • Provide a desired name to the folder. Note: Do not include any special character (! ” # $ % & ‘ * + , – . / : ; < = > ? @ [ \ ] ^ { | } ~).
  • Now, go to the folder where you have located your portable company file or accountant’s copy is stored.
  • Locate and right-click on the file and select Copy from the drop-down options.
  • Go to the folder you recently created and press CTRL + V keys to paste the file there.
  • Remove all the special character if there are some:
    • Right-click on the file and click on Rename from the drop-down options.
    • Make the required changes and hit enter.

Step 3: Open or restore the file

  • Press and hold the CTRL key and run QuickBooks.
  • Restore your portable company file or open the accountant’s copy.
  • If you are still not able to restore the file, go to the next solution.

Step 4: Repair QuickBooks

  • Close QuickBooks, then repair it:
    • Open the Control Panel and navigate to the Program and Features
    • Locate QuickBooks from the list and double-click on it.
    • On the installation wizard, click on Repair.
    • Perform onscreen prompts and at last, click on Finish.
  • Now, open QuickBooks and try to restore the file again.
  • If the file still can’t be opened, there are some issues with your QuickBooks installation damaged. Navigate to the next step to resolve this issue.

Step 5: Clean install QuickBooks

  • Close QuickBooks.
  • Uninstall, then clean install QuickBooks:
    • Open the Control Panel and navigate to the Program and Features
    • Locate QuickBooks from the list and double-click on it.
    • On the installation wizard, click on Uninstall.
    • Perform onscreen prompts and at last, click on Finish.
    • Now, install QuickBooks using a clean install.
  • Activate QuickBooks and try to open the file again.
  • If the file still can’t be restored, navigate to the next step.

Step 6: Run the QuickBooks Install Diagnostic Tool

From the QuickBooks Tools Hub, run the QuickBooks Install Diagnostic Tool.

Contact Us For Support

The provided 6 different solutions should be helpful for you in resolving the error occurring in reload.sql. However, if you are not able to resolve the error by following all the steps, it means there are some issues with your database. For this, you need to connect with the technical support department of Intuit by dialing our toll-free QuickBooks Support Phone Number +1888-346-0234 to get instant support for your issues.

Fix Error In Reload.sql – [Complete Resolution]

Leave a Reply

Your email address will not be published. Required fields are marked *

Call Us: +1888-346-0234