Posts

Showing posts from August, 2023

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 RequestNotific...