Sugar 8 Pro to Enterprise Conversion Upgrade fails - Duplicate entry into SugarFavorites

Question

So I'm currently working on upgrading our SugarCRM instance. Before proceeding with the rest of the upgrades, I need to convert from Pro to Enterprise. When applying the upgrade, I see this error in UpgradeWizard.log Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - Starting script 6_SharableDashboards
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - ERROR: Exception: An exception occurred while executing 'INSERT INTO sugarfavorites (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, module, record_id, assigned_user_id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params ["098fee45e1e7041684fa96f0f459c8a3", null, "2023-08-30 19:12:27", "2023-08-30 19:12:27", "1", "1", null, 0, "Dashboards", "3fc434e6-9b6d-357a-0759-576936d6ca5e", "1"]:
Duplicate entry '098fee45e1e7041684fa96f0f459c8a3' for key 'PRIMARY'
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - Finished script 6_SharableDashboards
Wed, 30 Aug 2023 19:12:27 +0000 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts I'm not sure what the purpose of this script is, but I checked the 7.9.4 -> 8.0 upgrader for 6_SharableDashboards.php and I see the exact same file there. So I'm wondering if anyone has run into this issue before and what they might have done to fix it. Seems like I have no choice but to try to modify the upgrader to remove this script?

Josh Whitlow · Accepted Answer

Thanks for confirming the query results, Josh Whitlow . The script being present in the 7.9.4.0 to 8.0.0 upgrade package makes sense because 8.0 is where shareable dashboards were released as a feature. I don't think the script was intended to be in the 8.0 conversion package since it would have already run for anyone performing that conversion as you have found. 
 I confirmed the 6_ShareableDashboards script is not in the 9.0 Pro-to-Ent conversion package, so I think the best course of action is to upgrade Pro 8.0 to 9.0 and then perform the conversion there rather than manually modifying the conversion package for 8.0. 
 Chris