1. Home
  2. Support
Article - CS332944

DataTable operations fail with "com.thingworx.common.exceptions.DataAccessException: [1.018] Data store unknown error" in ThingWorx

Modified: 02-Nov-2020   


Applies To

  • ThingWorx Platform 8.5

Description

  • Using AddorUpdateDataTableEntry or GetDataTableEntry fails with error
com.thingworx.common.exceptions.DataAccessException: [1.018] Data store unknown error: [Error occurred while accessing the data provider.]
  • Enabling Stack Tracing in LoggingSubsystem (see CS239982)  shows following error in ErrorLog.log
 java.lang.RuntimeException: com.thingworx.common.exceptions.DataAccessException: [1.018] Data store unknown error: [Error occurred while accessing the data provider.] org.postgresql.util.PSQLException: ERROR: Relation "data_table" does not exist
  Position: 13
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
    at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
    at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
    at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
    at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)
    at com.thingworx.persistence.common.SQLStatementUtilities.executeQuery(SQLStatementUtilities.java:90)
    at com.thingworx.persistence.postgres.dao.BasePostgresDao.executeQuery(BasePostgresDao.java:124)
    ... 18 common frames omitted
This is a printer-friendly version of Article 332944 and may be out of date. For the latest version click CS332944