Backup to Google Drive Failed

Destination Issues
21

я пробовал разбивать архив по 1 ГГб - все равно не работает загрузка на Google Drive

в логе пишет
WARNING: Destination error: > > Failed to read response from the Google Drive service. > Invalid JSON string

22

Hello Vadym_Niemtsev,

Could you please let us know what version of SQLBackupAndFTP do you use?

Thank you and sorry for the inconvenience.

23

Hi Alexsander
12.7.12

24

Hello Vadym_Niemtsev,

Could you please upgrade to the latest release of SQLBackupAndFTP version 12.7.13 and check if the issue is resolved?

Please let us know if you have any other questions.

Thank you and sorry for the inconvenience.

25

Hi, do we have any confirmation that the upgrade fixes the issue? I’m having a similar issue

26

Hello Nathan_Coulbeck,

Yes, the issue you mentioned has been resolved in the latest release of SQLBackupAndFTP, which is version 12.7.14.

If you have any other questions, please feel free to ask.

Thank you for using SQLBackupAndFTP.

27

Hi Alexander, I’ve updated to 12.7.14 but I’m still getting these errors, it’s less frequent now but it seems to be still happening when I do a Differential backup every 6 hours. Any ideas?

29/05/2023 03:23:52 [Info] Connecting to Google Drive destination SQL Backups.
29/05/2023 03:23:53 [Info] The current destination folder is /Boudacia.
29/05/2023 03:23:53 [Info] Sending backup of YTC NAV Live to Google Drive destination SQL Backups.
29/05/2023 03:23:53 [Info] Uploading local Live202305290300diff.7z to remote Live202305290300diff.7z in folder /Boudacia.
29/05/2023 03:25:25 [Warning] Destination error: > > Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host
29/05/2023 03:25:25 [Info] Trying again…
29/05/2023 03:25:33 [Warning] Destination error: > > Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host
29/05/2023 03:25:33 [Info] Trying again…
29/05/2023 03:25:42 [Warning] Destination error: > > Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host
29/05/2023 03:25:42 [Info] Trying again…
29/05/2023 03:25:49 [Warning] Destination error: > > Failed to read response from the Google Drive service. > Invalid JSON string
29/05/2023 03:25:49 [Info] Trying again…
29/05/2023 03:25:59 [Error] Destination error: > > Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. > An existing connection was forcibly closed by the remote host
29/05/2023 03:26:00 [Info] Disconnecting from Google Drive destination SQL Backups.
28

Hello Nathan_Coulbeck,

Some of our customers reported the same issue, which is related to Google Drive authorization settings.

The customers shared the following steps to resolve the issue:

  1. Deleted the authorization for SQLBackupAndFTP to access Google Drive
  2. Deleted your backup job
  3. Recreated the backup job
  4. Re-authorize Google Drive access
  5. Ran the job successfully.

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.