Summary
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.'
Resolution
This error usually appears when the total file size uploaded to Remote Data Access exceeds 4000MB, or if the company name includes a character map letter, some examples include é, Ä, Î, Ç.
Follow the below steps re-uploading after each to resolve this error:
Check company name for character map characters
If the company name contains a character from the character map (some examples include: é, Ä, Î, Ç), remove these from the company name and then try again.
Rebuild the deleted record files
CAUTION: These steps must not be followed if Lockstep or Invoice payments are enabled.
- Take a backup of your data.
- Click File, Maintenance then Rebuild.
- Untick Keep my Deletion Log and click OK.
- Click Yes then OK.
TIP: Having problems stopping the service?
Reindex and compress your data
- Click File, then click Maintenance.
- Click Reindex, click Select All then click OK.
- Click Yes, click Compress now then click Compress.
- Click OK then click Close and click Close again.
Now try switching on Remote Data Access in your company. If the error still appears, please proceed to the following sections.
Rebuild Invoice Payments
CAUTION: You must follow these steps even if you don't use Invoice Payments.
This error can be caused by an issue with Invoice payments, where old transaction data is not cleared.
NOTE: To check if you use Invoice payments, click Help and About then check under Features Enabled that Invoice Payments is set to Yes.
- Back up your data, then disconnect Invoice Payments.
- Click Help then click About.
- Click the Settings folder.
- Open the sage.ini file using notepad and under [SG50] add the line, RemoveinvoicepaymentID=1
- Click File then click Save.
- Click File then click Close.
- Close and reopen Sage 50 Accounts.
- Click File then click Maintenance and click Rebuild.
- Clear the the Invoice Payments check boxes:
- Click Remove IP IDs
- Click OK then click Yes.
- Click OK then click Close.
Check transaction attachment sizes
We recommend removing any large attached files that are increasing the upload size.
- Press the Windows key + E, browse to the data path you noted above.
- Right-click the Transaction Attachments folder and click Properties.
If the Size exceeds 1000MB, if possible we would recommend removing some of the attachments to reduce this. - Review the contents of this folder to locate any attachments you want to remove.
- Make a note of the transaction number you want to remove, then in Sage 50 Accounts, remove the transaction attachments you noted. Read more >
403: Remote Data Access account not found
- Go to drive.sage.com/mc
- Enter your Sage Account email address and password.
- 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.
- In the Windows search box type Control Panel then click Control Panel.
- Click Internet Options, click Advanced then click Restore advanced settings.
- Click Reset, then click Reset.
- Back in Internet properties click the Security tab.
- Click Reset all zones to default level, then click Apply.
- Under 'Select a zone to view or change security settings', click Trusted sites.
- Click Sites then add the following URLs using the Add option.
- Click Close then click OK.
Disable IPV6
NOTE: Sage 50 Accounts uses IPV4 to communicate with the data services. You can disable IPV6 by following the steps below.
- Open the Control Panel.
- Click Network and Internet.
- Click Network and Sharing Centre.
- Click Change adapter settings.
- Right-click your connection and then click Properties.
- Clear the checkbox next to Internet Protocol Version 6 (TCP/IPv6).
Find out more in our dedicated Help Centre
To help you with Remote Data Access, we've pulled together everything you need!
Visit the Help Centre >