Article - CS374811

Influx V2 (Influx2PersistenceProviderPackage) query fails when start and end date are the same or end date comes before start date in ThingWorx

Modified: 27-Jan-2023   


Applies To

  • ThingWorx Platform 9.3

Description

  • Influx V2 query fails when start and end date are the same or end date comes before start date when using Influx2PersistenceProviderPackage
  • Query*PropertyHistory fails when startDate=endDate after upgrading to Influx2
  • Query service Exception:
com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider.
Underlying Influx Exception in ErrorLog:
com.influxdb.exceptions.BadRequestException: error in building plan while starting program: cannot query an empty range
This is a printer-friendly version of Article 374811 and may be out of date. For the latest version click CS374811