Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

COM error: mscorlib, An item with the same key has already been added

Hello,   We've patched our Report Server October 2020 with the November 18th patch and this fixed almost all our refresh issues.   However I still have one report which doesn't refresh correctly ...
Report Server
  • Anonymous's avatar
    Anonymous
    5 years ago

    Thank you for the reply Denis. Unfortunately it didn't work for me but it might help someone else.

     

    However I did find a solution to my problem.

     

    Our report created its SQL data source in 2 distinct ways for some reason, using 1 or 2 lines:

     

    Source = Sql.Database("HOSTNAME", "DATABASENAME"),
    or
    Source = Sql.Databases("HOSTNAME"),
    DATABASENAME = Source{[Name="DATABASENAME"]}[Data],

     

    Apparently when we merged 2 tables using different source creation methods it would crash in Report Server. I changed all our data source to use the single line method and now everything works.

     

    That definitely sounds like a bug, I will create an issue report.

Denis_Zinukov's avatar
Denis_Zinukov
Frequent Visitor
5 years ago

Hello,

 

I had the same issue, to solve I renamed columns that use as keys in join operation. How I have new error

So I can't say that it can help. But, perhaps, it a good idea to try.

 

In my case joined quereis came from Query to folder with Excel files and query to Excel file.

 

Report Server version

 

declanR's avatar
declanR
Frequent Visitor
5 years ago

Thanks, Denis. The first thing i did to fix the problem. Not working