Article - CS358613
"Unable to initialize and start system: Invalid object name 'root_entity_collection'" when starting ThingWorx after fresh installation
Modified: 23-Dec-2025
Applies To
- ThingWorx Platform 8.5 to 9.7
- Microsoft SQL Server
- Azure SQL Database
Description
- Following error is received after using the manual installation for ThingWorx for Azure SQL Database and Microsoft SQL Server (mssql):
[L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Connection ThingworxPersistenceProvider, type AzuresqlPersistenceProviderPackage stopped [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not find persistenceProviderPackage AzuresqlPersistenceProviderPackage and thus could not stop data processing [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Unable to initialize and start system: Invalid object name 'root_entity_collection'. [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! *** - Foundation installer is failing with no obvious reason as to the cause
- Tables are not created in the ThingWorx database during the installation attempt
- Database connections do not appear during installation despite correct connection details and credentials
- \ThingworxStorage\logs\ErrorLog.log show the following errors when running the Foundation installer:
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'system_version'. [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Problems migrating database [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: E.c.q.l.c.Logger] [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: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! - \ThingworxStorage\logs\ApplicationLog.log show the following errors when running the Foundation installer:
[L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'system_version'. [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Invalid object name 'root_entity_collection'. [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Connection ThingworxPersistenceProvider, type MssqlPersistenceProviderPackage stopped [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not find persistenceProviderPackage MssqlPersistenceProviderPackage and thus could not stop data processing [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [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: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! *** [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] >>>>>>> PLATFORM SHUTDOWN START <<<<<<<<< - Encountering difficulties while installing ThingWorx, specifically during the deployment of the ThingWorx WAR file
This is a printer-friendly version of Article 358613 and may be out of date. For the latest version click CS358613