ERROR: 'There has been a problem uploading company data for Remote Data Access'
Description

When activating Remote Data Access, the following message appears:

'There has been a problem uploading company data for Remote Data Access, or the upload of data was cancelled'.

Cause
Resolution

This error occurs if the total file size uploaded to RDA exceeds 4000MB, or the company name contains special characters. For example é, Ä, Î, Ç. 

Follow the steps below, reuploading after each to resolve this error:

▼ Disconnect connected services

If you've uploaded and removed RDA previously, disconnect all connected services.

CAUTION:

You'll need to reconnect any other connected services you use. For example, Bank feeds.


▼ Check company name for character map characters
  1. Remove any special characters from the company name, for example é, Ä, Î, Ç.
  2. Add a full stop to the company name, or alter it slightly.

▼ Check transaction attachment sizes

We recommend removing any large attached files that are increasing the upload size. 

  1. In the company you're experiencing the problem, back up your data.
  2. Go to Help then About and click your Data Directory path.
  3. Right-click the Transaction Attachments folder and click Properties. Keep this window open as you'll move the folder in step 8.

The File explorer window showing a list of folders with the Transaction Attachments folder highlighted.

  1. If the Size exceeds 1000MB, we recommend removing some of the attachments to reduce this.
  2. Review the contents of this folder to locate any attachments you want to remove. 
  3. Note of the transaction number you want to remove.
  4. In Sage 50 Accounts, delete the transaction attachments you noted.  
  5. Right-click the Transaction Attachments folder and select Cut.
  6. Paste this folder onto your desktop.
  7. Upload your company data to RDA again.
  8. Right-click the Transaction Attachments folder on your desktop and select Cut.
  9. Paste this folder back into the data directory window. You can then close this window.

▼ Disable Internet Protocol version 6 (IPV6)
  1. Open the Control Panel.
  2. Go to Network and Internet, then select Network and Sharing Centre.
  3. Select Change adapter settings.
  4. Right-click your connection then select Properties.

  5. Clear the Internet Protocol Version 6 (TCP/IPv6) checkbox.

▼ Reindex and compress your data
  1. Go to File then Maintenance.
  2. Select Reindex, Select All then OK.
  3. Select Yes, then Compress now, then Compress.
  4. Select OK, then Close, then Close again.

Now try switching on RDA in your company. If the error still appears, proceed to the following sections.


▼ Rebuild the deleted record files

CAUTION:

Don't follow these steps if you use Sage Network, or Invoice Payments. 

  1. Take a backup of your data.
  2. Go to File, Maintenance, then Rebuild.
  3. Untick Keep my Deletion Log and click OK.
  4. Click Yes then OK. 

▼ Rebuild Invoice Payments

Follow the below steps whether you use Invoice Payments or not:

NOTE:

To check whether you use Invoice payments, click Help and About. Invoice payments appears under Features Enabled.

▼ Steps for Sage 50 Accounts v30.1 or above

here

  1. Back up your data, then disconnect Invoice Payments

If you don't use Invoice Payments, continue to step 2.

  1. Go to File, then Maintenance, then select Rebuild.
  2. Clear the Invoice Payments checkboxes. 

Highlighted 'Keep my Invoice payments settings' and 'Keep my Invoice payments failures' checkboxes.

  1. Select OK then Yes.
  2. Select OK then Close.
  3. Select Connected Services then Disconnect Sage account.
  4. Select Disconnect Sage account, then Disconnect, then OK. 

    CAUTION:

    This will disconnect any connected services you use, for example Bank Feeds, Remote Data Access, or Sage Network.


▼ Steps for v30.0 and below
  1. Back up your data, then disconnect Invoice Payments
  2. Go to Help then click About.
  3. Select the Settings folder.
  4. Open the SAGE.INI file with notepad, then under [SG50] add the line, RemoveinvoicepaymentID=1.

    SAGE.INI window in notepad with the line RemoveinvoicepaymentID=1 line added in.
  5. Go to File then select Save.
  6. Go to File then select Close.
  7. Close and reopen Sage 50 Accounts.
  8. Click File then click Maintenance and click Rebuild.
  9. Clear the Invoice Payments checkboxes:

    Highlighted 'Keep my Invoice payments settings' and 'Keep my Invoice payments failures' checkboxes.

  10. Select the Remove IP IDs button.
  11. Select OK then Yes.
  12. Select OK then Close.

 


▼ 403: Remote Data Access account not found
  1. Go to drive.sage.com/mc.
  2. Enter your Sage Account email address and password.
  3. If prompted to register for the service, enter your Sage 50 Accounts serial number and account number.

▼ 403: Forbidden

This relates to Internet security issues and you can fix this by resetting Internet Security and Internet Explorer settings.

  1. In the Windows search box type Control Panel, then select Control Panel.
  2. Select Internet Options, then Advanced, then select Restore advanced settings.
  3. Select Reset, then Reset again.
  4. Back in Internet properties go to the Security tab.
  5. Select Reset all zones to the default level, then select Apply.
  6. Under 'Select a zone to view or change security settings', select Trusted sites.
  7. Select Sites then add the following URLs using the Add option.
  8. Select Close then OK.

If you've tried all the steps above, try refreshing the queue.dta file to resolve this.

[BCB:19:UK - Sales message :ECB]
Steps to duplicate
Related Solutions