microsoft / coe-starter-kit

Other
754 stars 225 forks source link

[CoE Starter Kit - BUG] admin_EnvironmentSecurityRolePermission increasing Storage #8937

Closed backiii closed 2 months ago

backiii commented 2 months ago

Does this bug already exist in our backlog?

Describe the issue

We are observing that the storage of this table is going up.

admin_EnvironmentSecurityRolePermission

However, we cannot explain why this is the case

Expected Behavior

It should not use this amount of storage space for EnvironmentSecurityRolePermissions

image

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.37

What app or flow are you having the issue with?

Admin | Sync Template v4 (Security Roles)

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

No response

Anything else?

No response

Jenefer-Monroe commented 2 months ago

I don't repro this in any of our test tenants.

  1. Can you please validate that you don't have unmanaged layers on that flow?
  2. Looking through the records in the database for a target environment, do they seem incorrect? Do they cluster on a single envt?
Jenefer-Monroe commented 2 months ago

closing out as no further action for starter kit team

tamdva21 commented 1 month ago

Hello. We also are experiencing the same issues. We currently have the version 4.24. This issue could be solved installing the latest version?