Upgrade or Installation of Qlik Sense fails at PostgresSQL MSI
Article Number: 000036829 | Last Modified: 2019/02/20
The Upgrade or Installation fails at installing the PostgresSQL MSI and "The specified account name is already a member of the group." in the PostgreSQL installation log.
These installation logs can be found in the temp folder of the user that ran the installer (often most easily accessed using %temp%, though that can lead into a subdirectory)
These logs all use a standard name format. Product_Version_YYYYDDMMHH24MISS.log for the main log. Then Product_Version_YYYYDDMMHH24MISS_NUM_COMPONENT.log
For example, Qlik_Sense_February_2018_20180307090246.log and Qlik_Sense_February_2018_20180307090246_009_PostgreSQL.log come from the same installation attempt.
The Qlik Sense installation log reads:
[7644:16A58][2017-07-07T15:51:11]e000: Error 0x80070643: Failed to install MSI package.
[7644:16A58][2017-07-07T15:51:11]e000: Error 0x80070643: Failed to execute MSI package.
[628C:18DBC][2017-07-07T15:51:11]e000: Error 0x80070643: Failed to configure per-machine MSI package.
[628C:18DBC][2017-07-07T15:51:11]i000: Detected failing msi: PostgreSQL
[628C:18DBC][2017-07-07T15:51:11]i319: Applied execute package: PostgreSQL, result: 0x80070643, restart: None
[628C:18DBC][2017-07-07T15:51:11]e000: Error 0x80070643: Failed to execute MSI package.
The PostgreSQL msi installation log (the filename is reads
Action 15:50:56 05 Found group name: BUILTIN\Performance Monitor Users
Action 15:50:56 09 Adding user SERVICEUSER@DOMAIN to Performance Monitor Users group
Action 15:50:56 09 System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: The specified account name is already a member of the group.
--- End of inner exception stack trace ---
at System.DirectoryServices.DirectoryEntry.Invoke(String methodName, Object args)
at Qlik.QustomActions64.DirectoryServices.AddUserToGroup(Session session)
CustomAction CA_AddUserToPerformanceMonitorGroup returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Most often this is caused by the name not having been written in an identical format in a previous installation. Such as DOMAIN\UserID and UserID@DOMAIN.
Defect reference ID QLIK-77865.
- Manually remove the service account from the group listed. This could either be the Performance Monitor Users, or Qlik Sense Service group or both have to be removed.
- Restart the installation / upgrade.