Forum Discussion

Logesh's avatar
Logesh
New Member
2 hours ago

Import Package Fails with Foreign Key Constraint Error

Hi Team,

I am encountering an issue while importing a package in Aras Innovator. The import fails with a SQL foreign key constraint error related to Item Action.

Error Message

Import package 'com.aras.innovator.solution.PLM' failed with message: The UPDATE statement conflicted with the FOREIGN KEY constraint "FK__ITEM_ACTI__RELAT__002AF460". The conflict occurred in database "OGE_innovator31_RE7", table "innovator.ACTION", column 'ID'. The statement has been terminated. SQL: UPDATE [ITEM_ACTION] SET [RELATED_ID] = @related_id WHERE [ID] = @id

Help me to solve this error.

Thanks

1 Reply

  • mconstantin_aras_com's avatar
    mconstantin_aras_com
    Creator I
    2 hours ago

    Hello Logesh,

    This error indicates that ITEM_ACTION.RELATED_ID is referencing an ACTION that does not exist in the target database.

    To resolve the issue, please check the following:

    • Verify that the referenced Action exists 
    • Ensure the related_id (Action) is included in your package.
      -> (do you have the Folder "Action" and the xml inside in the "Import" Folder?)

    If not, re-export the package including Actions (with dependencies).

    Compare IDs

    • Check if the related_id points to an ID that does not exist in the target system.
    • This can happen between environments (for example, when a versionable item is updated and the ID changed — I’ve personally missed updating it in one of the files before).

    Review package completeness

    • Make sure you didn’t export only part of the configuration (e.g., ItemType without its Actions).

    In my experience, this is the most common cause of this error.

    Michael