Article - CS374709

InfluxDB Persistence Provider reads/writes failing with "[1,018] Data store unknown error: [Error occurred while accessing the data provider.] java.lang.NullPointerException: null" logged in ApplicationLog on ThingWorx Platform

Modified: 11-Nov-2024   


Applies To

  • ThingWorx Platform 9.3 to 9.6
  • InfluxDB

Description

  • Unable to read or write data to an InfluxDB Persistence Provider
  • Restarted ThingWorx Platform due to a maintenance activity and the Influx Persistence Provider was unable to reconnect
  • Seeing error 1018 in our ThingWorx SaaS Platform on the connection to the InfluxDB
    • No issues with the InfluxDB instance itself
  • Failed to query value stream data from InfluxDB
  • Following error messages are repeatedly logged within the ThingWorx Platform logs located in <ThingworxStorage>\logs:
    • ApplicationLog.log
      • [L: ERROR] [O: c.t.p.i.InfluxdbDataExceptionTranslator] [I: ] [U: Administrator] [S: ] [P: ] [T: TWEventProcessor-9] [1,018] Data store unknown error: [Error occurred while accessing the data provider.]
    • ErrorLog.log
      • [L: ERROR] [O: E.c.t.p.i.InfluxdbDataExceptionTranslator] [I: ] [U: SuperUser] [S: ] [P: ] [T: TWEventProcessor-5] null 
        [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: TWEventProcessor-5] [1,018] Data store unknown error: [Error occurred while accessing the data provider.] java.lang.NullPointerException: null
        	at com.thingworx.persistence.influxdb.dao.InfluxdbValueStreamDao.getEntries(InfluxdbValueStreamDao.java:226)
        	... 45 common frames omitted
        Wrapped by: com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]
        	at com.thingworx.persistence.influxdb.InfluxdbDataExceptionTranslator.rethrowTranslated(InfluxdbDataExceptionTranslator.java:34)
        	at com.thingworx.persistence.influxdb.dao.InfluxdbValueStreamDao.getEntries(InfluxdbValueStreamDao.java:239)
        	at com.thingworx.persistence.influxdb.dataprovider.InfluxdbValueStreamDataProvider.queryValueCollections(InfluxdbValueStreamDataProvider.java:204)
        	at com.thingworx.persistence.common.ValueStreamEngine.lambda$queryEntries$11(ValueStreamEngine.java:306)
        	at com.thingworx.persistence.TransactionFactory.supplyInTransaction(TransactionFactory.java:182)
        	...
This is a printer-friendly version of Article 374709 and may be out of date. For the latest version click CS374709