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:
            16 Start watching this issue

              Created:
              Updated:
              Resolved: