技术文章 - CS380911
在 ThingWorx 9.3 中保存 Influx V2 持久性提供程序时出现错误“[2,000] 访问数据提供程序时发生错误”
已修改: 06-Mar-2025
适用于
- ThingWorx Platform 9.3 F000 to SP6
- InfluxDB V2
- Influx2PersistenceProviderPackage
说明
- 无法保存Influx V2 持久性提供程序 ( Influx2PersistenceProviderPackage )
- 有时需要多次尝试才能保存
- 其他症状: IsConnected 尽管提取和查询工作正常,Influx V2 Persistence Provider 上的服务仍返回false
- Influx Persistence Provider 连接不稳定,连接不断随机断开
- 使用 InfluxDB 作为持久性提供程序查询历史记录时,某些实体会出现数据访问错误
- 无法保存带有错误报告的持久性提供程序:
Unable to connect to the PersistenceProvider:xxxxx- ..\ThingworxStorage\logs\ErrorLog.log中的异常:
runtime error @4:5-4:36: distinct: schema collision: cannot group boolean and string types together[2,000] Error occurred while accessing the data provider. com.influxdb.exceptions.BadRequestException: runtime error @4:5-4:36: distinct: schema collision: cannot group boolean and string types togetherat com.influxdb.internal.AbstractRestClient.responseToError(AbstractRestClient.java:96) ...com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider. at com.thingworx.persistence.influxdb2.Influxdb2DataExceptionTranslator.rethrowTranslated(Influxdb2DataExceptionTranslator.java:34) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.checkInfluxdbConnection(Influxdb2Datasource.java:387) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.testConnectivity(Influxdb2Datasource.java:190) at com.thingworx.persistence.influxdb2.Influxdb2Datasource.testConnectivity(Influxdb2Datasource.java:209) at com.thingworx.persistence.provider.PersistenceProvider.TestConnectivity(PersistenceProvider.java:407) ...
这是文章 380911 的 PDF 版本,可能已过期。最新版本 CS380911