OPManager Plus APManager as ADon issue while restoring backup
OPManager build 124075
APM adon build 13850
Steps:
1. Backup data from both aplication OPM & APM adon
2. Backup hole directory "Manageengine"
3. Fresh installation of OPM 124075 and APM 13850adon.
4. Register application with license.
5. Execute restoreDB.bat for OPM ends with errors:
[09-24-2019]|[14:43:14:203]|[FINE] : Restoring table UniqueKeyDefinition
[09-24-2019]|[14:43:14:343]|[FINE] : Restoring table PKDefinition
[09-24-2019]|[14:43:15:045]|[SEVERE] :
jdbc.RestoreException: Error occurred while Restoring Data.
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:210)
at jdbc.AbstractRestoreDB.restoreDB(AbstractRestoreDB.java:106)
at jdbc.AbstractRestoreDB.doRestore(AbstractRestoreDB.java:696)
at jdbc.RestoreBackup.restoreDB(RestoreBackup.java:104)
at jdbc.RestoreBackup.main(RestoreBackup.java:229)
Caused by: java.util.concurrent.ExecutionException: java.lang.Exception: Restore failed for table 'PKDefinition' :
Restore failed for table 'PKDefinition' :
SET
SET
SET
SET
SET
SET
psql:c:/Program Files/ManageEngine/OpManager/backup/temp1/backup/opmanager/PKDefinition.bkp:5057: ERROR: insert or update on table "pkdefinition" violates foreign key constraint "pkdefinition_fk1"
DETAIL: Key (pk_id)=(20106) is not present in table "constraintdefinition"...
at java.util.concurrent.FutureTask.report(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at jdbc.RestoreDB.readFileAndRestoreData(RestoreDB.java:201)
... 4 more
Caused by: java.lang.Exception: Restore failed for table 'PKDefinition' :
Restore failed for table 'PKDefinition' :
SET
SET
SET
SET
SET
SET
psql:c:/Program Files/ManageEngine/OpManager/backup/temp1/backup/opmanager/PKDefinition.bkp:5057: ERROR: insert or update on table "pkdefinition" violates foreign key constraint "pkdefinition_fk1"
DETAIL: Key (pk_id)=(20106) is not present in table "constraintdefinition"...
at jdbc.RestoreDB$RestoreData.restoreUsingPgSqlCommand(RestoreDB.java:447)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:311)
at jdbc.RestoreDB$RestoreDataThread.call(RestoreDB.java:249)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
[09-24-2019]|[14:43:15:045]|[FINE] : Deleting temporary files if exists ...
[09-24-2019]|[14:43:21:020]|[FINE] : temp files deleted successfully.
[09-24-2019]|[14:43:21:020]|[FINE] : Restore finished at : 09-24-2019 at 14:43:21:020
[09-24-2019]|[14:43:21:020]|[FINE] : ******************* Restore DB Completed ***********************
I`m not able to fix such error by my self please advice or set te remote session for solving that problem.
New to ADSelfService Plus?