Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | All TechTalks
Today a user got an error saying
"Cannot create a record in Party address mapping (DirPartyAddressRelationshipMapping). Company: ser.The record already exists."
The user was trying to updatecustomer record data particulary fields Company name, address, zip. Its AX2009 here. Any help please about how to update the data without getting this error.
The problem is that records in tables don't correspond .
Most likely this happened in a customer import process.
You can use this Sql command on the database so you can find out records that do not correspond.
Select top 10000 CUSTTABLE.ACCOUNTNUM, CUSTTABLE.PARTYID, DIRPARTYADDRESSRELATIONSHIP.SHARED, DIRPARTYADDRESSRELATIONSHIP.ISPRIMARY,
DIRPARTYTABLE.RECID as DirPRecId, DIRPARTYTABLE.DATAAREAID as DirPDatId,
DIRPARTYADDRESSRELATIONSHIP.RECID as DirPAdRelRecId, DIRPARTYADDRESSRELATIONSHIP.DATAAREAID as DirPAdRelDatId,
DIRPARTYADDRESSRELATIONSHI1066.RECID as DirPAdRelMapRecId, DIRPARTYADDRESSRELATIONSHI1066.DATAAREAID as DirPAdRelMapDatId,
ADDRESS.RECID as AddRecId, ADDRESS.DATAAREAID as AddDatId, ADDRESS.*
left Join DIRPARTYTABLE on CUSTTABLE.PARTYID = DIRPARTYTABLE.PARTYID
and CUSTTABLE.DATAAREAID = DIRPARTYTABLE.DATAAREAID
left Join DIRPARTYADDRESSRELATIONSHIP on DIRPARTYTABLE.PARTYID = DIRPARTYADDRESSRELATIONSHIP.PARTYID
and DIRPARTYTABLE.DATAAREAID = DIRPARTYADDRESSRELATIONSHIP.DATAAREAID
left Join DIRPARTYADDRESSRELATIONSHI1066 on DIRPARTYADDRESSRELATIONSHIP.RECID = DIRPARTYADDRESSRELATIONSHI1066.PARTYADDRESSRELATIONSHIPRECID
and DIRPARTYADDRESSRELATIONSHIP.DATAAREAID = DIRPARTYADDRESSRELATIONSHI1066.DATAAREAID
left Join [ADDRESS] on DIRPARTYADDRESSRELATIONSHI1066.REFCOMPANYID = ADDRESS.DATAAREAID
and DIRPARTYADDRESSRELATIONSHI1066.ADDRESSRECID = ADDRESS.RECID
and DIRPARTYADDRESSRELATIONSHI1066.DATAAREAID = ADDRESS.DATAAREAID
Where /*CUSTTABLE.name like '1st construct%' and */CUSTTABLE.DATAAREAID = 'aqui'
order by CUSTTABLE.name
In my case in the last record there is NULL in the AddRecId field, so there is no longer correspondence with ADDRESS table.
Solution was that I removed from tables DIRPARTYADDRESSRELATIONSHIP and DIRPARTYADDRESSRELATIONSHI1066 the problem records . Like this
delete from DIRPARTYADDRESSRELATIONSHIP
delete from DIRPARTYADDRESSRELATIONSHI1066
Sorry but in RichText here I couldn't submit.
Do you have any customization on this entity?
Forgot to mention, thank you, that helped!
Tried, not the exact way but something similar as follows and it worked:
• Select the record in table, copy ParyMappingId and maybe recId as well.
• Go to DirPartyAddressRelationship Table, make it inactive, disable and delete the Id
• Record, transactions etc stays but name and address parameters will be gone.
• Go to front-end UI, let user update the data correctly and save it. It should save
Business Applications communities