Error upgrading Spotlight: "Unable to start service" (4300952)

Customers report being unable to start the spotlight service, after an upgrade and later even after a clean install, showing the following error on the event viewer:

Unable to load JVM DLL [C:\Program Files\Quest Software\Diagnostic Server\agent\bin\jre11\bin\server\jvm.dll]: The specified procedure could not be found. (0x7f)”

Cause 1: The jvm.dll file cannot find its dependencies properly.

Cause 2: The Microsoft Visual C++ Redistributable is not installed.

RESOLUTION 1:

As per dev team apply the following steps:

• Stop antivirus software, uninstall Spotlight and remove \agent\bin folder. Re-install to see if the installation is successful and DS service starts successfully. If this does not work, install DS on another machine and copy files under .\agent\bin folder to the problematic host.
• If above does not resolve the issue, then copy *.dll files under .\Agent\bin\jre11\bin folder to .\Agent\bin folder and restart DS service.

The 2nd step resolved the issue in the most recent SRs and the upgrade completed successfully.

RESOLUTION 2:

• Install the SQL server client tools on the DS host, this is part of the system requirements.
• If the issue persist, reinstall the latest Microsoft Visual C++ Redistributable version, usually these come as part of the SQL server client tools, but may be reinstalled individually.