技术文章 - CS358613

全新安装后启动 ThingWorx 时出现“无法初始化和启动系统:对象名称‘root_entity_collection’无效”的错误。

已修改: 06-Nov-2025   


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

适用于

  • ThingWorx Platform 8.5 to 9.7
  • Microsoft SQL Server
  • Azure SQL Database

说明

  • 使用 ThingWorx for Azure SQL Database 和 Microsoft SQL Server (mssql) 手动安装后出现以下错误:
     [L: INFO] [O: ctppPersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Connection ThingworxPersistenceProvider, type AzuresqlPersistenceProviderPackage stopped [L: WARN] [O: ctppPersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not find persistenceProviderPackage AzuresqlPersistenceProviderPackage and thus could not stop data processing [L: ERROR] [O: ctsThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Unable to initialize and start system: Invalid object name 'root_entity_collection'. [L: ERROR] [O: ctsThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
  • 基础安装程序出现故障,但原因不明。
    • 安装过程中,ThingWorx 数据库中不会创建表。
    • 尽管连接详细信息和凭据正确,但安装过程中数据库连接并未显示。
  • 运行 Foundation 安装程序时, \ThingworxStorage\logs\ErrorLog.log显示以下错误:
     [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'system_version'. [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Problems migrating database [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: Invalid object name 'root_entity_collection'. [L: ERROR] [O: EcqlcLogger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR!
  • 运行 Foundation 安装程序时, \ThingworxStorage\logs\ApplicationLog.log显示以下错误:
     [L: ERROR] [O: ctpmMssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'system_version'. [L: ERROR] [O: ctpmMssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: ctsThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: INFO] [O: ctppPersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Connection ThingworxPersistenceProvider, type MssqlPersistenceProviderPackage stopped [L: WARN] [O: ctppPersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not find persistenceProviderPackage MssqlPersistenceProviderPackage and thus could not stop data processing [L: ERROR] [O: ctsThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: Invalid object name 'root_entity_collection'. [L: ERROR] [O: ctsThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! *** [L: INFO] [O: ctsThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] >>>>>>> PLATFORM SHUTDOWN START <<<<<<<<<
这是文章 358613 的 PDF 版本,可能已过期。最新版本 CS358613