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