QMC and Hub are not accessible and connection to QRS Database times out after 90 seconds

Services are all started, but QMC and HUB is not accessible, run Windows Commands To Retrieve Environment Information 

The resulting list of ports is not showing port 80 or 443.
Port 4242 is stuck in TIME_WAIT status. 

The System Repository log (found in C:\ProgramData\Qlik\Sense\Log\Repository\Trace\<hostname>_System_Repository.txt) shows a connection to QRS Database timeout with the following error:

Fatal exception A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond↵↓Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.↵↓Server did not respond within the specified timeout interval.
 

Environments:

Qlik Sense Enterprise on Windows, all versions

 

Since version 2.2, there were architectural changes made to how the Qlik Sense Repository works and fixed a defect which exacerbates this change. In prior builds, the Repository Database was read from disk. Additionally, the cleanup / maintenance mechanism which was intended to work was non functional. In 2.2, the Repository Database is loaded into memory upon initialization to gain a performance edge.

As a consequence of these two changes, sometimes environment experience issues wherein the Repository Service times out upon initialization due a build up of stale data in the database. Database clean-up may be required. 

There are still a small subset of customers who simply have large amounts of information in their databases where 90 seconds is not sufficient and the above resolution should resolve their issues.

Follow below steps to troubleshoot:

• Verify that anti-virus scanning exclusions for Qlik Sense has been set up as per article Qlik Sense Folder And Files To Exclude From AntiVirus Scanning
• Run the Cleanup Database script first by following Database Cleanup Script For Qlik Sense Enterprise 2.x And 3.x
• Run Recursive Cleanup Script for June 2017 as per No Hub or QMC access after upgrade to Sense November 2017 or higher - recursive script

If the issue persists after running the Cleanup Database script, do the following on every node:

1. Stop all Qlik Sense services
2. Open Notepad and Run as Administrator (Start > notepad > Right Click > Run as Administrator)
3. In Notepad, go to File > open > go to C:\Program Files\Qlik\Sense\Repository ( this is the default location, this might be different if Qlik Sense was installed to a customized path)
   • Within the open window make sure to have "all files" selected so that you can see non .TXT files
4. Open Repository.exe.config
5. Find the row with this value:  <add key="PostgresCommandTimeout" value="90" />
6. Change the value from "90" to to a higher number that works for the specific environment. For example double the value until the issue is resolved.
   NOTE:The value 0 means unlimited and effectively disabled the timeout function. This should never be applied in a production environment.
7. Save the file
8. Start all Qlik Sense Services.