Uploaded image for project: 'mod-data-export'
  1. mod-data-export
  2. MDEXP-542

Migration script fails if upgrading from version 4.2.4 to version 4.4.2

    XMLWordPrintable

Details

    • Firebird - Sprint 145
    • 1
    • Firebird
    • Lotus (R1 2022) Hot Fix #3
    • Yes
    • Approved in Slack on Jul, 20
    • TBD

    Description

      Overview:

      io.vertx.pgclient.PgException: {
    "message": "duplicate key value violates unique constraint \"mapping_profiles_pkey\"",
    "severity": "ERROR",
    "code": "<<code>>",
    "detail": "Key (id)=(1ef7d0ac-f0a8-42b5-bbbb-c7e249009c13) already exists.",
    "file": "nbtinsert.c",
    "line": "573",
    "routine": "_bt_check_unique",
    "schema": "<<tenant id>>_mod_data_export",
    "table": "mapping_profiles",
    "constraint": "mapping_profiles_pkey"
}

      Steps to Reproduce:

      1. Run migration script for default mapping profile

      Expected Results:
      Migration script passed successfully.

      Actual Results:
      Error mentioned in Overview.

      Additional Information:
      URL:
      Interested parties:

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MDEXP-548 MDEXP (mod-data-export) Lotus HF#3 release

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            defines

            New Feature - New feature requests UXPROD-3497 Firebird - Morning Glory R2 2022 Enhancements/Bugfixes/Tech Debt

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed
            is cloned by

            Bug - A problem which impairs or prevents the functions of the product. MDEXP-571 Migration script fails if upgrading from version 4.4.2 to version 4.5.1

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. MDEXP-507 Invalid migration scripts for job profiles

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                Charniak Siarhei Charniak
                Oleksandr_Bozhko Oleksandr Bozhko
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases