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

  • NineIron

    SSChampion

    Points: 12523

    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?

  • Sue_H

    SSC Guru

    Points: 90695

    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

  • NineIron

    SSChampion

    Points: 12523

    Yes. I've checked that.

  • Sue_H

    SSC Guru

    Points: 90695

    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

  • NineIron

    SSChampion

    Points: 12523

    Found the culprits. Thanks.

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

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