“Duplicate Entry” Error When Upgrading Transact to 2019.1 or Above


When upgrading Ephesoft Transact to version 2019.1 or above, installation may stop and give an error. Transact will roll back to the current installation version.

In the Transact installation log, you may see the following error message:

[ERROR] Exception occur while executng script in database.MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry for key 'Unique_ppdt'

at MySql.Data.MySqlClient.MySqlStream.ReadPacket()

at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)

at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)

at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)

at MySql.Data.MySqlClient.MySqlDataReader.NextResult()

at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)

at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()

at MySql.Data.MySqlClient.MySqlScript.Execute()

at MyCustumAction.DBHelper.ExecuteMariaDBSQLScriptFile(String server, String port, String userId, String password, String database, String sqlFile)

at MyCustumAction.CustomActions.ExecuteMariaDBScript(Session session)

7/22/2021 1:22:53 PM : [ERROR] Current installation will be rollback.

The error message above reports that a database table has unwanted duplicate entries.

Proposed Solution

To resolve this issue, check the table named pages_per_date in the Report database.  Review the table and clear out the duplicates. Then, restart the upgrade.

If this does not resolve the issue, please contact Ephesoft support.