Unique index introduced. Upgrade script required.

Finance and Operations/AX Developer Forum
1

Hello,

we are planning to upgrade from AX2012R3 to D365, for that, we are trying to resolve all the best practice errors in our AX environment. i am seeing an error “Unique index error: Unique index introduced. Upgrade script required.” on many tables this error is showing even on standard indexes. For example i have this error on SalesQuotationTable and on “SalesQuotationIdx” index. Can anyone help me how to get rid of these index errors? Thank you

2

Are the standard indexes modified in your environment? SalesQuotationIdx is that a custom index(we have only QuotationIdx in AX 2012 standard)
msdn.microsoft.com/…/aa884122.aspx

3

i’m sorry, it’s QuotationIdx only, it’s a standard index and we have not done any modifications on it.

4

The index could be different when compared to SYS and Old SYS?

5

yes, this index was not there in old sys layer, so this was introduced in upgrades.

pastedimage1511265845050v1.png
pastedimage1511265845050v1.png726×457 24.2 KB

What might be the issue? have we done anything wrong during our upgrade? I actually ran the below job in my test environment and this job converted unique index to non unique index.

DictIndex dictIndex = new DictIndex(
tablenum(SalesQuotationTable),
indexnum(SalesQuotationTable, Quotationidx));
;

ReleaseUpdateDB::indexAllowDup(dictIndex);

Not sure how to convert this again to not to allow any duplicates? please help me!!

6

You can use \Classes\ReleaseUpdateDB\indexAllowNoDup to make it again unique.

7

Thanks Kranthi, Yes i was able to convert the index back to the unique. But anyway i’m still having the issue of “Unique index introduced. Upgrade script required.”