{"id":25735,"date":"2016-07-20T12:37:15","date_gmt":"2016-07-20T18:37:15","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/axsupport\/?p=25735"},"modified":"2024-03-05T13:21:19","modified_gmt":"2024-03-05T21:21:19","slug":"data-management-missing-entities-2","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/dynamics-365\/blog\/business-leader\/2016\/07\/20\/data-management-missing-entities-2\/","title":{"rendered":"Data Management: Missing Entities"},"content":{"rendered":"
If you find that you are missing entities listed in the Data entities form, you can try the following steps.<\/p>\n
Run the following SQL Script:<\/p>\n
—<\/span><\/p>\n — This source code or script is freeware and is provided on an “as is” basis without warranties of any kind,<\/span><\/p>\n — whether express or implied, including without limitation warranties that the code is free of defect,<\/span><\/p>\n — fit for a particular purpose or non-infringing. The entire risk as to the quality and performance of<\/span><\/p>\n — the code is with the end user.<\/span><\/p>\n —<\/span><\/p>\n — Create backups of the tables first<\/span><\/p>\n SELECT *<\/span><\/p>\n INTO DMFEntity_backup<\/span><\/p>\n FROM DMFEntity<\/span><\/p>\n GO<\/span><\/p>\n SELECT *<\/span><\/p>\n INTO DMFTargetXML_backup<\/span><\/p>\n FROM DMFTargetXML<\/span><\/p>\n GO<\/span><\/p>\n SELECT *<\/span><\/p>\n INTO DMFTargetXMLToEntityMap_backup<\/span><\/p>\n FROM DMFTargetXMLToEntityMap<\/span><\/p>\n GO<\/span><\/p>\n SELECT *<\/span><\/p>\n INTO DMFTargetEntityHierarchy_backup<\/span><\/p>\n FROM DMFTargetEntityHierarchy<\/span><\/p>\n GO<\/span><\/p>\n — Truncate the tables<\/span><\/p>\n TRUNCATE TABLE DMFENTITY<\/span><\/p>\n GO<\/span><\/p>\n TRUNCATE TABLE DMFTargetXML<\/span><\/p>\n GO<\/span><\/p>\n TRUNCATE TABLE DMFTargetXMLToEntityMap<\/span><\/p>\n GO<\/span><\/p>\n TRUNCATE TABLE DMFTargetEntityHierarchy<\/span><\/p>\n GO<\/span><\/p>\n Then in AX, do the following:<\/p>\n Go to: Data Management and select \u201cFramework Parameters\u201d<\/p>\n Select Entity Settings, and click \u201cRefresh entity list\u201d<\/p>\n<\/a><\/p>\n