Article - CS239982
ThingWorx fails to persist updates and returns error "Error occurred while accessing the data provider"
Modified: 08-Jun-2022
Applies To
- ThingWorx Platform 7.0 to 9.3
Description
- Error occurred while accessing the data provider error message returned in ThingworxStorage/logs/ApplicationLog.log when running a custom service in ThingWorx
- Updates in ThingWorx are failing following migration/upgrade
- Error when running DataTable service AddDataTableEntries in ThingworxStorage/logs/ApplicationLog.log:
Unable to Invoke Service AddDataTableEntries on <DataTableName>: com.tingworx.common.exceptions.DataAccessException:[1,018] Data store unknown error: [Error occurred while accessing the data provider.]
- ThingWorx server was briefly inoperable due to error in ThingworxStorage/logs/ApplicationLog.log:
[message: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]] Transactions could not be committed.
- ThingWorx is experiencing hundreds of database deadlocks per day
- ThingworxStorage/logs/ErrorLog.log show that deadlocks are generated primarily on the model_index_pkey index:
com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction
- Restarting Tomcat temporarily resolves the model provider issue
This is a PDF version of Article CS239982 and may be out of date. For the latest version click https://www.ptc.com/en/support/article/CS239982?&posno=1&q=Data store unknown error%3A %5BError occurred while accessing the data provider.&DocumentType=Article&source=search