1. Home
  2. Support
Article - CS280614

[1,018 Data store unknown error:[Error occurred while accessing the model provider.]" error when creating, importing, or updating an entity in ThingWorx Platform

Modified: 25-Oct-2024   


Applies To

  • ThingWorx Platform 8.5 to 9.5
  • PostgreSQL/MSSQL

Description

  • Cannot create, update, or import entity in ThingWorx Platform
  • Entity is not findable on Composer but is committed to the database
  • Following error is displayed on Composer and logged in <ThingworxStorage>logs/ApplicationLog.log: 
    • Unable to create thing:<name>: [1,018] Data store unknown error:[Error occurred while accessing the model provider.] 
    • [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
  • Failed to delete Thing with below errors in ErrorLog.log:  
    JavaException: java.lang.Exception: Unable to delete thing: [####] Unable to dispose thing: [####] com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider
  • Following errors are logged in <ThingworxStorage>logs/ErrorLog.log: 
    • [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: <username>] [S: ] [P: ] [T: https-jsse-nio-8443-exec-3817] Error thrown creating entity = <entity_name>: Unable to create <entity_type>: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: <username>] [S: ] [P: ] [T: https-jsse-nio-8443-exec-3817] Unable to process import: Unable to create <entity_type>: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: <username>] [S: ] [P: ] [T: https-jsse-nio-8443-exec-3817] Import Failed: Unable to create group: [1,018] Data store unknown error: [Error occurred while accessing the model provider.] java.lang.Exception: Unable to create group: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
        ...
Wrapped by: java.lang.Exception: Import Failed: Unable to create group: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
        ...
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: <username>] [S: ] [P: ] [T: http-nio-8080-exec-161] [1,018] Data store unknown error: [Error occurred while accessing the model provider.] org.postgresql.util.PSQLException: ERROR: permission denied for table <table> Where: SQL statement "INSERT INTO <table> ( ... ) VALUES ( ... )"
Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
This is a printer-friendly version of Article 280614 and may be out of date. For the latest version click CS280614