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 together
    at 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