QueryNamedPropertyHistory service giving 1018 Error

[PG_CG]

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.

[VladimirN]

 Hi,

Read the following articles:

• "Repeated error in ThingWorx Application log "Data store unknown error: [Error occurred while accessing the model provider.]]"": https://www.ptc.com/en/support/article/CS281176 
• ""Unable to add data table entry because com.thingworx.common.exceptions.DataAccessException" error observed in Application Logs in ThingWorx": https://www.ptc.com/en/support/article/CS328839 
• ""Unable to create thing:<name>:[1,018 Data store unknown error:[Error occurred while accessing the model provider.]" error wh en create new thing via service with previously deleted thing's name in ThingWorx": https://www.ptc.com/en/support/article/CS280614
• "How to troubleshoot Error code [1,018] and [2,000] appear in ApplicationLog in ThingWorx Platform": https://www.ptc.com/en/support/article/CS354460 
• "Error "Data store unknown" when trying to add datatable entry with string larger than 64 characters in ThingWorx Platform": https://www.ptc.com/en/support/article/CS363463 
• "ThingWorx not able to connect to Influx database": https://www.ptc.com/en/support/article/CS316869 

Similar question before:

• "Getting Data store unknown error": https://community.ptc.com/t5/ThingWorx-Developers/Getting-Data-store-unknown-error/td-p/502207 
• "[1,018] Data store unknown error: [Error occurred while accessing the model provider. ?": https://community.ptc.com/t5/ThingWorx-Developers/1-018-Data-store-unknown-error-Error-occurred-while-accessing/td-p/626275 

[PG_CG]

@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 · Accepted 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