Archive recovery note: the supplied Blogspot backup did not contain a separate saved page for this older entry. The text available in its archive/listing capture has been preserved and flagged for a later completeness check.
Sometimes we lost unique identity check in the tables while doing some customization in Dynamics AX. It may happen due to failure of database synchronization. Here is the code to remove the duplicate records from a table, I used Dimension table as an example; static void deleteduplicate(Args _args) { set fieldSet = new set(Types::Integer); // create dicindex from the unique index DictIndex dictIndex = new Dictindex(tablenum(Dimensions),indexnum(dimensions, DimensionIdx)); ; // these are the fields from the index // add them to a set fieldset.add(fieldnum(Dimensions, DimensionCode)); fieldset.add(fieldnum(Dimensions, Num)); // set allow duplicates ReleaseUpdateDB::indexAllowDup(dictIndex); // delete duplicate records ReleaseUpdateDB::deleteDuplicatesUsingIds(tablenum(Dimensions), 1, fieldset); ...
Ask a question or leave feedback
This is a review interaction. The WordPress version will store, thread and moderate comments.