KNOWLEDGE BASE

Error "AqlProcessor evaluation failed" Occurs When Writing To Database


Published: 23 Mar 2022
Last Modified Date: 25 Mar 2022

Issue

The following error occurs when writing to database:
 
System error:  AqlProcessor evaluation failed:
An error occurred while replacing the data in table xxxxx. If there is an existing table, the data in that table will be deleted, but no data will be added to the existing table. Please contact the administrator.


Japanese: 
システム エラー: AqlProcessor evaluation failed:
テーブル xxxxx のデータの置換中にエラーが発生しました。
既存のテーブルがある場合は、そのテーブルのデータが削除されますが、既存のテーブルにデータは追加されません。
管理者にお問い合わせください。

The following error can be found in the log file.
[MySQL][ODBC 8.0(w) Driver][mysqld-5.6.36-log]Duplicate entry 'xxxxx' for key 'PRIMARY'

Environment

  • Tableau Prep Builder 2021.4.3
  • Windows 10

Resolution

Review the values of the primary key and delete the duplicate records before writing to database.

Cause

Primary key does not accept duplicate values.
Did this article resolve the issue?