Microsoft Dynamics AX Support

This blog contains posts by the Microsoft Dynamics AX Support Teams Worldwide

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”

FrameworkParameters

Select Entity Settings, and click “Refresh entity list”

RefreshEntities