Article - CS319158
PostgreSQL schema update fails when upgrading to ThingWorx 8.4
Modified: 10-Jan-2020
Applies To
- ThingWorx Platform 8.4
- PostgreSQL
Description
- PostgreSQL update script from 8.2 to 8.3 ran successfully but update script from 8.3 to 8.4 failed with error in terminal/command prompt:
psql:./thingworx-update-model-schema-8.3-to-8.4.sql:761: ERROR: column "entity_id" contains null values
- Null values have been identified in model_index and thing_model table while updating to ThingWorx 8.4
This is a printer-friendly version of Article 319158 and may be out of date. For the latest version click CS319158