[CoE Starter Kit - BUG] Admin | Gather Tenant SRs fails with The number of array items in variable 'TenantSRs' reached the limit: maximum '100000' and actual '100000'.

[martintoelk]

Does this bug already exist in our backlog?

• I have checked and confirm this is a new bug.

Describe the issue

The Admin | Gather Tenant SR adds all found SR into an array. For medium/ Large tenants this will to much to handle for the array and the Cloud Fails with

BadRequest. The number of array items in variable 'TenantSRs' reached the limit: maximum '100000' and actual '100000'.

Additional Info:
We have ~90 Environments. Some Environments are having a lot of Business Units and therefor a very big amount of Security Roles (Roles get multipled by each Business Unit)

Edit:
We also have a bunch of deprecated SR's that we did not /cant delete which makes the situation even more worse. The flow fails roughly after processing half of the Environments

Expected Behavior

Flow does not fail

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.24

What app or flow are you having the issue with?

Admin | Gather Tenant SRs

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

Create a bunch of Environment + BU + Roles until you have > 100.000 Array Entries

Anything else?

No response

AB#2555

[Jenefer-Monroe]

Thanks for posting! I bet its all those BUs. Since they are dupes we can ignore them. Let me get you a filter to try.

[Jenefer-Monroe]

Unfortunately the object isnt returned in a way we can do a simple expand query filter but we will not be stopped!

To try it out for me you'll need to make these changes locally. Please let me know if you are able to do so and if it works.
If not perhaps someone else in the community who hits this can try.

Inside the Apply to each envt loop you'll add these two new actions
First a List rows from selected environment then a Compose

List rows from selected environment

Action Name: Get Parent BU for ID
Environment: @Items('Apply_to_each_envt')?['properties/linkedEnvironmentMetadata/instanceUrl']
Table name: businessunits
Select columns: businessunitid, name
Filter rows: _parentbusinessunitid_value eq null

Compose

Action Name: ParentBU
Inputs: @{first(outputs('Get_Parent_BU_for_ID')?['body/value'])?['businessunitid']}

Filters

Now you'll add to the filters on these two actions

Get SRs from envt with TIDs
Filter rows: _roletemplateid_value ne null and _businessunitid_value eq @{outputs('ParentBU')}

Get SRs from envt
Filter rows: _roletemplateid_value eq null and _businessunitid_value eq @{outputs('ParentBU')}

[martintoelk]

Awesome! It worked and it is very fast. The old version did run for over 2 hours, before it crashed.

#7838

[Jenefer-Monroe]

Huzzah! Thank you so much for testing for me!
Ready for April.