Article - CS285603
"Data store unknown error" and "data_table does not exist" exception are showing after ThingWorx installation with PostgreSQL
Modified: 04-Jun-2020
Applies To
- ThingWorx Platform 8.2
- PostgreSQL database
Description
- After ThingWorx installation, the following error/exception is happening when trying to execute any service from a Stream:
- [L: ERROR] [O: E.c.t.p.p.PostgresDataExceptionTranslator] [I: ] [U: Administrator] [S: ] [T: http-nio-80-exec-8] [message: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]] org.postgresql.util.PSQLException: ERROR: relation "data_table" does not exist
- ThingWorx application logs are getting filled with this error :
- [L: ERROR] [O: c.t.p.p.PostgresDataExceptionTranslator] [I: ] [U: ] [S: ] [T: pool-10-thread-1] [message: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]]
This is a printer-friendly version of Article 285603 and may be out of date. For the latest version click CS285603