What is Error #3022 Can have duplicate key; index changes were unsuccessful?
We have seen this error a few times with Royal Bank datasets. Error #3022 Can’t have duplicate key; index changes were unsuccessful. 7020 Interest Expense – Taxable 5 10 7020 Unemployment Insurance Premium 5 10 If you are not using one or the other of the above categories, then deleting one of them will allow the translation to process normally. Otherwise a copy of the account.dbf file needs to be opened in MS Excel and then the second 7020 number changed back to 7021 as it is in a new dataset. The translation can then proceed with the account.dbf file that is modified by Excel. NOTE!! MYM will not open a dataset that has had a file modified by Excel (or any other app). Therefore the original account.dbf file must be restored after the translation. For this reason it is best to just deleted the categories from within MYM instead of using the edit in Excel method.
Related Questions
- When trying to activate Windows XP, I receive the error "Product Key is not valid." Did Keyfinder retrieve the wrong key?
- Why is it important to notify FINRA when my company first obtains or changes its Central Index Key or CIK Code?
- What is Error #3022 Can have duplicate key; index changes were unsuccessful?
