Failed on 22.1Prod upgrade

Issue No: LG-3545
Created 7/19/2022 5:16:36 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 22.1
Description *Steps to Reproduce:*   1. Make the latest Load Schedule record not follow the starting number format. You can use this query to simulate:   {panel:borderStyle=dashed} UPDATE tblLGLoad SET strLoadNumber = 'TEST1234-56' WHERE intLoadId = (SELECT MAX(intLoadId) FROM tblLGLoad WHERE intShipmentType = 1)   {panel} 2. Upgrade to any 22.1 version   *Issue:*   Error occurs during upgrade   *Acceptance:*   Should be able to upgrade successfully even if the latest record does not follow the starting number format     _Original report:_   Customer: Eight O Clock   Build encountered error: 22.1.0719.120   database name: test02   Error:   !pastedImage_d190337_0.png|height=843,width=553!