Error while invoking backup_MSSQLException: TDS Protocol error
java.sql.SQLException: TDS Protocol error: Invalid packet type 0x64 at
Based on the Email screenshot it looks like you have the "TDS Protocol Error" message. We have seen this message occur under different situations and mostly it is a SQL or network related issue.
* You have network connection issue between the application and the SQL server.
* There is another backup happening when the application tries to back up the database.
In most cases, when you re-schedule the backup to a different time (outside of operational hours), the issue will be resolved.
If you continue to receive such backup failures even after scheduling it to different hours, please keep us posted.
New to ADSelfService Plus?
Resources
Related Articles
SQL Backup permission post 10.6 Upgrade.
Error on the logs: [20:00:50:193]|[04-25-2022]|[com.adventnet.taskengine.backup.DbBackupTask]|[INFO]|[124]: BackupStatus updated in DB :: <BackupStatus backup_id=1806 backupType="FULL_BACKUP" ...
How do I restore the backup data?
NOTE: For builds > 10.6 While migrating to different database you can use backupdataold.bat / backupdataold.sh. Here backup will be in .data format and this can be restored in across DB platform. While restoring .data file we have to use below ...
Restore fails due to CRC error
When the Backup is Password protected, then during restore, the application is unable to unzip the backup file due to CRC error below, Default Backup password: SDP123! java.io.IOException: invalid CRC (MAC) for file: ...
Scheduled Backup Failure
Sometimes the scheduled backup fails due to the below error in the logs, Error Message org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. at ...
How to take a backup in SDP-MSP
Note: In 10.6 when running a backup using backdata.bat/backdata.sh the backup file will be in .ezip format. Backup with .ezip format can be restored to the same database platform only. For example a backup with .ezip when taken from postgres DB ...