Post reply

Error when refreshing fields..."An item with the same key has already been added."

  • May 8, 2018 at 8:21 am

    #330796

    I'm getting this error, "An item with the same key has already been added.", when refreshing fields for my report. I've already checked to make sure I don't have any field names used more than once. Is there anything else that I can check?

  • May 8, 2018 at 8:30 am

    #1989693

    NineIron - Tuesday, May 8, 2018 8:21 AM

    I'm getting this error, "An item with the same key has already been added.", when refreshing fields for my report. I've already checked to make sure I don't have any field names used more than once. Is there anything else that I can check?

    Check the query or stored procedure that you are using for the data. You can get the error when you have the same column name from different tables. When you qualify the column name with the table alias the query itself is fine. You have something like:
    Select A.SomeID, B.SomeID
    from  TableA as A
    inner join TableB as B
    on......

    If you have something like that, give the columns aliases in the sql itself.

    Sue

  • May 8, 2018 at 8:35 am

    #1989697

    Yes. I've checked that.

  • May 8, 2018 at 8:46 am

    #1989705

    NineIron - Tuesday, May 8, 2018 8:35 AM

    Yes. I've checked that.

    It's seeing duplicates somewhere in the data sets even if you aren't using it on the report.
    Check the data sets as well, not just the report. If you are doing a select *, change to column names.

    Sue

  • May 8, 2018 at 10:03 am

    #1989726

    Found the culprits. Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply