Activities of "viswajwalith"

• ABP Framework version: v5.1.3
• UI type: MVC
• DB provider: EF Core / MongoDB
• Tiered (MVC) or Auth Server Separated (Angular): yes
• Exception message and stack trace:

2023-07-22 07:12:09.728 +05:30 [ERR] scopes too long.
{"ClientId":"AppV3_Web","ClientName":"AppV3_Web","RedirectUri":"https://localhost:44321/signin-oidc","AllowedRedirectUris":["https://{0}.testsite.com/signin-oidc","https://{0}.localhost:44321/signin-oidc","https://testsitewebapp.azurewebsites.net/signin-oidc","https://localhost:44321/signin-oidc"],"SubjectId":"anonymous","ResponseType":"code id_token","ResponseMode":"form_post","GrantType":"hybrid","RequestedScopes":"","State":"CfDJ8FRhYrLUrBdPg2ipof6Ze141-m_C9hm-bhDu6hDNPXGK5T_WjNbAyxLhVFpOIFgSjTCNYYYcENYzyWm0aT4G_0SS_EfgdEO7EK9yqxhoHx8Z--fuxMFUmB9I07BG9mhXb4-KHVKfvGFN7I0TrkLHJCgid-RRd_xwriXqI4k5QWLSc3lzytcNjujmjU9VsNtsvwu40Klueh_5WXWwmXnWsrkuVMTDLmybdm3SRDgqAlzEUD6q-AKv_-EryW8VREewclQNkwM6CFSDzyOKw7aWolXlFzDrCZpDDoy_ZJZIkKf26al72l__tMQkUhXDkwDhWoCZpaI3EmvImjP4UoP6Uwc","UiLocales":null,"Nonce":null,"AuthenticationContextReferenceClasses":null,"DisplayMode":null,"PromptMode":"","MaxAge":null,"LoginHint":null,"SessionId":null,"Raw":{"LOGINUSING":"","client_id":"AppV3_Web","redirect_uri":"https://localhost:44321/signin-oidc","response_type":"code id_token","scope":"openid profile role email phone phone2 AuthServer IdentityService AdministrationService SaasService Test1Service Test2Service Test3Service Test4Service Test5Service Test6Service Test7Service Test8Service Test9Service Test10Service Forms FileManagement Test11Service Test12Service Te13PTWService","response_mode":"form_post","nonce":"638255869292291791.ZDk5M2NiMGUtNTIzOC00NDFiLWEwOTAtNjUwNTM2Y2JkMGZkNDg3NjM0NDEtM2ZkOC00ZDNkLWJhNTMtYzJlNDY5MTU1OGM0","state":"CfDJ8FRhYrLUrBdPg2ipof6Ze141-m_C9hm-bhDu6hDNPXGK5T_WjNbAyxLhVFpOIFgSjTCNYYYcENYzyWm0aT4G_0SS_EfgdEO7EK9yqxhoHx8Z--fuxMFUmB9I07BG9mhXb4-KHVKfvGFN7I0TrkLHJCgid-RRd_xwriXqI4k5QWLSc3lzytcNjujmjU9VsNtsvwu40Klueh_5WXWwmXnWsrkuVMTDLmybdm3SRDgqAlzEUD6q-AKv_-EryW8VREewclQNkwM6CFSDzyOKw7aWolXlFzDrCZpDDoy_ZJZIkKf26al72l__tMQkUhXDkwDhWoCZpaI3EmvImjP4UoP6Uwc","x-client-SKU":"ID_NET6_0","x-client-ver":"6.21.0.0"},"$type":"AuthorizeRequestValidationLog"}
2023-07-22 07:12:09.729 +05:30 [ERR] Request validation failed
2023-07-22 07:12:09.729 +05:30 [INF] {"ClientId":"AppV3_Web","ClientName":"AppV3_Web","RedirectUri":"https://localhost:44321/signin-oidc","AllowedRedirectUris":["https://{0}.demoehswatch.com/signin-oidc","https://{0}.localhost:44321/signin-oidc","https://testsitewebapp.azurewebsites.net/signin-oidc","https://localhost:44321/signin-oidc"],"SubjectId":"anonymous","ResponseType":"code id_token","ResponseMode":"form_post","GrantType":"hybrid","RequestedScopes":"","State":"CfDJ8FRhYrLUrBdPg2ipof6Ze141-m_C9hm-bhDu6hDNPXGK5T_WjNbAyxLhVFpOIFgSjTCNYYYcENYzyWm0aT4G_0SS_EfgdEO7EK9yqxhoHx8Z--fuxMFUmB9I07BG9mhXb4-KHVKfvGFN7I0TrkLHJCgid-RRd_xwriXqI4k5QWLSc3lzytcNjujmjU9VsNtsvwu40Klueh_5WXWwmXnWsrkuVMTDLmybdm3SRDgqAlzEUD6q-AKv_-EryW8VREewclQNkwM6CFSDzyOKw7aWolXlFzDrCZpDDoy_ZJZIkKf26al72l__tMQkUhXDkwDhWoCZpaI3EmvImjP4UoP6Uwc","UiLocales":null,"Nonce":null,"AuthenticationContextReferenceClasses":null,"DisplayMode":null,"PromptMode":"","MaxAge":null,"LoginHint":null,"SessionId":null,"Raw":{"LOGINUSING":"","client_id":"AppV3_Web","redirect_uri":"https://localhost:44321/signin-oidc","response_type":"code id_token","scope":"openid profile role email phone phone2 AuthServer IdentityService AdministrationService SaasService Test1Service Test2Service Test3Service Test4Service Test5Service Test6Service Test7Service Test8Service Test9Service Test10Service Forms FileManagement Test11Service Test12Service Te13PTWService","response_mode":"form_post","nonce":"638255869292291791.ZDk5M2NiMGUtNTIzOC00NDFiLWEwOTAtNjUwNTM2Y2JkMGZkNDg3NjM0NDEtM2ZkOC00ZDNkLWJhNTMtYzJlNDY5MTU1OGM0","state":"CfDJ8FRhYrLUrBdPg2ipof6Ze141-m_C9hm-bhDu6hDNPXGK5T_WjNbAyxLhVFpOIFgSjTCNYYYcENYzyWm0aT4G_0SS_EfgdEO7EK9yqxhoHx8Z--fuxMFUmB9I07BG9mhXb4-KHVKfvGFN7I0TrkLHJCgid-RRd_xwriXqI4k5QWLSc3lzytcNjujmjU9VsNtsvwu40Klueh_5WXWwmXnWsrkuVMTDLmybdm3SRDgqAlzEUD6q-AKv_-EryW8VREewclQNkwM6CFSDzyOKw7aWolXlFzDrCZpDDoy_ZJZIkKf26al72l__tMQkUhXDkwDhWoCZpaI3EmvImjP4UoP6Uwc","x-client-SKU":"ID_NET6_0","x-client-ver":"6.21.0.0"},"$type":"AuthorizeRequestValidationLog"}
2023-07-22 07:12:09.731 +05:30 [INF] {"ClientId":"AppV3_Web","ClientName":"AppV3_Web","RedirectUri":"https://localhost:44321/signin-oidc","Endpoint":"Authorize","SubjectId":null,"Scopes":"","GrantType":"hybrid","Error":"invalid_request","ErrorDescription":"Invalid scope","Category":"Token","Name":"Token Issued Failure","EventType":"Failure","Id":2001,"Message":null,"ActivityId":"0HMS9T4RN05FV:00000001","TimeStamp":"2023-07-22T01:42:09.0000000Z","ProcessId":11196,"LocalIpAddress":"::1:44322","RemoteIpAddress":"::1","$type":"TokenIssuedFailureEvent"}

