Failed to start the database
For the error "Failed to start the database",
65432 is the default port used by the bundled Postgres.
ServiceDesk Plus will attempt to start the database if Pgsql / Mysql is used. If the database is standalone, stop it from starting by updating the StartDB parameter to false in nms-service.xml found under C:\Manageengine\ServiceDesk\server\default\conf.
Common privileges required for the ServiceDesk Plus DB.
Sample traces from Serverout0.txt for the issue logging into the database.
New to ADSelfService Plus?
Port Occupied / Application Layer Starting
If the port is already occupied (as in the screenshot), prompt as in below screenshot will appear. Find application that uses the port by following the steps below, Execute, netstat -oan (This command will display list of processes and the ports ...
Unable to start the server. On an error / any of the containers(modules) are failed
Open the serverout0.txt found under [SDP-Home]\server\default\log using any text editor. Search for the word 'Exception'. See if there are any known error pertaining to the environment. The most reported are due to 'Low disk space' in the drive. For ...
How to change the database from MySQL/PostgreSQL to MSSQL
The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB. For ...
Unable to connect to the application
Checklist : Check whether the web interface is accessible from the server? Is the URL accessible? Check if there are any errors? Can you connect to the application using the server's IP address? Are there any errors when you start the application ...
Query to Pull out Login Hours
Purpose To generate the Total Login Hours per Technician. Query : select ai as "Account ID", tn as "Technician Name ( First Name )", lh as "Login hours", LONGTODATE(llt) as "Last Login Time", ln as "Login Name", domain as "Domain", email as ...