Data Management: Missing Entities
If you find that you are missing entities listed in the Data entities form, you can try the following steps.
Run the following SQL Script:
—
— This source code or script is freeware and is provided on an “as is” basis without warranties of any kind,
— whether express or implied, including without limitation warranties that the code is free of defect,
— fit for a particular purpose or non-infringing. The entire risk as to the quality and performance of
— the code is with the end user.
—
— Create backups of the tables first
SELECT *
INTO DMFEntity_backup
FROM DMFEntity
GO
SELECT *
INTO DMFTargetXML_backup
FROM DMFTargetXML
GO
SELECT *
INTO DMFTargetXMLToEntityMap_backup
FROM DMFTargetXMLToEntityMap
GO
SELECT *
INTO DMFTargetEntityHierarchy_backup
FROM DMFTargetEntityHierarchy
GO
— Truncate the tables
TRUNCATE TABLE DMFENTITY
GO
TRUNCATE TABLE DMFTargetXML
GO
TRUNCATE TABLE DMFTargetXMLToEntityMap
GO
TRUNCATE TABLE DMFTargetEntityHierarchy
GO
Then in AX, do the following:
Go to: Data Management and select “Framework Parameters”
Select Entity Settings, and click “Refresh entity list”
We're always looking for feedback and would like to hear from you. Please head to the Dynamics 365 Community to start a discussion, ask questions, and tell us what you think!