Description |
*This issue relates to i21 Help Desk ticket:* [HDTN-340373 - FB Live upgrade took too long during Liquibase db upgrade step|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-340373]
+*Steps:*+
1. Update Fortbooks environment in latest build
+*Issue:*+
Encountered on today's upgrade of FB Live.
Usually, Liquibase step takes 5 minutes or less to be finished. However, in this upgrade, it is still running more than 30 minutes.
!image-2024-04-25-13-22-23-103.png!
Upon investigation, the issue is caused by tblHDUpload post-deployment script wherein it transfers the blob files from tblHDUpload to tblSMUpload.
As discussed with DEV lead of HD this will have either a data or program fix to resolve the issue.
We ran the data fix below for now to have a quick and successful upgrade.
*INSERT INTO tblEMEntityPreferences(strPreference,strValue)*
*SELECT 'Migrate HD to SM Upload', '1'*
[https://i21connect.com/#/environments/upgrade/6001412]
+*Accepted:*+
Environment should take 5mins or less to update.
|