使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


What are Table Constraint errors in DataLogger?


Last Update: 2018/11/12
When Store and Forward is enabled, Store and Forward cannot recover records that fail to insert due to table constraint violations.
  • Records that fail to insert into the database table due to a table constraint will log to the data store file. All subsequent records will log to the data store file until the table constraint violations are resolved.
  • Options for table constraint violation resolution:
    • With No Data Loss
      • Remove the table constraints from the database table.
      • Change the log group to "Create a new Table once and append" to a create and log to a new table. Tables automatically created by DataLogger will not have constraints on data fields.
    • With Data Loss
      • Disable Store and Forward. DataLogger will no longer attempt to recover records in the data store file. Subsequent records that fail to insert are discarded.
A record in wide data format may contain tags values from different sources. Trigger events generated by tags from one data source may initiate a record insert before data is available from other tag sources. As such, record inserts in wide data format are inherently susceptible to table constraint violations.
Related Products
DataLogger