Space Import throws error: insert or update on table "content" violates foreign key constraint "fk_content_lastmodifier" Detail: Key (lastmodifier)=(XXXXXX) is not present in table "user_mapping".

XMLWordPrintable

    • 7
    • Severity 3 - Minor
    • 17

      Issue Summary

      When importing a Confluence Space one of the errors below is triggered:

      ERROR: insert or update on table "content" violates foreign key constraint "fk_content_lastmodifier" Detail: Key (lastmodifier)=(XXXXXX) is not present in table "user_mapping". 
      ERROR: insert or update on table "content" violates foreign key constraint "fk_content_creator" Detail: Key (creator)=(XXXXXX) is not present in table "user_mapping". 

      Steps to Reproduce

      1. Export Confluence Cloud Space
      2. Import into another Confluence Cloud Site
      3. Error is triggered

      Expected Results

      The import should be successful.

      Actual Results

      Foreign key constraints are being hit and stopping the import

      Workaround

      Use the import via CSV instead, which has this specific constraint already addressed during the import flow.

              Assignee:
              Unassigned
              Reporter:
              Isaac Spann
              Votes:
              1 Vote for this issue
              Watchers:
              17 Start watching this issue

                Created:
                Updated:
                Resolved: