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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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