cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Scheduled refresh error - Item: (here is User ID) already exists in the collection

Hello!

During scheduled refresh on Bi server following error occured:

Item: '(here is user ID f.e. xxNET/17361379' already exists in the collection.

Can someone explain me why it occured?

Thank you!

8 REPLIES 8
shiboli
Microsoft
Microsoft

Hello, 

 

We have identified the problem. It's a race condition. A proper fix will be included in upcoming Janauary release. Until then, please use some workaround like:

- Schedule your refresh at a time when the server is least used;

- Restart PBIRS instance. 

Is this issue confirmed as fixed in the January release? We are still getting the issue and we are using the August release, so if we know for sure that it was addressed we will go ahead and upgrade. 

Anonymous
Not applicable

I scheduled refresh at time when noone opens dashboard, since then I do not have this issue, but it seems like work around or coincidence - not a solution

harikishant
Helper II
Helper II

The error usually occurs when there are duplicate columns in your data set. Can you please check and confirm?

 

Cheers,

Hari T

I am getting the same error as well. Does not appear to be related to the columns in the dataset though, seems like something to do with the user account. Below is the full stacktrace and it affects all scheduled refreshes (refresh of the same report from PowerBI Desktop and uploading works fine). 

 

Error Failed Data Refresh, Exception Microsoft.PowerBI.ReportServer.AsServer.Exceptions.TOMClientServerRefreshException: Refresh on Analysis Services Server failed with exception: {0} ---> System.ArgumentException: Item 'domain\username' already exists in the collection.
at Microsoft.AnalysisServices.Tabular.NamedMetadataObjectCollection`2.ValidateCanAdd(T item)
at Microsoft.AnalysisServices.Tabular.MetadataObjectCollection`2.Add(T metadataObject)
at Microsoft.AnalysisServices.Tabular.ModelRoleMember.ResolveLinks(Dictionary`2 objectMap, Boolean throwIfCantResolve)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadObjectsFromSchema(DataSet schema, ObjectType[] types, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.LoadModelFromSchema(DataSet schema, ObjectType[] objectTypes, Dictionary`2& objectMap, StringComparerInfo comparerInfo)
at Microsoft.AnalysisServices.Tabular.DdlUtil.DiscoverModel(Database db)
at Microsoft.AnalysisServices.Tabular.Database.LoadModel()
at Microsoft.AnalysisServices.Tabular.Database.OnAfterRefresh(Boolean full, Nullable`1 refreshType)
at Microsoft.AnalysisServices.Tabular.Server.OnAfterRefresh(Boolean full, Nullable`1 refreshType)
at Microsoft.AnalysisServices.MajorObject.Refresh(Boolean full)
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.Refresh(Boolean full)

This was consistently failing until a restart of the Power BI Report Service on the report server fixed the issue. Worth a try if you run into this issue. 

Anonymous
Not applicable

Does anybody solve this problem?

JonasKjeldsenDK
Regular Visitor

We have the same issue:

 

2018-11-21 09:31:10.1560|ERROR|10|Error Processing Data Model Refresh: SessionId: cc788693-64b0-44be-b871-ec79a9ef93cc, Status: Error Failed Streaming model to Analysis Server, Exception System.AggregateException: One or more errors occurred. ---> Microsoft.PowerBI.ReportServer.AsServer.AsConnectionException: Failed to publish model for 900de0de-06e4-402d-9840-9cab583e2615_10735179 ---> System.ArgumentException: Item 'DOMAIN\USER' already exists in the collection.

 

What does it mean?

 

We are on August version of PBIRS on prem.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.