Article - CS380911
Error "[2,000] Error occurred while accessing the data provider" when saving an Influx V2 Persistence Provider in ThingWorx 9.3
Modified: 06-Mar-2025
Applies To
- ThingWorx Platform 9.3 F000 to SP6
- InfluxDB V2
- Influx2PersistenceProviderPackage
Description
- Unable to Save an Influx V2 Persistence Provider (Influx2PersistenceProviderPackage)
- Save is sometimes successful after multiple attempts
- Other symptom: IsConnected service on Influx V2 Persistence Provider returns false despite working ingestion and query
- Influx Persistence Provider connection is not stable, the connection keeps dropping randomly
- When querying the history using InfluxDB as the Persistence Provider, some entities give data access errors
- Unable to save persistence provider with error reports:
Unable to connect to the PersistenceProvider:xxxxx
- Exception in ..\ThingworxStorage\logs\ErrorLog.log:
runtime error @4:5-4:36: distinct: schema collision: cannot group boolean and string types together[2,000] Error occurred while accessing the data provider. com.influxdb.exceptions.BadRequestException: runtime error @4:5-4:36: distinct: schema collision: cannot group boolean and string types togetherat com.influxdb.internal.AbstractRestClient.responseToError(AbstractRestClient.java:96) ...com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider. at com.thingworx.persistence.influxdb2.Influxdb2DataExceptionTranslator.rethrowTranslated(Influxdb2DataExceptionTranslator.java:34) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.checkInfluxdbConnection(Influxdb2Datasource.java:387) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.testConnectivity(Influxdb2Datasource.java:190) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.testConnectivity(Influxdb2Datasource.java:209) at com.thingworx.persistence.provider.PersistenceProvider.TestConnectivity(PersistenceProvider.java:407) ...
This is a printer-friendly version of Article 380911 and may be out of date. For the latest version click CS380911