Query Executor Tool for PostGres

Query Executor Tool for PostGres

                  This tool is designed to execute queries in the customer environment by connecting the database by reading the database configuration file.  We need to enter the query that we require to execute in queryToExecute.txt file. We can enter multiple queries separated by a new line.

Note : 
  1. This tool is only tested in the Postgres environment.
  2. This tool is not designed for executing sensitive queries in cx environment.
  3.  Please take a backup of the database before running this tool. 

How to use the Tool?
  1. Download the attached QueryExecutor.zip and extract it on the <servicedeskplus_home> directory. A folder will be created at <servicedeskplus_home>\QueryExecutor.
  2. Start the ServiceDeskPlus Application service / Database Server.
  3. Navigate into <servicedeskplus_home>\QueryExecutor folder
  4. Replace the queryToExecute.txt with the input file that you have provided.
  5. Execute run.bat or .sh in the same folder, after these steps.
  6. Stop the application server / Database Server.
Share the queryExecutor.log file generated in the <servicedeskplus_home>\QueryExecutor folder to analyse further.



                    New to ADSelfService Plus?

                      • Related Articles

                      • Remote read only access to database for Postgres customers

                        Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to allow ...
                      • How to Connect External Postgres

                        Install a External Postgres such that the version of that postgres is currently in the series of inbuilt postgres of our Application. Say for example, In Servicedeskplus Application version 14010, which has postgres version 10.21, then you should ...
                      • Upgrade failure when migrating privileges for removed functions

                        LOG Trace : 03.08.2023 12:50:36 [com.zoho.postgres.migrate.DumpMigration] [SCHWERWIEGEND] : Problem during upgrade.com.zoho.postgres.exception.MigrationFailureException: Restoration failed for PRE_DATA at ...
                      • Migration failure for Postgres Database with a blank space in it

                        Trace : \ManageEngine\ServiceDesk\Patch\AdventNet_ManageEngine_ServiceDesk_Plus-14.2.0-SP-1.0.0\SERVICEDESK\PreInstall\pg_migrate\pgsql_old\bin\pg_dumpall.exe", -U, postgres, -p, 65433, -h, 127.0.0.1, -r, -w, |, ...
                      • Upgrade Failure due to the presence of CtrlZ Failure

                        This issue (SD-118352) in fixed in version 14710. Post this release, these characters are handled in the migration itself. If you are planning to migrate from version less than 14610 to 14610, then you can directly migrate to 14710, to handle this ...