1. Home
  2. Support
Article - CS320312

ThingWorx upgrade from 8.4 fails with error "ERROR: column "groupId" does not exist_ Position: 62"

Modified: 07-May-2021   


Applies To

  • ThingWorx Platform 8.5 to 9.1

Description

  • ThingWorx Platform will not start following upgrade
  • Cannot access the Platform after upgrade to 8.5 or 9.x
  • Deploying the new 8.5 Thingworx.war file results in database error
  • groupID column is missing after ThingWorx Platform upgrade
  • <ThingworxStorage>\logs\ApplicationLog.log shows:
    • <Date Time> [L: ERROR] [O: c.t.p.p.PostgresDataExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] ERROR: column "groupId" does not exist_  Position: 62
      <Date Time> [L: ERROR] [O: c.t.s.m.BaseManager] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Unable to load collection [Projects] : ERROR: column "groupId" does not exist_  Position: 62
      <Date Time> [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] ERROR: current transaction is aborted, commands ignored until end of transaction block
      ...
      <Date Time> [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] ThingPackage className is invalid
      <Date Time> [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
      <Date Time> [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage and thus could not stop data processing
      <Date Time> [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] Unable to initialize and start system: ThingPackage className is invalid
      <Date Time> [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: ThingPackage className is invalid
      <Date Time> [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: localhost-startStop-1] *** Web Application STATE is being set to ERROR! ***
  • PostgreSQL logs show the following:
    • <Date Time>: user=<Database User>,db=<Database Name>,app=PostgreSQL JDBC Driver,client=<Database Host> ERROR:  column "groupId" does not exist at character 62
      <Date Time>: user=<Database User>,db=<Database Name>,app=PostgreSQL JDBC Driver,client=<Database Host> STATEMENT:  select "owner" ,"visibilityPermissions" ,"lastModifiedDate" ,"groupId" ,"designTimePermissions" ,"minPlatformVersion" ,"description" ,"configurationChanges" ,"homeMashup" ,"className" ,"avatar" ,"type" ,"version" ,"tags" ,"publishResult" ,"runTimePermissions" ,"documentationContent" ,"tenantId" ,"name" ,"configurationTableDefinitions" ,"artifactId" ,"state" ,"projectName" ,"configurationTables",aspect_model.key, aspect_model.value, Project_model.entity_id from Project_model left join aspect_model on Project_model.type = aspect_model.entity_type and Project_model.name = aspect_model.entity_name order by Project_model.entity_id
This is a printer-friendly version of Article 320312 and may be out of date. For the latest version click CS320312