"There has been an error. ThingWorx Foundation installation failed. Please check the logs. The application will exit now." is seen when installing ThingWorx Platform using the Foundation Installer

• Trying to configure SSL, but not working. keystore has been created, and the port is open on the server error occurs when installing ThingWorx for Microsoft SQL Server (mssql) via installer
• Error occurs during upgrade via installer
• Installation aborting at the final stage
• ThingWorx installation using Installer fails with one of the following errors:

There has been an error. ThingWorx Foundation installation failed. Please check the logs. The application will exit now.
There has been an error. No supported version of Java detected. Please install a supported version of Java, and ensure that the Java bin directory is in the system PATH variable. For more information about the compatibility of Java and ThingWorx versions, see the ThingWorx help center.

• Error appearing in <thingworx_installation_folder>\installer_Failed_installs\ThingWorxFoundation_install.log​​​​​ or C:\Users\<username>\AppData\Local\Temp\ThingWorxFoundation_Failed_installs\ThingWorxFoundation_install.log:

Error running <chef>\bin\chef-client -z --config "<thingworx_installation_folder>\installer\foundation\knife.rb" -j "<thingworx_installation_folder>\installer\foundation.json" -L "<thingworx_installation_folder>\installer\logs\foundation-YYYYMMDDhhmmss.log": Program ended with an error exit code

Unknown error while running ***unknown variable ccif.dir.openssl.runnable***openssl req -config ***unknown variable ccif.dir.openssl.config***openssl.cnf -newkey rsa:2048 -new -nodes -x509 -days 3650 -keyout key.pem  -out cert.pem   -subj "/C=US/ST=New COUNTRY/L=SOMEWHERE /O=.../OU=.../CN=.../emailAddress=..."
Failed to configure installation Runtime
Step install via chef script failed  :: 1
Abort Foundation component
CCIF Services functions: stop ThingWorx-Foundation
Setting variable service_pid from sc queryex "ThingWorx-Foundation" | findstr PID
Script exit code: 1

ERROR: Exception handlers complete
Cinc Client failed. 30 resources updated in 25 seconds
FATAL: Stacktrace dumped to <Thingworx installer>/foundation/local-mode-cache/cache/cinc-stacktrace.out
FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
FATAL: Mixlib::ShellOut::ShellCommandFailed: twx_keystore_secret[encrypt_db_password] (twx_foundation::database line 47) had an error: Mixlib::ShellOut::ShellCommandFailed: execute[secret ] (<Thingworx installer>/foundation/local-mode-cache/cache/cookbooks/twx_keystore/resources/secret.rb line 36) had an error: Mixlib::ShellOut::ShellCommandFailed: Command execution failed. STDOUT/STDERR suppressed for sensitive resource

• Installer fails with following error in foundation-XXXXXXXXXX.log:

FATAL: Mixlib::ShellOut::ShellCommandFailed: twx_keystore_secret[encrypt_db_password] (twx_foundation::database line 47) had an error: Mixlib::ShellOut::ShellCommandFailed: execute[secret ] (<Thingworx installer>/foundation/local-mode-cache/cache/cookbooks/twx_keystore/resources/secret.rb line 36) had an error: Mixlib::ShellOut::ShellCommandFailed: Command execution failed. STDOUT/STDERR suppressed for sensitive resource

• Installer fails with following error in ThingWorxFoundation_installer.log:

Error running cinc-client -z --config "<twx_installation_path>\installer\foundation\knife.rb" -j "<twx_installation_path>\installer\foundation.json" -L "<twx_installation_path>\installer\logs\foundation-XXXXXX.log": Program ended with an error exit code

• Installer fails with following error in foundation-YYYYYYY Installer log file:- 

  The JAVA_HOME environment variable is not defined correctly
  This environment variable is needed to run this program;
  NB: JAVA_HOME should point to a JDK not a JRE

• Installer fails with following error in ThingWorxFoundation_installer.log

  Error running S:\Thingworx_9.7.1\Foundation/installer/functions_files/json/read_json "-configfile=S:\Thingworx_9.7.1\Foundation/ThingworxPlatform/platform-settings.json" "-jsonpath=PlatformSettingsConfig.LicensingConnectionSettings.timeout": YY/MM/DD HH:MM:SS PlatformSettingsConfig.LicensingConnectionSettings.timeout does not exist
  Wait 560s for /\[[^\]]+Thingworx.war\][^\n]*\[[^\]]+\]/ in "S:\Thingworx_9.7.1\Foundation\tomcat\current\logs\thingworx-foundation-stderr.2025-07-23.log"
  waiting 5s
  waiting 5s

• Trying to install ThingWorx instance with MSSQL but it is failing