You are not allowed to apply duplicated roles on the server node.

After a QlikSense upgrade you cannot access the QMC or Hub.

The repository logs says:
Qlik.Sense.Common.Exceptions.ValidationFailedException' was thrown.; ServerNodeConfiguration.entity: You are not allowed to apply duplicated roles on the server node.

The repository service reaches the "startup phase complete" step but this error is thrown during the startup phase and prevents Qlik Proxy service from starting properly.

Duplicated entries in the ServerNodeRoles table

Connect to the Repo DB using Pgadmin and look at the ServerNodeRoles table and delete the duplicated Rows.

Below is the script to run against the database to fix the issue in June 2017/September 2017/November 2017.

delete from "ServerNodeRoles" where "ID" in (select "ID" from (select "ID", "Definition", "CreatedDate", 
row_number() over(partition by "Definition" order by "CreatedDate" desc) rno from "ServerNodeRoles" where "Deleted" = false) as x where rno > 1);

The issue is fixed is the February 2018 Installer (Bug QLIK-84898), which will run the script automatically during the upgrade to correct the issue.

This is due to some duplicate rows in the repository caused by synchronized persistence issues, in 3.2 and earlier, you can run the following script to fix the issue.

delete from "ServerNodeConfigurationRoles" where "ID" in (select "ID" from (select "ID", "Definition", "CreatedDate", 
row_number() over(partition by "ServerNodeConfiguration_ID", "Definition" order by "CreatedDate" desc) rno from "ServerNodeConfigurationRoles" where "Deleted" = false) as x where rno > 1);