Qlik Sense Enterprise on Windows fails to install or upgrade with the below error:
CAQuietExec: Creating database schema for database 'QSMQ'
CAQuietExec: System.Exception: Error executing database command "SELECT 1 FROM pg_class WHERE relname = 'versionhistory';": psql: connection to server failed: Connection refused (0x0000274D / 10061)
CAQuietExec: Verifies that the server at "localhost" (:: 1) is running
CAQuietExec: and that accepts TCP / IP connections on port 4432
CAQuietExec: Connection to server failed: Connection refused (0x0000274D / 10061)
CAQuietExec: Verifies that the server at "localhost" (127.0.0.1) is running
CAQuietExec: and that accepts TCP / IP connections on port 4432
CAQuietExec:
CAQuietExec: Error 0x80070002: Command line returned an error.
CAQuietExec: Error 0x80070002: QuietExec Failed
CAQuietExec: Error 0x80070002: Failed in ExecCommon method
CustomAction CA_UpgradeQSMQ returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
MSI (s) (10:F4) [16:40:55:606]: Note: 1: 2265 2: 3: -2147287035
MSI (s) (10:F4) [16:40:55:607]: User policy value 'DisableRollback' is 0
MSI (s) (10:F4) [16:40:55:607]: Machine policy value 'DisableRollback' is 0
Action ended 16.40.55: InstallFinalize. Return value 3.
For information on how to retrieve and read install logs, see How to read the installation logs for Qlik products
Considerations:
- Service Account is available in the local administrator group.
- No Antivirus installed/active
- No security application is installed/active
- The .NET framework is already updated to a recent version.
- Microsoft Visual C++ **** Redistributable (64 and 32 bit both) already updated to a recent version.
Environment
Resolution
- Check that the windows firewall isn't blocking the Qlik Sense Ports.
- Below line in the logs also expects that the server is running in IPV6
Verifies that the server at "localhost" (:: 1) is running
- So, try enabling IPV6 in your server
- If any customized port is used on Postgres other than 4432, this customized port needs to be specified while installing/upgrading the Qlik Sense
Cause
- A customized Database port is used
- Qlik Sense Ports are not listening
- IPV6 is disabled on the server
Related Content
Qlik Sense Installation or Upgrade fails with Error 0x80072ee7
Qlik Sense Desktop or Server Install Fails - Failed to Install MSI Package
Qlik Sense Server install or upgrade fails with "Add-Type : Cannot add type. Definition of new types...
