{"id":49910,"date":"2021-11-18T09:36:30","date_gmt":"2021-11-18T16:36:30","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/?p=49910"},"modified":"2022-04-01T09:15:35","modified_gmt":"2022-04-01T16:15:35","slug":"kb00026568-installation-issue-on-transact-upgrade-to-2019-1-and-above","status":"publish","type":"post","link":"https:\/\/ephesoft.com\/docs\/kb00026568-installation-issue-on-transact-upgrade-to-2019-1-and-above\/","title":{"rendered":"“Duplicate Entry” Error When Upgrading Transact to 2019.1 or Above"},"content":{"rendered":"
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.<\/span><\/p>\n In the Transact installation log, you may see the following error message:<\/span><\/p>\n The error message above reports that a database table has unwanted duplicate entries.<\/span><\/p>\n To resolve this issue, check the table named pages_per_date<\/strong> in the Report database.\u00a0 Review the table and clear out the duplicates. Then, restart the upgrade. <\/span><\/p>\n[ERROR] Exception occur while executng script in database.MySql.Data.MySqlClient.MySqlException (0x80004005): Duplicate entry for key 'Unique_ppdt'\r\n\r\nat MySql.Data.MySqlClient.MySqlStream.ReadPacket()<\/span>\r\n\r\nat MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)<\/span>\r\n\r\nat MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)<\/span>\r\n\r\nat MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)<\/span>\r\n\r\nat MySql.Data.MySqlClient.MySqlDataReader.NextResult()<\/span>\r\n\r\nat MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)<\/span>\r\n\r\nat MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()<\/span>\r\n\r\nat MySql.Data.MySqlClient.MySqlScript.Execute()<\/span>\r\n\r\nat MyCustumAction.DBHelper.ExecuteMariaDBSQLScriptFile(String server, String port, String userId, String password, String database, String sqlFile)<\/span>\r\n\r\nat MyCustumAction.CustomActions.ExecuteMariaDBScript(Session session)<\/span>\r\n\r\n7\/22\/2021 1:22:53 PM : [ERROR] Current installation will be rollback.<\/span><\/pre>\n
Proposed Solution<\/b><\/h2>\n