QueryNamedPropertyHistory service giving 1018 Error

Question

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.

slangley · Accepted Answer

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

VladimirN · Answer

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded