Users are receiving the error “An unexpected error occurred: An item with the same key has already been added.

From Sage Intelligence Knowledgebase
Revision as of 01:31, 25 April 2014 by Support (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Issue:

Users are receiving the error “An unexpected error occurred: An item with the same key has already been added. Would you like to view this error details? An item with the same key has already been added.” when creating a new layout using the Financial Genie Report.


DESCRIPTION
DESCRIPTION


An unexpected error occurred: An item with the same key has already been added. Would you like to view this error details?

An item with the same key has already been added.

SYMPTOMS:

When users are creating or generating a new layout using BI Tools within Excel, users are receiving the above mentioned error.

When users click on BI Tools, and then click on “Quick Generate”


DESCRIPTION


Select the required layout

DESCRIPTION


The following error will appear, click on yes.


DESCRIPTION


Then click on OK.

DESCRIPTION

RESOLUTION/WORKAROUND:

Ensure that there are no duplicate accounts or names in Sheet 1

5570>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5570>010 >010 Sagteware - 5570>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5570>010 >010 Website Design - >020 Owv - Sagtewaarde - 5600>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5600>010 >010 Mootsraat - 5600>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5600>010 >010 Voertuie –

Add a unique name to the accounts, once that is done the user will then be able to generate or create a new lay out.

5570>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5570>010 >010 Sagteware - 01 5570>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5570>010 >010 Website Design - >020 Owv - Sagtewaarde - 5600>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5600>010 >010 Mootsraat -02 5600>010 - Wannenburgs Motors PTA Wes (Pty) Ltd 5600>010 >010 Voertuie –

APPLIES TO:

For all sage intelligence Financial Genie Reports.