• Steps to reproduce the issue:" Just add scopes to the OIDC provider (add scopes around 20+)

When we are adding more scopes to OIDC (due to the number of Micro services we are having), after reaching around 20 scopes getting the scopes tooo long error.

What is the process to increase the length or modify the code to add all service scopes as a single scope

hi

I think you can only use the dotnet ef migrations script to get the script on each project.

The migratory tool just applies the migration and seeds the data.

That's fine, we will generate manually for DB structural changes. but do we have any other way to generate the insert scripts for data seeding from the Migration tool right? Mainly for Permission, Roles and Tenant specific data.

Also sometimes we are getting the Generated SQL file as empty, any idea on that? for the below code

using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace XXXX.Migrations
{
    public partial class ImportHistoryLogImportRunHistory : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn<string>(
                name: "CustomField1",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField2",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField3",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField4",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField5",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RowNo",
                table: "EmployeeServiceImportRunHistories",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField1",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField2",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField3",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField4",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "CustomField5",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);

            migrationBuilder.AddColumn<string>(
                name: "RowNo",
                table: "EmployeeServiceImportHistroyLogs",
                type: "nvarchar(max)",
                nullable: true);
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "CustomField1",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "CustomField2",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "CustomField3",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "CustomField4",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "CustomField5",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "RowNo",
                table: "EmployeeServiceImportRunHistories");

            migrationBuilder.DropColumn(
                name: "CustomField1",
                table: "EmployeeServiceImportHistroyLogs");

            migrationBuilder.DropColumn(
                name: "CustomField2",
                table: "EmployeeServiceImportHistroyLogs");

            migrationBuilder.DropColumn(
                name: "CustomField3",
                table: "EmployeeServiceImportHistroyLogs");

            migrationBuilder.DropColumn(
                name: "CustomField4",
                table: "EmployeeServiceImportHistroyLogs");

            migrationBuilder.DropColumn(
                name: "CustomField5",
                table: "EmployeeServiceImportHistroyLogs");

            migrationBuilder.DropColumn(
                name: "RowNo",
                table: "EmployeeServiceImportHistroyLogs");
        }
    }
}

