cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

QueryNamedPropertyHistory service giving 1018 Error

PG_CG
8-Gravel

QueryNamedPropertyHistory service giving 1018 Error

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.

ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald II
(To:PG_CG)

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

View solution in original post

3 REPLIES 3
VladimirN
24-Ruby II
(To:PG_CG)

 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.

slangley
23-Emerald II
(To:PG_CG)

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

Announcements


Top Tags