cancel
Showing results for 
Search instead for 
Did you mean: 
nimeshsoni1591
Level 1

reload.sql at line 365

i was trying to create a new company file from existing company file in quickbooks desktop enterprise 20.0 but i am getting error:

Error in reload.sql at line 365. sybase message: Primary key for table 'abmc_account_user' is not unique: Primary key value ("1")

 

How to solve this error? Because of this error i am not able to create a new company file. and i had also contacted quickbook support but they also don't have the proper solution for this.QB-New file error.png

7 Comments 7
RaymondJayO
Moderator

reload.sql at line 365

I've got the proper solutions for this, @nimeshsoni1591

 

I appreciate you for providing a screenshot of the error you've received when creating a new company file from an existing one. 

 

Here are the potential causes of this issue: 

  • QuickBooks Desktop (QBDT) Enterprise 2020 is outdated. 
  • The new file is larger than 3MB.
  • A damaged QuickBooks installation.
  • The file is saved on a different computer or through a network when you create it.

 

First, let's make sure the program is updated to the latest release to fix this. I'll guide you how. 

  1. Go to the Help menu and choose Update QuickBooks Desktop.
  2. Select Update Now
  3. Click Get Updates to start the download.
  4. Restart QuickBooks when the download is complete. 
  5. When prompted, accept the option to install the new release.

 

Second, move the company file to another folder and then re-open the file from the new location. Here's how:

  1. Open a local folder where you want to save your file. Then, right-click anywhere.
  2. Click New and choose Folder.
  3. Type in your desired folder name. Make sure not to use special characters (! " # $ % & ‘ * + , - . / : ; < = > ? @ [ \ ] ^ { | } ~).
  4. Go to the folder where your existing company file is saved in.
  5. Right-click on the file and select Copy.
  6. Open the folder you created. Right-click anywhere and select Paste.
  7. If the file name has special characters, right-click on it and select Rename. Make any necessary changes and then click anywhere. 

 

After that, recreate a new company file from an existing one to see if it works. If not, follow the Steps 3 - 6 through this article: Fix Error in reload.sql at line XXXXX

 

Once resolved, you can start using QuickBooks right away, such as creating invoices. To help you get familiar with the program and learn more about its basics, check out these two links below

 

I'll lend a helping hand if you need anything else. Keep safe. 

nimeshsoni1591
Level 1

reload.sql at line 365

Hi

Thanks for the quick reply. I had tried the steps you mentioned. But still it didn't work for me. is there any other solution is there?

Kristine Mae
Moderator

reload.sql at line 365

I appreciate you doing the steps provided by my colleague, Nimeshsoni1591. It should've fixed your concern.

 

I suggest reaching out to our customer care support since you're still encountering the same issue. They have more tools to take a better look at it. Here's how:

  1. Click Help inside QuickBooks.
  2. Go to QuickBooks Desktop Help.
  3. Click Contact Us.
  4. Enter "Error reload.sql at line 365" in the description field, then click Continue.
  5. Select either Message an Agent or Talk to a Specialist.

Let me also add the support hours and types to guide you better.

 

Feel free to visit the Community if you have other concerns. We're just around to help you.

vikingpepper
Level 1

reload.sql at line 365

Hi nimeshsoni1591,

 

Did you resolve the issue? I have the same problem and have not been able to fix it too.

CharleneMaeF
QuickBooks Team

reload.sql at line 365

I appreciate you for joining us here, @vikingpepper.

 

The troubleshooting steps shared by my colleague, RaymondJayO, can fix the error. If you're done following the steps and the issue persists, I recommend contacting our QuickBooks Desktop Support Team. One of our representatives can securely look into your account to determine the main cause of this.

 

 You can have the full contact information by going to the Help menu. Then, you'll get real-time assistance via the Start a Message option. 

 

Here are the complete steps:

  1. From the Help menu, select QuickBooks Desktop Help.
  2. In the Have a Question window, scroll down to click the Contact us link.
  3. This will display the Contact Us screen.
  4. Go to the Tell us more about your question section and enter Error reload.sql at line 365
  5. Click the Search button to display the Start a Message button.

 

Additionally, you can always visit our Help articles page for reference. There, you can read step by step process that will guide you in completing your future tasks.

 

If you need help with other QuickBooks concerns, you can drop a message anytime. This way, we'll be able to further assist you.

Fiat Lux - ASIA
Level 15

reload.sql at line 365

@vikingpepper 

Were you able to create a dummy file or open a sample one? If you didn't see the error message, it means your company file is damaged. Contact Support and ask for Intuit Data Service to fix it. Otherwise you have to purchase a 3rd party file repair service.

Fouber
Level 2

reload.sql at line 365

Are you telling us that we now need to move files off the network to create new files from existing files?  Is this a temporary workaround while Intuit fixes an issue?

Need to get in touch?

Contact us