1. Home
  2. Support
Article - CS319417

"ERROR: relation "system_version" does not exist_" is seen when attempting to start ThingWorx Platform PostgreSQL deployed via ThingWorx Docker

Modified: 17-Apr-2020   


Applies To

  • ThingWorx Platform 8.5 F000 to SP5
  • ThingWorx Platform 8.4 F000 to SP9
  • ThingWorx Platform 8.3
  • Docker
  • PostgreSQL

Description

  • Cannot start ThingWorx Docker running on PostgreSQL
  • Postgres implementation of ThingWorx Docker is not starting up
  • ThingWorx Docker fails to start if TWX_DATABASE_USERNAME and TWX_DATABASE_SCHEMA do not match
  • PostgreSQL Docker of ThingWorx Platform fails to start
  • Error in <ThingworxStorage>\logs\ApplicationLog.log when starting ThingWorx Platform (on PostgreSQL) using the downloaded Dockerfile and docker-compose files
    • [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Database initialization started...
      [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] ERROR: relation "system_version" does not exist_  Position: 128
      [L: ERROR] [O: c.t.p.p.PostgresModelExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] ERROR: current transaction is aborted, commands ignored until end of transaction block
      [L: ERROR] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] ERROR: current transaction is aborted, commands ignored until end of transaction block
      [L: INFO] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Connection ThingworxPersistenceProvider, type PostgresPersistenceProviderPackage stopped
      [L: WARN] [O: c.t.p.p.PersistenceProvider] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Could not find persistenceProviderPackage PostgresPersistenceProviderPackage 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: ERROR: current transaction is aborted, commands ignored until end of transaction block
      [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** CRITICAL ERROR ON STARTUP: Unable to initialize and start system: ERROR: current transaction is aborted, commands ignored until end of transaction block
      [L: ERROR] [O: c.t.s.ThingWorxBootstrapper] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] *** Web Application STATE is being set to ERROR! ***
      [L: ERROR] [O: c.t.s.a.AuthenticationFilter] [I: ] [U: ] [S: ] [P: ] [T: http-nio-8080-exec-8] Could not handle request
  • ThingWorx Docker logs show:
    • [platform_1    |[0m java.lang.Exception: Unable to initialize and start system: ERROR: current transaction is aborted, commands ignored until end of transaction block
      [platform_1    |[0m     at com.thingworx.system.ThingWorxServer.loadModel(ThingWorxServer.java:754)
      [platform_1    |[0m     at com.thingworx.system.ThingWorxServer.doStandalone(ThingWorxServer.java:217)
      [platform_1    |[0m     at com.thingworx.system.ThingWorxBootstrapper.contextInitialized(ThingWorxBootstrapper.java:152)
      [platform_1    |[0m     at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4685)
      [platform_1    |[0m     at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5146)
                              ...
This is a printer-friendly version of Article 319417 and may be out of date. For the latest version click CS319417