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”
