Apps not available in Hub after upgrade from April 2019 to April 2019 Patch 8

After an upgrade from April 2019 to April 2019 patch 8, Apps are not visible and available in Hub.

This issue is chiefly seen if patch 8 is applied ontop of specific patches:
 

April 2019 GA -> Patch 8 - OK
April 2019 Patch 1 -> Patch 8 - OK
April 2019 Patch 2 -> Patch 8 - OK
April 2019 Patch 3 -> Patch 8 - OK
April 2019 Patch 4 -> Patch 8 - NOK
April 2019 Patch 5 -> Patch 8 - NOK
April 2019 Patch 6 -> Patch 8 - NOK
April 2019 Patch 7 -> Patch 8 - NOK

June 2019 GA -> Patch 11 - OK
June 2019 Patch 10 -> Patch 11 - OK

September 2019 GA -> Patch 7 - OK
September 2019 Patch 6 -> Patch 7 - OK

November 2019 GA -> Patch 6 - OK
November 2019 Patch 5 -> Patch 6 - OK

1. Steps to follow to avoid it BEFORE applying April 2019 Patch 8:

• from Control Panel\Programs\Programs and Features go to View installed updates and check the patch number on April 2019 Patch X
• if X > 3 uninstall patch, if X <= 3 proceed to next step
• install April 2019 Patch 8

2. Steps to follow to resolver it AFTER applying April 2019 Patch 8:

• access the hub and create an empty app called CurrentMigrationHash
• stop all the services except for the database
• execute following query against QSR database:

UPDATE "Apps" SET "MigrationHash" = (SELECT "MigrationHash" FROM "Apps" WHERE "Name" = 'CurrentMigrationHash');

• start all the services, access hub and verify if all apps are visible