“Error (1429)” When Logging in to AccountMate

The root of the issue is duplicate entries in the user’s “shortcut pane.”

The Symptom

Immediately after logging in to AccountMate, you receive an error screen with only an <OK> button

Error (1429): OLE IDispatch exception code 0 from Nodes: Key is not unique in collection..

Check out the example screenshot below.

The Solutions

==> Recreate the User Login

A simple option is to use the AccountMate “administrator” program (amsqladm.exe in the same directory as your “regular” amsql.exe program) to delete the user login and then recreate it.

==> Clean Up the Erroneous Data

The deeper solution is to remove the duplicate entries in the AMWSYS database AMSHTPNE table, which is where the “user shortcuts” definitions are stored based on numeric user ID.

If you’re a geek, then below is SQL code that will clean this up. But if you’re not, then please contact us and we can make short work of this more elegant option.

WITH CTE as (
SELECT cuserid, ctype, cparentkey, ckey, nseq, cdesc, lexpand, cowner,
RN = ROW_NUMBER()OVER(PARTITION BY cuserid, ctype, cparentkey, ckey, nseq,
   cdesc, lexpand, cowner ORDER BY cuserid)
FROM amshtpne)
DELETE from CTE WHERE RN <> 1