Lot ID not specified Error DMF import Dynamics Ax 2012 R2 Cu7

Today I had to troubleshoot the Inventory journal DMF import, which previously working fine. But somehow it start to throw “Lot ID not specified. Import cancel. Hour of hours debugging reveals nothing. Finally I found some warnings in Database synchronize. These warnings described some index errors on DMF entity tables and need to drop and recreate them.

So I delete the DMFInventJournalEntity  table at SQL Server level and from AOT right click on table and click on synchronize. This recreate the require table at SQL server level.

Or ignore the old entity create a new entity and import data with that.