Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Qlik Sense upgrade or rim node migration fails "could not connect to server: connection refused" in installation log
Article Number: 000077732 | Last Modified: 2019/10/08Description
A Qlik Sense Central Node was successfully upgraded or migrated, but the rim node upgrade or migration fails.
Reviewing the Qlik Sense installation logs shows error could not connect to server: connection refused.
See How to read the installation logs for Qlik products on how to locate and read the Qlik Sense installation logs.
Example:
Reviewing the Qlik Sense installation logs shows error could not connect to server: connection refused.
See How to read the installation logs for Qlik products on how to locate and read the Qlik Sense installation logs.
Example:
CAQuietExec: Creating schema 'precedents_service'.
CAQuietExec: Error executing database command "SELECT 1 FROM information_schema.schemata
CAQuietExec: WHERE schema_name = 'precedents_service'": psql: could not connect to server:
CAQuietExec: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on host "SERVERNAME" (10.10.10.10) and accepting TCP/IP connections on port 4432?
CAQuietExec: At C:\Program Files\Qlik\Sense\PrecedentsService\install\install-utils\Postgres.ps1:104 char:9
CAQuietExec: + throw "Error executing database command
CAQuietExec: + CategoryInfo : OperationStopped: (:) , Exception
CAQuietExec: + FullyQualifiedErrorId : Error executing database command "SELECT 1 FROM
CAQuietExec: information_schema.schemata WHERE schema_name = 'precedents_service'": psql: could not connect to server: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on host "SERVERNAME" (10.10.10.10) and accepting TCP/IP connections on port 4432?
CAQuietExec: Running upgrade scenario..
CAQuietExec: Creating database schema for database 'QSMQ'
CAQuietExec: System.Exception: Error executing database command "SELECT 1 FROM pg_class WHERE relname = 'versionhistory';": psql: could not connect to server: Connection refused (0x0000274D/10061)
CAQuietExec: Is the server running on host "SERVERNAME" (10.10.10.10) and accepting
CAQuietExec: TCP/IP connections on port 4432?
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)
Cause
After having migrated the Central server, it's absolutely necessary to have the Central node up and running otherwise the Rim server won't be able to migrate because it won't be able to contact the Central server.
Resolution
- Verify that all required ports are available between the Rim node and central node (see the Qlik Sense Online Help for updated port lists for your version)
- Verify that the Qlik Sense Database is up and running (on the Central Node if upgrading a Rim node)
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us