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

• 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)

• There is the following error in the 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.

• There is the following error in the %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

• The following errors on attempt to execute plesk login command:

  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.

• Attempt to repair Plesk installation using "Plesk Reconfigurator" fails with the following error:

  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)

• The following command display

  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 because Windows Installer service is not running, or failed during the installation.

Resolution

1. Connect to the server 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 is running:

   PS Start-Service msiserver

5. Start up Plesk Installer and complete the upgrade

   PS plesk installer --console