Importing addresses with RecID compression enabled

Sometimes you need to import addresses into AX 2009 and enable RecID compression. This import might result in an error:

 Update of RecID-key xxxxxxxx failed for the register DirPartyAddressRelationshipMapping.

To solve this you need to follow these steps:

  1. Restore the database
  2. Disable RecID unique index on the table affected by this issue
  3. Synchronize
  4. Import data
  5. Enable RecID unique index
  6. Synchronize

Martin F