• That means do we need to generate for each micro service in this case?
• don't we have an option out of box for the Migrator tool?
• Do you think there will be a way to generate the scripts for all of the Micro services in one go?

If you're creating a bug/problem report, please include followings:

ABP Framework version: v5.1.3 UI type: MVC DB provider: EF Core / MongoDB Tiered (MVC) or Identity Server Separated (Angular): yes Exception message and stack trace: Steps to reproduce the issue:

We would like to Generate the SQL Files while execution of DB migrator to review the same, we are trying to enable the same but didn't find any supporting document for the same. Can you please provide the details for the same

Thanks

We are still preparing the sample solutions, will share by tomorrow max

hi

We don't familiar with MongoDB, You can create a sample project with ef core.

We will try to provide a sample in two days to continue our discussion.

I think this feature available on ef core 7.0

Yes we also found this but not sure how it be have with MongoDB, for code sample give me 2 days time I will provide

hi

As per the EF (in general) the update statement should handle the scenario and it should prepare the update statement with update of 2 fields only not for all...

You are using ef core 6.x, have you tried the ef core 7?

We didn't tried the ef core 7 and we are middle of ABP 7 upgrade. do you mean after ef 7 the concern will handle automatically for both SQL & Mongo?

But still we had to pass the Entire Update DTO even we update few properties right? any work around for the same or do we need to write the custom method to do so.

Check the docs before asking a question: https://docs.abp.io/en/commercial/latest/ Check the samples, to see the basic tasks: https://docs.abp.io/en/commercial/latest/samples/index The exact solution to your question may have been answered before, please use the search on the homepage.

If you're creating a bug/problem report, please include followings:

• ABP Framework version: v5.1.3
• UI type: MVC
• DB provider: EF Core / MongoDB
• Tiered (MVC) or Identity Server Separated (Angular): yes / no
• Exception message and stack trace:
• Steps to reproduce the issue:"

We have couple of DTO objects with lot of properties (some are with around 89-90), when it comes to updating 1 or 2 fields we are forced to pass entire DTO object to update those 2 fileds even tough we have no changes to other fields.

As per the EF (in general) the update statement should handle the scenario and it should prepare the update statement with update of 2 fields only not for all...

Can you please provide how the things will work in the ABP way for both SQL and Mongo. in simple words we would like to know a process to update a object by passing required properties to have a limited data while transferring and having better query execution time.

//Add this 
app.MapWhen( 
    ctx => ctx.Request.Path.ToString().StartsWith("/api/abp/api-definition") || 
           ctx.Request.Path.ToString().TrimEnd('/').Equals(""), 
    app2 => 
    { 
        app2.UseRouting(); 
        app2.UseConfiguredEndpoints(); 
    } 
); 
app.UseRewriter(new RewriteOptions() 
    // Regex for "", "/" and "" (whitespace) 
    .AddRedirect("^(|\\|\\s+)$", "/swagger")); 
app.UseOcelot().Wait(); 

Thanks liangshiwei, it worked perfectly. In fact we added the user Task API in WebGateway and modified the octlog configuration but missed the below change mentioned.

Can you guys please update the documentation to include the above steps. (https://docs.abp.io/en/commercial/latest/startup-templates/microservice/add-microservice) which might be helpful for others as well