Activities of "viswajwalith"

[maliming] said: private static IQueryable<IdentityUser> MyIncludeDetails(IQueryable<IdentityUser> queryable, bool include = true) { if (!include) { return queryable; }

    return queryable 
        .Include(x => x.Roles) 
        .Include(x => x.Logins) 
        .Include(x => x.Claims) 
        .Include(x => x.Tokens); 
    //.Include(x => x.OrganizationUnits); 
} 

Even after overing same issue. the request got struck at

The ReturnUrl is /connect/authorize?client_id=TestUsersLoad_Web&redirect_uri=https%3A%2F%2Flocalhost%3A44348%2Fsignin-oidc&response_type=code%20id_token&scope=openid%20profile%20roles%20email%20phone%20TestUsersLoad&response_mode=form_post&nonce=638947468557304847.N2IyODhhMWQtNzM0Ny00Zjk4LWJhMWUtYjJiMTA4NDU5MDBhYzE2NmM1NWMtM2U4Ni00NWI3LThmOTMtMzNhNWE5Y2YxZTJm&state=CfDJ8GwxaJ_oChhEifGznYgZ_6Hc3q98FIXQjmCCyU_9IxjO0d7a6H5Pc3q8CUh37y_6tEuJDU3MLm8jP7fSbyRiIuTDGJMEd2AI3I-b_mb9-mUnWICbzRduRoarPufcVLWYMjeSRLmvmXTGUhgbSbdAdhXyqzeu309JIRf0I18swYUmfJgZzH_56uPQjFBlb7SCQtuV-Yi3YdhlmLJaE5ysts7L6tUKJOle7CZ0FTcdOTFFymmjBBD-lqlg4SVxR5MRTsIj2WI3hlGrbmODT4qfWy1RPVJ19a-aIq0Z094DCkpE&x-client-SKU=ID_NET9_0&x-client-ver=8.9.0.0

I made small change at ur code as the intended code is not reachable.

[maliming] said: Configure<AbpEntityOptions>(options => { options.Entity<IdentityUser>(identityUserOptions => { identityUserOptions.DefaultWithDetailsFunc = queryable => { return queryable .Include(x => x.Roles) .Include(x => x.Logins) .Include(x => x.Claims) .Include(x => x.Tokens); //.Include(x => x.OrganizationUnits); }; }); });

Nope still issue persists, did u executed the SQL script to seed the data ? as of now home many entries are there in AbpUsers and AbpUserOrganizationUnits table?.

If needed I can share the screen for better understanding

[viswajwalith] said:

[maliming] said: hi

I am still unable to reproduce the problem.

Can you share such a project?

Thanks.

Ok I will share the project and DB back up as well (in some time)

Hi I have sent the files to your email. Issue is coming after mapping the user to locations in "AbpUserOrganizationUnits". Please have a look and let us know if you need any more details.

[maliming] said: hi

I am still unable to reproduce the problem.

Can you share such a project?

Thanks.

Ok I will share the project and DB back up as well (in some time)

[maliming] said: hi

I mean, can you add some code to insert organizations to show the problem?

Thanks.

are u not getting the issue after seeding around 4k Locations?

[maliming] said: hi

The SQL script doesn't reproduce the problem.

Can you try to add your test organizations by code?

Thanks.

You mean even after adding around 4K locations issue not replicated?

[maliming] said: hi

Can you share some code to seed organzation data? Then reproduce it?

Thanks.

Hi I sent a email with sthe script to pre-seed the data.

[maliming] said: hi

Can you share your test project?

liming.ma@volosoft.com

Thanks.

Hi, You can give a try by creating a sample layered solution and creating the Locations

I emailed the script...

Let me know in case of any queries....

We are facing the issue during login process. when we have number of locations "AbpUserOrganizationUnits" (we have around 1500 Locations) and all of he locations is mapped to the users "AbpUserOrganizationUnits", The number of users are around 3000 this was working ok in our previous ABP 5 solution but after upgrading to Abp9 we found lot time it is taking top process the below code, around 3 minutes hence getting the timeout as well

In order top check this We have created a simple layered solution, and loaded with 2000 Locations. in this case we observed lo of time is taking at

As per our analysis we are suspecting on claims. This is very critial and makor concern.

1. We did not find any ETOs for IdentityUserOrganizationUnit and IdentityUserRole to implement DistributedEventHandler.

2. We are using default ABP API for User creation and Edit. We are facing performance issue when we have hundreds of organization units. We've observed that LocalEventHandler is triggering for every organization unit assignment/removal in User create/edit. Is Default API using Batch Processing for organization unit assignment/removal or else need to inplement explicitly by overriding default API.

Any guidance or clarification on this would be greatly appreciated.