Servicedesk Plus: Problem restoring data in a new server

Hello!

We're trying to restore our SDP on a new pre-production server for now.

Both SDP Builds ( old server and new server) are the same: 13012

The backup process in the production server finish with no problems. But when we launch the restoredata process on the new server, it finish saying : "Problem while restoring DB" and SDP won't work anymore.

Here is the last lines of the log in case it helps:

[17:15:22:352]|[07-21-2023]|[com.adventnet.db.adapter.AbstractRestoreHandler]|[INFO]|[26]: restoreStatus :: <RestoreStatus backupMode="null" backup_zipname="E:\ManageEngine\ServiceDesk\backup_postgres_13012_fullbackup_07_21_2023_16_37\backup_postgres_13012_fullbackup_07_21_2023_16_37_part_1.ezip" restore_starttime="2023-07-21 17:14:44.805" restore_endtime="1970-01-01 00:59:59.999" restore_status="RESTORE_PROCESS_FAILED" exceptionContext="null"/>|

[17:15:22:836]|[07-21-2023]|[com.adventnet.persistence.PersistenceInitializer]|[INFO]|[26]: Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk?charSet=UTF-8&loginTimeout=5&socketTimeout=1200&connectTimeout=5|

[17:15:22:836]|[07-21-2023]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[26]: Command to be executed [E:\ManageEngine\ServiceDesk\bin\..\pgsql\bin\pg_isready.exe, --host, 127.0.0.1, --port, 65432, -t, 120, --username, sdpadmin] |

[17:15:22:945]|[07-21-2023]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[SEVERE]|[26]: Command :: [E:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe, -w, -D, E:\ManageEngine\ServiceDesk\pgsql\data, -o, "-p65432", stop, -s, -m, fast]|

[17:15:22:945]|[07-21-2023]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[26]: Command to be executed [E:\ManageEngine\ServiceDesk\pgsql\bin\pg_ctl.exe, -w, -D, E:\ManageEngine\ServiceDesk\pgsql\data, -o, "-p65432", stop, -s, -m, fast] |

[17:15:25:430]|[07-21-2023]|[com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer]|[INFO]|[26]: Command to be executed [E:\ManageEngine\ServiceDesk\bin\..\pgsql\bin\pg_isready.exe, --host, 127.0.0.1, --port, 65432, -t, 120, --username, sdpadmin] |

[17:15:26:492]|[07-21-2023]|[com.adventnet.db.adapter.AbstractRestoreHandler]|[INFO]|[26]: restoreStatus :: <RestoreStatus backupMode="null" backup_zipname="E:\ManageEngine\ServiceDesk\backup_postgres_13012_fullbackup_07_21_2023_16_37\backup_postgres_13012_fullbackup_07_21_2023_16_37_part_1.ezip" restore_starttime="1970-01-01 00:59:59.999" restore_endtime="1970-01-01 00:59:59.999" restore_status="RESTORE_PROCESS_FAILED" exceptionContext="com.adventnet.db.adapter.BackupRestoreException: R0RP16: Problem while executing command.

at com.adventnet.db.adapter.postgres.PostgresRestoreHandler.processSQLForRestore(PostgresRestoreHandler.java:1090)

at com.adventnet.db.adapter.postgres.PostgresRestoreHandler.restoreUsingCopyManager(PostgresRestoreHandler.java:877)

at com.adventnet.db.adapter.postgres.PostgresRestoreHandler.restoreTableBackup(PostgresRestoreHandler.java:764)

at com.adventnet.db.adapter.AbstractRestoreHandler.restoreBackup(AbstractRestoreHandler.java:634)

at com.zoho.mickey.startup.MEServer.restoreDatabase(MEServer.java:760)

at com.zoho.mickey.startup.MEServer.restoreDB(MEServer.java:733)

at com.manageengine.servicedesk.tools.Restore.restoreDB(Restore.java:368)

at com.manageengine.servicedesk.tools.Restore.main(Restore.java:289)

at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:200)

at java.lang.Thread.run(Thread.java:748)

"/>|

[17:15:26:492]|[07-21-2023]|[com.zoho.framework.utils.FileUtils]|[INFO]|[26]: File :: [E:\ManageEngine\ServiceDesk\backup_postgres_13012_fullbackup_07_21_2023_16_37\backup_postgres_13012_fullbackup_07_21_2023_16_37_part_1], Type :: Directory, Exists? :: false|

[17:15:26:492]|[07-21-2023]|[com.adventnet.db.adapter.AbstractRestoreHandler]|[INFO]|[26]: Delete [E:\ManageEngine\ServiceDesk\backup_postgres_13012_fullbackup_07_21_2023_16_37\backup_postgres_13012_fullbackup_07_21_2023_16_37_part_1] :: [true]|

[17:15:26:508]|[07-21-2023]|[com.zoho.framework.utils.DefaultFileCleanUpTracker]|[INFO]|[26]: E:\ManageEngine\ServiceDesk\backup_postgres_13012_fullbackup_07_21_2023_16_37\backup_postgres_13012_fullbackup_07_21_2023_16_37_part_1 is removed from startup_file_cleanup.txt|

com.adventnet.db.adapter.BackupRestoreException: R0RP16: Problem while executing command.