Uploaded image for project: 'Migration Platform'
  1. Migration Platform
  2. MIG-1319

Space migration fails with ERROR: column "fieldid" of relation "temp_import_label" does not exist

    XMLWordPrintable

Details

    • 10
    • Severity 2 - Major
    • 4

    Description

      Issue Summary

      Space migration using CCMA 3.4.2 and 3.4.1 is failing with the below error.

      INFO [pool-66-thread-31] [agent.service.execution.PlanExecutionService] info Step fb5f1b0a-7e30-4213-8302-8bf0edc0bee7 completed execution b55261ce-5b33-4cf4-9ae0-2f79cb1a2f42 with result=StepResult(isSuccess=false, isStopped=false, message=Import to cloud failed. Message: ERROR: column "fieldid" of relation "temp_import_label" does not exist, result=null, e=null)
      ERROR [pool-66-thread-31] [agent.service.stepexecutor.ProgressTracker] error Step failed, message: Import to cloud failed. Message: ERROR: column "fieldid" of relation "temp_import_label" does not exist
      

      This is reproducible on Data Center:

      Steps to Reproduce

      1. Install CCMA 3.4.1 or 3.4.2 on a confluence. The issue is observed with the Postgres database. The default export method is CSV.
      2. Try to create a migration plan with more than 80 spaces.
      3. Some of the spaces fail with the errors highlighted below.

      Expected Results

      Migration should be successful.

      Actual Results

      The below exception is thrown in the xxxxxxx.log file:

      ERROR [pool-66-thread-31] [agent.service.stepexecutor.ProgressTracker] error Step failed, message: Import to cloud failed. Message: ERROR: column "fieldid" of relation "temp_import_label" does not exist
      

      Workaround

      • Disable csv export
        • For PostgreSQL, add dark feature migration-assistant.enable.original-xml-export
        • For other database implementations, remove dark feature migration-assistant.enable.new-space-export
      • Rollback to version without csv export, e.g. CCMA v3.3.13

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              54bf2707b706 Deepak Pandey
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated: