ThingWorx Platform 升级失败后，基础日志中出现“(twx_foundation::database line 65) 出现错误：Mixlib::ShellOut::ShellCommandFailed”

• 无法使用安装程序升级 ThingWorx 平台
• 无法使用升级实用程序更新 ThingWorx 平台
• 使用安装程序更新 ThingWorx Platform 失败
• 由于安装程序中的脚本失败，ThingWorx Platform 的 MS SQL 升级失败
• 基金会日志文件显示

  FATAL: Mixlib::ShellOut::ShellCommandFailed

  
  
• 按照安装程序升级帮助中心升级 ThingWorx Platform 但失败
• 无法使用安装程序升级 ThingWorx Platform 的 Microsoft SQL Server 版本
• 在 Program Files (x86) 下安装了 ThingWorx Platform，但无法完成升级
  • 安装在没有空格的目录位置的 ThingWorx Platform 实例按预期工作
• ThingWorx Platform 升级失败后，在<ThingWorxFoundation>/installer/logs/foundation-<date>.log文件中看到以下错误

INFO: Processing execute[<ThingWorx Install Location>/thingworx/update/update_mssql.ps1] action run (twx_foundation::database line 65)
INFO: Running queued delayed notifications before re-raising exception
ERROR: Running exception handlers
ERROR: Exception handlers complete
FATAL: Stacktrace dumped to <ThingWorx Install Location>/installer/foundation/local-mode-cache/cache/chef-stacktrace.out
FATAL: Please provide the contents of the stacktrace.out file if you file a bug report
FATAL: Mixlib::ShellOut::ShellCommandFailed: execute[<ThingWorx Install Location>/thingworx/update/update_mssql.ps1] (twx_foundation::database line 65) had an error: Mixlib::ShellOut::ShellCommandFailed: Command execution failed. STDOUT/STDERR suppressed for sensitive resource

• 或者对于 PostgreSQL 数据库

  * execute[C:\PROGRA~2\THINGW~1/thingworx/update/update_postgres.ps1] action  INFO: Processing execute[C:\PROGRA~2\THINGW~1/thingworx/update/update_postgres.ps1] action run (twx_foundation::database line 65)

    
    ================================================================================
    [31mError executing action `run` on resource 'execute[C:\PROGRA~2\THINGW~1/thingworx/update/update_postgres.ps1]'
    ================================================================================
    
    Mixlib::ShellOut::ShellCommandFailed

• 将 <ThingWorxFoundation>\installer\foundation\cookbooks\twx_foundation\recipes\database.rb中的敏感标志设置为false 后，以下消息也会记录在<ThingWorxFoundation>/installer/logs/foundation-<date>.log中

  • ---- Begin output of powershell  G:\Program Files (x86)\ThingWorxFoundation/thingworx/update/update_mssql.ps1 -h <host> -p 1433 -d Thingworx_Redo -u Twadmin --update_all -y < nul ----
    STDOUT:
    STDERR: x86 : The term 'x86' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the
    
    spelling of the name, or if a path was included, verify that the path is correct and try again.
    
    At line:1 char:19