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.

Anonymous's avatar
Anonymous
Not applicable
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.

declanR's avatar
declanR
Frequent Visitor
5 years ago

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