Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X
On starting ThingWorx and InfluxDB instance simultaneously QueryNamedPropertyHistory service is giving below error:
Execution error in service script [QueryNamedPropertyHistory] :: com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]
After running the ConnectDataSource service in the Persistence Provider configured to connect with InfluxDB the issue gets resolved. But with every instance start, the issue is reoccurring. Also if the InfluxDb instance is started ahead of ThingWorx this issue does not occur.
Has anyone faced a similar issue?
Any inputs would be very helpful.
Solved! Go to Solution.
Hi @PG_CG.
The process for restarts requires that InfluxDB be up before starting ThingWorx. Not sure why TestConnectivity is showing true if there is no connection.
Regards.
--Sharon
Hi,
Read the following articles:
Similar question before:
@VladimirN Thank you for the references. But actually, we have gone through all of them nothing helped. We are now following the sequence of starting the influxdb instance before ThingWorx to avoid the occurrence of this issue.
It would be helpful if someone can suggest a service to check if Persistence Provider is connected to DB. We have tried TestConnectivity and IsConnected but they always return true.
Hi @PG_CG.
The process for restarts requires that InfluxDB be up before starting ThingWorx. Not sure why TestConnectivity is showing true if there is no connection.
Regards.
--Sharon