-
Type: Sprint Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Completed
-
Affects Version/s: CFA 2019R2
-
Fix Version/s: CFA 2019R3
-
Component/s: OrderGuide
-
Labels:None
-
SCRUM Team:Brotherhood of Mutants
-
Source Code ID(s):
-
Sprint:CFAMX 2019R3 Sprint 2, CFAMX 2020R1 Sprint 2, CFAMX 2020R1 Sprint 3
Cannot process Location Import on Sandbox. We saw an issue like this before when the environment was rolled back and then forward to the new release:
Last time we rolled it back to 2018.R4 - Stored Proc - qryMMSVendor_ListByVendorZoneId was deleted as a part of the rollback scripts
Rolled forward to 2019.R1 build #45 which did not redeploy the Stored Proc, hence Location import did not work in SBX
Here is what we did to fix it:
- After Removing this entry from the versioning table per Stacy's suggestion:
- delete from __SqlVersion_ChangeControl where ScriptName like '%Stored Procedures\dbo.qryMMSVendor_ListByVendorZoneId.sql%
- And redeploying the Database, the stored procedure was correctly added and the location import ran without errors!
Question: How can we fix this so it doesn't happen every rollback? I thought we did fix it.