Manual backup failure since build 11304
I am aware that the backup routine changed with build 11304.
Since, unable are unable to perform a successful manual backup. Interestingly, the schedule backup from within ServiceDesk completes just fine. Albeit it produces two .ezip files instead of one. Is this correct, it looks like the same two .data files from the pre 11304 version. Is this correct?
Back to the manual backup, they always fail with the following error:
...
Backup table name :: ZRScheduleInfo
Backup table name :: ZRSharedUserType
Backup table name :: ZRSharedUsers
Backup OS : windows server 2016
Database Arch : 64
Database Version : 10.16
Problem while taking backUp
Using the backUpDataOld.bat works but with that we are unable to restore as the new restore routine requires the backup in the .ezip format.
Version: 11.3 Build 11307
Product Edition: Standard
DataBase: PGSQL 10.16
Backup log excerpt:
[11:50:44:390]|[09-28-2021]|[com.adventnet.db.adapter.postgres.PostgresBackupHandler]|[INFO]|[1]: Backup table name :: ZRScheduleInfo|
[11:50:44:390]|[09-28-2021]|[com.adventnet.db.adapter.postgres.PostgresBackupHandler]|[INFO]|[1]: Backup table name :: ZRSharedUserType|
[11:50:44:390]|[09-28-2021]|[com.adventnet.db.adapter.postgres.PostgresBackupHandler]|[INFO]|[1]: Backup table name :: ZRSharedUsers|
[11:50:44:390]|[09-28-2021]|[com.adventnet.db.adapter.postgres.PostgresBackupHandler]|[INFO]|[1]: Command to be executed [C:\ManageEngine\ServiceDesk\bin\\..\pgsql/bin/pg_dump, -Usdpadmin123, -h, 127.0.0.1, --port=65432, -w, -s, -t, WOToProjects, -t, WOToPurchaseRequests, -t, WOToRDSSummary, -t, WsRdsCredentials, -t, YSeriesColumn, -t, ZIA_ApprovalData, -t, ZIA_ApprovalPrediction, -t, ZIA_CumulativeAccuracy, -t, ZIA_ReopenPrediction, -t, ZohoReportsConfiguration, -t, ZoneCountryMappingDefinition, -t, ZRDynamicValuesInfo, -t, ZRScheduleInfo, -t, ZRSharedUserType, -t, ZRSharedUsers, -f, C:\ManageEngine\ServiceDesk\trimmedbackup\backup_postgres_11307_database_09_28_2021_11_49\backup_postgres_11307_database_09_28_2021_11_49_part_1\schema18.sql, servicedesk]|
[11:50:46:390]|[09-28-2021]|[com.adventnet.db.adapter.BackupRestoreUtil]|[INFO]|[1]: Wait For returns :: [0] Process exitValue :: [0]|
[11:50:46:390]|[09-28-2021]|[com.adventnet.db.adapter.postgres.PostgresBackupHandler]|[INFO]|[1]: Creating SQL files for restore......Tables in range :1800-1900|
[11:50:47:140]|[09-28-2021]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[1]: Command to be executed [C:\ManageEngine\ServiceDesk\bin\\..\pgsql\bin\postgres.exe, -V] |
[11:50:47:203]|[09-28-2021]|[com.manageengine.servicedesk.tools.BackUp]|[INFO]|[1]: Exception on backup taken String index out of range: -70|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: java.lang.StringIndexOutOfBoundsException: String index out of range: -70|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at java.lang.String.substring(String.java:1967)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.getAllVersions(AbstractBackupHandler.java:946)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.addSpecXMLEntryToProps(AbstractBackupHandler.java:925)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresBackupHandler.doTableBackup(PostgresBackupHandler.java:1360)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.doBackup(AbstractBackupHandler.java:479)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDatabase(BackUp.java:463)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDB(BackUp.java:371)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.trimmedBackUp(BackUp.java:322)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.main(BackUp.java:294)|
[11:50:47:203]|[09-28-2021]|[com.manageengine.servicedesk.tools.BackUp]|[INFO]|[1]: source to move is ::::C:\ManageEngine\ServiceDesk\trimmedbackup\backup_postgres_11307_database_09_28_2021_11_49
destinationFolder ::::C:\ManageEngine\ServiceDesk\trimmedbackup\partialBackup
|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: java.nio.file.DirectoryNotEmptyException: C:\ManageEngine\ServiceDesk\trimmedbackup\partialBackup|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at sun.nio.fs.WindowsFileCopy.move(WindowsFileCopy.java:373)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at sun.nio.fs.WindowsFileSystemProvider.move(WindowsFileSystemProvider.java:287)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at java.nio.file.Files.move(Files.java:1395)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.failureHandler(BackUp.java:1716)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDatabase(BackUp.java:491)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDB(BackUp.java:371)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.trimmedBackUp(BackUp.java:322)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.main(BackUp.java:294)|
[11:50:47:203]|[09-28-2021]|[com.manageengine.servicedesk.tools.BackUp]|[INFO]|[1]: Failed to move failed backup to PartialBackup folder.|
[11:50:47:203]|[09-28-2021]|[com.manageengine.servicedesk.tools.BackUp]|[SEVERE]|[1]: Problem while BackingUp DB.|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: java.lang.StringIndexOutOfBoundsException: String index out of range: -70|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at java.lang.String.substring(String.java:1967)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.getAllVersions(AbstractBackupHandler.java:946)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.addSpecXMLEntryToProps(AbstractBackupHandler.java:925)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.postgres.PostgresBackupHandler.doTableBackup(PostgresBackupHandler.java:1360)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.adventnet.db.adapter.AbstractBackupHandler.doBackup(AbstractBackupHandler.java:479)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDatabase(BackUp.java:463)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.backupDB(BackUp.java:371)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.trimmedBackUp(BackUp.java:322)|
[11:50:47:203]|[09-28-2021]|[SYSERR]|[INFO]|[1]: at com.manageengine.servicedesk.tools.BackUp.main(BackUp.java:294)|
Looking forward to your ideas.