Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-3753

2019.R3(S2): Environment issue - Cannot process Location Import on Sandbox

    Details

    • 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

      Description

      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:

      1. After Removing this entry from the versioning table per Stacy's suggestion:
      2. delete from __SqlVersion_ChangeControl where ScriptName like '%Stored Procedures\dbo.qryMMSVendor_ListByVendorZoneId.sql%
      3. 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.

        Attachments

          Activity

            People

            • Assignee:
              soma.dixon Soma Dixon (Inactive)
              Reporter:
              soma.dixon Soma Dixon (Inactive)
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2h
                2h
                Remaining:
                0h
                Logged:
                Time Not Required
                Not Specified

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.