技术文章 - CS358613
全新安装后启动 ThingWorx 时出现“无法初始化和启动系统:对象名称‘root_entity_collection’无效”的错误。
已修改: 06-Nov-2025
适用于
- 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