Please I need assistance. I am trying to re-install Qlik Sense windows enterprise on a Windows Server 2019 after some other users on the servers upgraded the postgres to version 18.
I decided to carry out a fresh installation by uninstalling postgres 18, the Qlik Sense windows enterprise May 2024 and deleted any folder related to Qlik Sense and restarting the server as well, but encountering errors for a fresh installation.
Please could you point me what I might be missing that may cause the failure?
I have attached the log files for the setup failure encountered.
We took a look and found what looks to be the first error in the chain, which points at a problem connecting to the database. That may indicate that you are using the wrong port or the new DB you have installed for your fresh install may have applied settings from the previously installed Postgre 18 install (leading to the wrong port, etc).
Look into the DB as the root cause.
If you are unable to find a solution, please log a case with us.
Error:
CAQuietExec: WARNING: Skiping the database initialization. No superuser or password specified. CAQuietExec: Creating schema 'dataprep_service'. CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema_name = 'dataprep_service'": CAQuietExec: psql: error: connection to server at "SERVERNAME" (IP), port 4432 failed: Connection timed out CAQuietExec: (0x0000274C/10060) CAQuietExec: Is the server running on that host and accepting TCP/IP connections? CAQuietExec: connection to server at "SERVERNAME" (IP), port 4432 failed: Connection timed out CAQuietExec: (0x0000274C/10060) CAQuietExec: Is the server running on that host and accepting TCP/IP connections? CAQuietExec: At C:\Program Files\Qlik\Sense\DataPrepService\install\install-utils\Postgres.ps1:109 char:9 CAQuietExec: + throw "Error executing database command "" ... CAQuietExec: + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM information_schema.schemata WHERE schema CAQuietExec: _name = 'dataprep_service'": psql: error: connection to server at "SERVERNAME" (IP), port 44 CAQuietExec: 32 failed: Connection timed out (0x0000274C/10060) CAQuietExec: Is the server running on that host and accepting TCP/IP connections? CAQuietExec: connection to server at "SERVERNAME" (IP), port 4432 failed: Connection timed out (0x0000274 CAQuietExec: C/10060) CAQuietExec: Is the server running on that host and accepting TCP/IP connections? CAQuietExec: CAQuietExec: Error 0x80070001: Command line returned an error. CAQuietExec: Error 0x80070001: QuietExec Failed CAQuietExec: Error 0x80070001: Failed in ExecCommon method
Don't forget to Like posts and use the "Accept as Solution" button on content that answered your question! Thanks 🙂
I was looking at this side Qlik Sense of the error log in the temp folder only and notice below thinking it was the service dispatcher that was installing successfully.
I would focus on postgres. I am assuming that process of installing postgres 18 wasn't fully done. There is a whole procedure off uninstalling previous versions and services and making sure that all those steps were done would be critical. If it wasn't done it is possible that despite uninstalling postgres 18 there are still binaries of postgres 12 or 14 or other (depending on how old your server was) and not clearing everything out will lead to errors like yours.
I know this is not direct solution to your problem but make sure you dont have any old postgres leftovers by checking steps from that link.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
