Plesk is not accessible after faulty upgrade: Unable check file existence: Unable to convert a string to SID: (1337) The security ID structure is invalid

Symptoms

1. Plesk is not accessible after an upgrade, it shows 500 error, or blank page:

   CONFIG_TEXT: ERROR: Exception: Unable check file existence: Unable to convert a string to SID: (1337) The security ID structure is invalid.<br> at Plesk impersonation(PipeServer::ServerThread::sid line 798)<br> at (zif_plesk_internal_file_exists line 1506)
   
   Additionally, an exception has occurred while trying to report this error: Zend_Exception
   No entry is registered for key 'translate' (functions.php:1785)

2. Error in C:\ParallelsInstaller\autoinstaller3.log file:

   CONFIG_TEXT: MSI (04): DEBUG: Error 2203: Database: C:\Windows\Installer\inprogressinstallinfo.ipi. Cannot open database file. System error -2147287035
   MSI: Error! The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2203.

3. Error in  %plesk_dir%admin\logs\php_error.log file:

   CONFIG_TEXT: PHP Fatal error:  Uncaught Error: Class 'Zend_Log' not found in C:\Program Files (x86)\Parallels\Plesk\admin\plib\Plesk\Log.php:169

4. Cannot generate login link:

   C:\> plesk login
   exit status 255

   OR

   C:\> plesk login
   Unable check file existence: Unable to convert a string to SID: (1337) The security ID structure is invalid.

5. Cannot repair Plesk installation using "Plesk Reconfigurator":

   CONFIG_TEXT: The system cannot find the file specified. (Error code 2) at RegQueryValueEx valueName=PLESK_DATABASE_PASSWORD
   at (registry::get line 176)
   at Pipe channel(vpipechannel::onConnected line 120)
   at getPassword('PLESK_DATABASE_PASSWORD')(PleskSrvClient::getPassword line 245)
   at (psaobsolete::PSAMySQLDatabase::open line 136)

6. Plesk configuration cannot be retrieved from system registry:

   C:\> reg query "HKLM\SOFTWARE\WOW6432Node\PLESK\PSA Config\Config" /v PLESK_DATABASE_PASSWORD
   
   ERROR: The system was unable to find the specified registry key or value.

Cause

Incomplete Plesk upgrade due to Windows Installer service not running or failed during the installation.

Resolution

1. Connect to Plesk via RDP

2. Start Windows PowerShell by clicking on Win + R and typing powershell.exe into the Run window

3. Using Windows PowerShell, copy the PLESK_DATABASE_PASSWORD property from the same-valued property pwd:

   PS [byte[]]$password = (Get-ItemProperty -Path "HKLM:\SOFTWARE\WOW6432Node\PLESK\PSA Config\Config" -Name pwd).pwd
   PS New-ItemProperty -Path "HKLM:\SOFTWARE\WOW6432Node\PLESK\PSA Config\Config" -Name "PLESK_DATABASE_PASSWORD" -PropertyType Binary -Value $password

4. Start up Windows Installer service:

   PS Start-Service msiserver

5. Start up Plesk Installer and complete the upgrade:

   PS plesk installer --console