Article - CS361953
Update of ThingWorx to version 9.2 or 9.3 fails with error "Invalid object name 'v920upgradepermissions'"
Modified: 28-Jan-2022
Applies To
- ThingWorx Platform 9.1 to 9.3
Description
- Executing an update of ThingWorx with installer fails.
- ApplicationLog.log shows
STARTED: Copy permission to new Tables. [L: ERROR] [O: c.t.p.m.V920ExternalDBPermissionMigrator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Error in copying permissions: Invalid object name 'v920upgradepermissions'. [L: ERROR] [O: c.t.p.m.m.V920MssqlPermissionMigrator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'v920upgradepermissions'. [L: ERROR] [O: c.t.p.m.MssqlDocumentModelDriver] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] An error was encountered while executing task [Copy Permissions to new tables]. See logs for further details. [L: ERROR] [O: c.t.p.m.MssqlDocumentModelDriver] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Exception occurred on migrator execution [L: ERROR] [O: c.t.p.m.MssqlModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not create a transaction for ThingworxPersistenceProvider [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not create a transaction for ThingworxPersistenceProvider [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: Could not create a transaction for ThingworxPersistenceProvider [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 <<<<<<<<<
This is a printer-friendly version of Article 361953 and may be out of date. For the latest version click CS361953