検索機能を使用して 500 を上回る Kepware の知識ベース記事の中から閲覧します。結果を絞り込むか、クエリーを下部の検索フィールドに入力します。

解決策が見つからなかった場合には、当社の PTC eSupport Portal で追加資料を確認することもできます。eSupport Portal へのログインを要求された場合、My Kepware の認証情報を使用できます。My 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