ServiceDesk Plus Upgrade Fixes

 GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pg_catalog TO sdpadmin;

changeDBPassword.bat -U postgres -p <old_password> -P Stonebraker

 

Try starting the application after the execution of the above query.

 

Perform the step below as well and send us the query output:

 

Open  CMD as an admin on your application server, navigate to <SDP-home>/pgsql/bin and execute: psql.exe -U sdpadmin -p 65432 -d servicedesk -h 127.0.0.1 

 

password: sdp@123

 

Execute the query below and share us the output

 

SELECT * FROM TableDetails where TABLE_NAME like '%DBCredentialsAudit%';

--GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA pg_catalog TO sdpadmin;

--delete from uvhvalues where pattern = 'Report_Modules:MODULE_ID:89403225' and genvalues > 100000000;

--delete from RequestNotification_Recipients where NOTIFICATIONID in (select RequestNotification_Recipients.NOTIFICATIONID from RequestNotification_Recipients left join RequestNotification on RequestNotification.NOTIFICATIONID=RequestNotification_Recipients.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null);

--delete from RequestNotificationToDesc where NOTIFICATIONID  in (select RequestNotificationToDesc.NOTIFICATIONID from RequestNotificationToDesc left join RequestNotification on RequestNotification.NOTIFICATIONID=RequestNotificationToDesc.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null);

--delete from Notify_WorkOrder where NOTIFICATIONID in (select Notify_WorkOrder.NOTIFICATIONID from Notify_WorkOrder left join RequestNotification on RequestNotification.NOTIFICATIONID=Notify_WorkOrder.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null);

--delete from WO_Tech_Info where ASSESSMENTID in (select WO_Tech_Info.ASSESSMENTID from WO_Tech_Info left join WO_Assessment on WO_Assessment.ASSESSMENTID=WO_Tech_Info.ASSESSMENTID where WO_Assessment.ASSESSMENTID is null);

--delete from WorkOrderToCharge where CHARGEID in (select WorkOrderToCharge.CHARGEID from WorkOrderToCharge left join ChargesTable on ChargesTable.CHARGEID=WorkOrderToCharge.CHARGEID where ChargesTable.CHARGEID is null);

--delete from WorkOrderHistoryDiff where HISTORYID in (select WorkOrderHistoryDiff.HISTORYID from WorkOrderHistoryDiff left join WorkOrderHistory on WorkOrderHistory.HISTORYID=WorkOrderHistoryDiff.HISTORYID where WorkOrderHistory.HISTORYID is null);

--select count(*) from RequestNotification_Recipients left join RequestNotification on RequestNotification.NOTIFICATIONID=RequestNotification_Recipients.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null;

--select count(*) from RequestNotificationToDesc left join RequestNotification on RequestNotification.NOTIFICATIONID=RequestNotificationToDesc.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null;

--select count(*) from Notify_WorkOrder left join RequestNotification on RequestNotification.NOTIFICATIONID=Notify_WorkOrder.NOTIFICATIONID where RequestNotification.NOTIFICATIONID is null;

--select count(*) from WO_Tech_Info left join WO_Assessment on WO_Assessment.ASSESSMENTID=WO_Tech_Info.ASSESSMENTID where WO_Assessment.ASSESSMENTID is null;

--select count(*) from WorkOrderToCharge left join ChargesTable on ChargesTable.CHARGEID=WorkOrderToCharge.CHARGEID where ChargesTable.CHARGEID is null;

--select count(*) from WorkOrderHistoryDiff left join WorkOrderHistory on WorkOrderHistory.HISTORYID=WorkOrderHistoryDiff.HISTORYID where WorkOrderHistory.HISTORYID is null;

 

      In case any query result is not equal to zero kindly execute the below query and try again after executing the below query. Even if the result is not zero kindly contact us.

 

      REINDEX DATABASE servicedesk;

delete from uvhvalues where pattern = 'Report_Modules:MODULE_ID:89403225' and genvalues > 100000000;