Service Desk restore failing
Can you please assist, i am failing to restore a backup to service desk running on postgres. Below is the error we get when restoring.
*********************************************************************************
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:\Users\administrator.SABRY\Desktop\backup_postgres_9317_fullbackup_04_07_2019_21_57\backup_postgres_9317_fullbackup_04_07_2019_21_57_part_1.data
File name is : C:\Users\administrator.SABRY\Desktop\backup_postgres_9317_fullbackup_04_07_2019_21_57\backup_postgres_9317_fullbackup_04_07_2019_21_57_part_1.data
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Sun Apr 07 21:57:23 CAT 2019
Database name : servicedesk
Total Tables : 1516
Database Server : postgres
Build Number : 9317
Backupid : 1554667043583
*************************************************************
localhost:65432 - no response
localhost:65432 - accepting connections
Active DB Server = postgres
Database connectionProp : null
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
===================================================
Error Tables : wordmap,wordoccurrences,errorlog,softwaremanufacturer,softwarelist,sduserprofile
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences,errorlog,softwaremanufacturer,softwarelist,sduserprofile
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
0-----------------------50------------------------100(%)
===========================QUERY = INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(96, 344, NULL, 377, 1339659486782, 0, 1339673886782, 1352462210584, 3245548664, N'Provision new colour printer', N'Provision a new colour printer for Ailsa.Call Pansolutions', 1, 302, NULL, 311, 301, NULL, '0', NULL, '1', 4, 301, '0', -1, '0', '0', '0', '0', 1, '0', 1352462210584, '0', '0', NULL);
Unable to restore database : Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(1, 349, NULL, 6, 1337599132307, 0, -1, 0, 0, 'Please create an account for me Active Directory', 'Please create an account for me Active Directory;User: James KatongoTitle: Assistant AccountantDept: Finance', NULL, NULL, 21, 311, 301, NULL, '0', 1337878227165, '1', 19, 1, '1', -1, '0', '0', '0', '0', 0, '0', 0, '0', '0', NULL) was aborted. Call getNextException to see the cause.
Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(1, 349, NULL, 6, 1337599132307, 0, -1, 0, 0, 'Please create an account for me Active Directory', 'Please create an account for me Active Directory;User: James KatongoTitle: Assistant AccountantDept: Finance', NULL, NULL, 21, 311, 301, NULL, '0', 1337878227165, '1', 19, 1, '1', -1, '0', '0', '0', '0', 0, '0', 0, '0', '0', NULL) was aborted. Call getNextException to see the cause.
localhost:65432 - accepting connections
localhost:65432 - rejecting connections
localhost:65432 - no response
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:\Users\administrator.SABRY\Desktop\backup_postgres_9317_fullbackup_04_07_2019_21_57\backup_postgres_9317_fullbackup_04_07_2019_21_57_part_1.data
File name is : C:\Users\administrator.SABRY\Desktop\backup_postgres_9317_fullbackup_04_07_2019_21_57\backup_postgres_9317_fullbackup_04_07_2019_21_57_part_1.data
Extracting backup file....
Please wait extracting backup file
Please wait extracting backup file
Please wait extracting backup file
*************************************************************.\backup_info.xml
Backpup data : Sun Apr 07 21:57:23 CAT 2019
Database name : servicedesk
Total Tables : 1516
Database Server : postgres
Build Number : 9317
Backupid : 1554667043583
*************************************************************
localhost:65432 - no response
localhost:65432 - accepting connections
Active DB Server = postgres
Database connectionProp : null
Database started
Please wait ! Deleting table data in Progress..
0-----------------------50------------------------100(%)
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
===================================================
Error Tables : wordmap,wordoccurrences,errorlog,softwaremanufacturer,softwarelist,sduserprofile
0-----------------------50------------------------100(%)
Please wait ! Restoring in Progress...................
Error Tables : wordmap,wordoccurrences,errorlog,softwaremanufacturer,softwarelist,sduserprofile
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
Active DB Server = postgres
Database connectionProp : null
Database started
0-----------------------50------------------------100(%)
===========================QUERY = INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(96, 344, NULL, 377, 1339659486782, 0, 1339673886782, 1352462210584, 3245548664, N'Provision new colour printer', N'Provision a new colour printer for Ailsa.Call Pansolutions', 1, 302, NULL, 311, 301, NULL, '0', NULL, '1', 4, 301, '0', -1, '0', '0', '0', '0', 1, '0', 1352462210584, '0', '0', NULL);
Unable to restore database : Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(1, 349, NULL, 6, 1337599132307, 0, -1, 0, 0, 'Please create an account for me Active Directory', 'Please create an account for me Active Directory;User: James KatongoTitle: Assistant AccountantDept: Finance', NULL, NULL, 21, 311, 301, NULL, '0', 1337878227165, '1', 19, 1, '1', -1, '0', '0', '0', '0', 0, '0', 0, '0', '0', NULL) was aborted. Call getNextException to see the cause.
Batch entry 0 INSERT INTO WorkOrder (workorderid,requesterid,oboid,createdbyid,createdtime,respondedtime,duebytime,completedtime,timespentonreq,title,description,modeid,slaid,ciid,deptid,siteid,autoclosetime,closedbydenial,closeauthkey,isparent,templateid,serviceid,is_catalog_template,fr_duetime,haschange,hascausedbychange,hasproblem,hasdependency,surveystatus,hasdraft,resolvedtime,hasproject,isshared,workstationid) VALUES(1, 349, NULL, 6, 1337599132307, 0, -1, 0, 0, 'Please create an account for me Active Directory', 'Please create an account for me Active Directory;User: James KatongoTitle: Assistant AccountantDept: Finance', NULL, NULL, 21, 311, 301, NULL, '0', 1337878227165, '1', 19, 1, '1', -1, '0', '0', '0', '0', 0, '0', 0, '0', '0', NULL) was aborted. Call getNextException to see the cause.
localhost:65432 - accepting connections
localhost:65432 - rejecting connections
localhost:65432 - no response