1. 主页
  2. 支持
技术文章 - CS398758

ThingWorx 升级失败，并显示“在资源‘execute[运行数据库脚本的升级路径安装程序：”XXXX/thingworx/update/update_postgres.sh“]上执行操作‘run’时出错”

已修改: 02-Oct-2025   


注意：本文已使用机器翻译软件翻译，以方便非英语客户阅读。但翻译内容可能包含语法错误或不准确之处。请注意， PTC对本文所含信息的翻译准确性及使用后果不承担任何责任。请在 此处 查看本文的英文原始版本以便参考。有关机器翻译的更多详情，请单击 此处 。
感谢您告诉我们。我们将尽快审阅此译文。

适用于

  • ThingWorx Platform 9.0 to 9.7

说明

  • ThingWorx 升级失败， foundation-xxxx.log中出现以下错误
- execute the ruby block Retrieve DB passowrd
  * execute[upgrade path installer running db scripts: "/XXXX/ThingWorxFoundation/thingworx/update/update_postgres.sh"] action run[2023-08-09T21:17:18+05:30] INFO: Processing execute[upgrade path installer running db scripts: "/XXXX/ThingWorxFoundation/thingworx/update/update_postgres.sh"] action run (twx_foundation::database line 76)

    
    ================================================================================
    Error executing action `run` on resource 'execute[upgrade path installer running db scripts: "/XXXX/ThingWorxFoundation/thingworx/update/update_postgres.sh"]'
    ================================================================================
    
    Mixlib::ShellOut::ShellCommandFailed
    ------------------------------------
    Command execution failed. STDOUT/STDERR suppressed for sensitive resource
  • 尝试执行 ThingWorx Foundation 的就地升级反复失败，并在foundation-xxxx.log中出现以下错误： 
     [31mError executing action `run` on resource 'execute[upgrade path installer running db scripts: "<Thingworx_Home>/thingworx/update/update_mssql.ps1"]'
  • 即使禁用单点登录 (SSO) 并遵循所有先决条件后，问题仍然存在
  • ThingWorxFoundation_upgrade.log或bitrock_xxx.log报告以下消息： 
Script stderr:
 child process exited abnormally

Error running cinc-client -z --config "/XXXX/ThingWorxFoundation/installer/foundation/knife.rb" -j "/XXXX/ThingWorxFoundation/installer/foundation.json" -L "/XXXX/ThingWorxFoundation/installer/logs/foundation-ZZZZ.log": child process exited abnormally
  • ThingWorx 安装程序 UI 报告错误： 
Error: The upgrade was not successful.  The installer attempted to roll back changes to your file system, but database changes could not be rolled back.  You may need to restore your database from your manual backup.  Before running the upgrade installer again, check the installer logs to see why this upgrade attempt failed.
  • 安装程序在Windows环境下调用powershell命令： 
powershell .\update_postgres.ps1 -h 192.168.11.3 -p 5432 -d thingworx -s public -u twadmin --update_all -y
  • 返回错误： 
     update_postgres.ps1 : The term 'update_postgres.ps1' 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:1 + update_postgres.ps1 -h 192.168.11.3 -p 5432 -d thingworx -s public -u ... + ~~~~~~~~~~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (update_postgres.ps1:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException

这是文章 398758 的 PDF 版本，可能已过期。最新版本 CS398758