I'm attempting to restore a backup of build 9121. I'm following the steps here:
*********************************************************************************
Restore DB Setup Wizard
*********************************************************************************
Execute Restore DB Utility from command prompt
For Windows users :
bin>restoreData -c [backup file]
For Linux users :
bin]#sh restoreData.sh -c [backup file]
*********************************************************************************
You chose to open this file: C:\temp\backup_postgres_9121_fullbackup_09_19_2019_21_27\backup_postgres_9121_fullbackup_09_19_2019_21_27_part_1.data
File name is : C:\temp\backup_postgres_9121_fullbackup_09_19_2019_21_27\backup_postgres_9121_fullbackup_09_19_2019_21_27_part_1.data
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Thu Sep 19 21:27:21 EDT 2019
Database name : servicedesk
Total Tables : 1347
Database Server : postgres
Build Number : 9121
*************************************************************
Active DB Server = postgres
Database connectionProp : null
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
===================================================
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences
0-----------------------50------------------------100(%)
=================================QUERY = INSERT INTO WorkOrder (workorderid,requesterid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,workstationid,deptid,siteid,autoclosetime,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime,oboid,hasproject,hasdependency,ciid) VALUES(385, 1801, 1, 1382389586924, 0, 1382475986924, 1382447589725, 4002801, N'SPX Registration <PRIVATE INFO REMOVED>', 1, 2, NULL, NULL, NULL, NULL, NULL, '1', 4, NULL, '0', -1, '0', '0', '0', 0, '0', 1382447589725, NULL, '0', '0', NULL);
Unable to restore database : Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,workstationid,deptid,siteid,autoclosetime,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime,oboid,hasproject,hasdependency,ciid) VALUES(384, 1816, 1, 1382383653421, 1382445881294, 1382470053421, 1382640637116, 94983695, <PRIVATE INFO REMOVED> ', 1, 2, NULL, NULL, NULL, NULL, NULL, '1', 4, NULL, '0', -1, '0', '0', '0', 0, '0', 1382640637116, NULL, '0', '0', NULL) was aborted. Call getNextException to see the cause.
Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,workstationid,deptid,siteid,autoclosetime,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,surveystatus,hasdraft,resolvedtime,oboid,hasproject,hasdependency,ciid) VALUES(384, 1816, 1, 1382383653421, 1382445881294, 1382470053421, 1382640637116, 94983695, <PRIVATE INFO REMOVED> ', 1, 2, NULL, NULL, NULL, NULL, NULL, '1', 4, NULL, '0', -1, '0', '0', '0', 0, '0', 1382640637116, NULL, '0', '0', NULL) was aborted. Call getNextException to see the cause.