OneDrive Authorization failing


#1

Hello,

Came back from weekend and found that the backups over the past 3 days failed due to the following error.

ERROR: Destination error: [DST-9:1001#1] Failed to open “Exbon Development Inc.” destination connection. > Unexpected response status code “Completed”. Status description: “Unauthorized”. ErrorMessage: “{“error”:{“code”:“unauthenticated”,“message”:“The caller is not authenticated.”}}”. ErrorException: “”.

Testing connection hangs for a few minutes and displays the same message. Trying to authorize by copy pasting the authorization code again displays the same behavior - hangs for a few minutes and displays the same message. We have not changed admin credentials from our side.


#2

Hi,

We also haven’t added any changes to SQLBackupAndFTP. To investigate this case we need more details. Could you please enable the advanced log, reproduce the issue and send logs to our dev team to check them. Please let us know when the logs will be sent.

Sorry for the inconvenience.


#3

Update: Today’s backup had the same warnings, but backup was successful.

Testing connection works and authorization code as well.

Edit: We posted almost at the same time. I will monitor backups throughout the week and will update if there are any more failures.


#4

Hello,

Sure, please feel free to contact us on any issues or concerns.


#5

Update on this - Backups worked Tuesday Wednesday and Thursday, failed again Friday Saturday Sunday and today.

Today in particular had a different error message - The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. > Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host

I have sent Advanced log. Seems like someone else is having similar problem recently for OD4B as well Backup to OneDrive for Business Error


#6

Hi,

Thanks for the logs, please give us some time to investigate this case.

Sorry for the inconvenience.


#7

Hi,

Could you please download SQLBackupAndFTP by the following link https://www.dropbox.com/s/oyyij3rx264u816/SQLBackupAndFTP_version11.exe?dl=0 install it and check if it resolves the issue?

Sorry for the inconvenience.


#8

I will monitor backups over the weekend and update, thank you.


#9

Sure, please feel free to contact us on any issues or concerns.


#10

Quick update before the weekend, today (Friday)'s backup failed with the new .exe file. Same error message


#11

Hello,

Thanks for the update. Could you please check, were the advanced logs were enabled? If yes, please send logs to our dev team. If no, please enable the advanced log, reproduce the issue and send the logs.

Sorry for the inconvenience.


#12

Log sent; all 4 backups over weekend failed.


#13

Hello,

Thank you for the details. We have checked your logs and it seems the issue is on OneDrive side. We have contacted their support team to resolve it. Here are more details https://github.com/OneDrive/onedrive-api-docs/issues/911

Sorry for the inconvenience.


#14

Hello,

We have added some changes to the latest release, could you please download it at https://www.dropbox.com/s/mr4a53ifprccne5/SBF_Setup_11.7.3.exe?dl=0 install and check if the issue is resolved?

Sorry for the inconvenience.


#15

Today’s backup with the latest release was successful with 0 warnings or errors.

I will monitor throughout the upcoming weekend and keep you updated.


#16

Good news!

Sure, please feel free to contact us on any issues or concerns.


#17

All backups succeeded over the weekend with 0 warnings/errors.

Looks like the problem is resolved, thank you!


#18

Good news! Thanks for the reply.

Please feel free to contact us on any issues or concerns.