• 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

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