Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
kikiram
Contributor II
Contributor II

Issue during Rim node silent installation

I have configured Qlik central node using silent installation method, now trying to install Rim node using silent installer and ending up with error
==================================
TestReachability: Testing connection using Host: EXXXXXXXXXX, Port: 4432, Username: qliksenserepository, SSL Mode: False, Database name: QSR.
ConnectionTester - TestReachability failed. The database: QSR could not be reached. No such host is known. Exception:
Connection failed with reason: The database could not be reached: No such host is known.. Retrying with SSL Mode...
ConnectionTester - TestReachability failed. The database: QSR could not be reached. No such host is known. Exception:
Tried to connect with SSL but connection failed with reason: The database could not be reached: No such host is known..
Error in Shared Persistence configuration: Error when connecting to the QSR database: The database could not be reached: No such host is known.
Silent Sense Root workflow: Exception in silent workflow. There may be more info above.
ExitActivity: Exiting workflows.
About to quit this session (with exit code -18).
Shutting down, exit code: 0xffffffee
BootstrapperApp Run done.
Variable: ADDLOCAL = ALL
========================================

spc.cfg in central node
========================================
<?xml version="1.0"?>
<SharedPersistenceConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<DbUserName>qliksenserepository</DbUserName>
<DbUserPassword>xxxxx</DbUserPassword>
<DbHost>localhost</DbHost>
<DbPort>4432</DbPort>
<RootDir>\\localhost\qlikshare</RootDir>
<StaticContentRootDir>\\localhost\qlikshare\StaticContent</StaticContentRootDir>
<ArchivedLogsDir>\\localhost\qlikshare\ArchivedLogs</ArchivedLogsDir>
<AppsDir>\\localhost\qlikshare\Apps</AppsDir>
<CreateCluster>true</CreateCluster>
<InstallLocalDb>true</InstallLocalDb>
<ConfigureDbListener>true</ConfigureDbListener>
<!--ListenAddresses>*</ListenAddresses>-->
<IpRange>x.x.x.x/25</IpRange>
<MaxConnections>100</MaxConnections>
<!--<JoinCluster>true</JoinCluster>-->
<HttpPortNumber>80</HttpPortNumber>
<HttpsPortNumber>443</HttpsPortNumber>
<EnableHttpPort>false</EnableHttpPort>
<DbMaximumConnectionPoolSize>90</DbMaximumConnectionPoolSize>
</SharedPersistenceConfiguration>
=======================================

 

spc.cfg in rim node

======================================

<?xml version="1.0"?>
<SharedPersistenceConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<DbUserName>qliksenserepository</DbUserName>
<DbUserPassword>xxxxxxxxx</DbUserPassword>
<DbHost>centralnodeHostName</DbHost>
<DbPort>4432</DbPort>
<RootDir>\\centralnodeHostName\qlikshare</RootDir>
<StaticContentRootDir>\\centralnodeHostName\qlikshare\StaticContent</StaticContentRootDir>
<ArchivedLogsDir>\\centralnodeHostName\qlikshare\ArchivedLogs</ArchivedLogsDir>
<AppsDir>\\centralnodeHostName\qlikshare\Apps</AppsDir>
<InstallLocalDb>false</InstallLocalDb>
<IpRange>x.x.x.x/24</IpRange>
<MaxConnections>100</MaxConnections>
<JoinCluster>true</JoinCluster>
<HttpPortNumber>80</HttpPortNumber>
<HttpsPortNumber>443</HttpsPortNumber>
<EnableHttpPort>false</EnableHttpPort>
<DbMaximumConnectionPoolSize>90</DbMaximumConnectionPoolSize>
</SharedPersistenceConfiguration>

Labels (1)
1 Reply
Rakesh_HB
Support
Support

Hi @kikiram 

  • In the spc.cfg in central node, you have written "localhost"; it should be the Central server name or the shared UNC path name. Please reverify.
    <RootDir>\\localhost\qlikshare</RootDir>
    <StaticContentRootDir>\\localhost\qlikshare\StaticContent</StaticContentRootDir>
    <ArchivedLogsDir>\\localhost\qlikshare\ArchivedLogs</ArchivedLogsDir>
    <AppsDir>\\localhost\qlikshare\Apps</AppsDir>

 

  • In the spc.cfg in rim node,
    <DbHost>centralnodeHostName</DbHost>
    I assume that you have replaced the above value to actual Central host name
  • Test database access manually using psql or another client from rim to central on port 4432.
    Ensure port 4432 is open bidirectionally between the rim and the central.
  • Check that the network share \\<centralnodeHostName>\qlikshare is accessible from the rim node by UNC path.
  • Verify DNS or edit the hosts file as a workaround.
  • Restart the rim node installation after making these corrections.
Rakesh HB