Activities of "piseth"

any update plz?

Within my lower version < 5.2, ChartjsStyleContributor is recognized and working fine. it is from Volo.Abp.AspNetCore.Mvc.UI.Packages.ChartJs.ChartjsStyleContributor I use it in my class MyChartViewComponent.cs under MyProject.Web.Pages.Shared.Components.MyCharts.MyChartWidget

****Now it is not recognized

namespace MyProject.Web.Pages.Shared.Components.MyCharts.MyChartWidget
{
[Widget(
    StyleTypes = new[] { typeof(ChartjsStyleContributor) },
    ScriptTypes = new[] { typeof(MyChartWidgetWidgetScriptContributor) }
    )]
public class MyChartViewComponent : AbpViewComponent
{
    public virtual IViewComponentResult Invoke()
    {
        return View("/Pages/Shared/Components/MyCharts/MyChartWidget/Default.cshtml");
    }
}

[DependsOn(typeof(ChartjsScriptContributor))]
public class MyChartWidgetWidgetScriptContributor : BundleContributor
{
    public override void ConfigureBundle(BundleConfigurationContext context)
    {
        context.Files.Add("/Pages/Shared/Components/MyCharts/MyChartWidget/Default.js");
    }
}
}

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

In oracle, the maximum of varchar2 is 2000. i can not increase more.

Are you sure? As I know, varchar2 can store 4000 bytes/characters max. (https://docs.oracle.com/cd/E18283_01/server.112/e17110/limits001.htm)

Yes you're right. But I get error when I increase the size:

    builder.Entity<AuditLog>(b =>
    {
        b.Property(x => x.Exceptions).HasColumnType("nvarchar2(4000)");
    });

    builder.Entity<AuditLogAction>(b =>
    {
        b.Property(x => x.Parameters).HasColumnType("nvarchar2(4000)");
    });
   

2022-04-16 16:17:17.791266 ThreadID:1 (ERROR) OracleRelationalCommand.ExecuteNonQuery() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-00910: specified length too long for its datatype ORA-06512: at line 12 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteNonQuery(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, OracleException& exceptionForArrayBindDML, OracleConnection connection, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery() at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject) Failed executing DbCommand (378ms) [Parameters=[], CommandType='Text', CommandTimeout='0'] declare l_nullable user_tab_columns.nullable % type; begin select nullable into l_nullable from user_tab_columns where table_name = 'QoEAuditLogs' and column_name = 'Exceptions' ; if l_nullable = 'N' then EXECUTE IMMEDIATE 'ALTER TABLE "QoEAuditLogs" MODIFY "Exceptions" nvarchar2(4000) NULL'; else EXECUTE IMMEDIATE 'ALTER TABLE "QoEAuditLogs" MODIFY "Exceptions" nvarchar2(4000)'; end if; end;

Where to create MyAuditLogContributor? In Web, or Application, or EntityFrameworkCore ?

You can create it in your web or application project.

Please note that i am using Oracle. builder.Entity<AuditLogAction>(b => { b.Property(x => x.Parameters).HasMaxLength(int.MaxValue); });

Then can you set the .HasColumnType("varchar2(max)") and remove the .HasMaxLength(int.MaxValue) statement as below:

builder.Entity(b => 
{ 
   b.Property(x => x.Parameters).HasColumnType("varchar2(max)"); 
}); 

In oracle, the maximum of varchar2 is 2000. i can not increase more.

this answer

Where to create MyAuditLogContributor? In Web, or Application, or EntityFrameworkCore ?

Please note that i am using Oracle.

builder.Entity<AuditLogAction>(b => { b.Property(x => x.Parameters).HasMaxLength(int.MaxValue); });

When i run dotnet ef database update, i get the following error: Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-22858: invalid alteration of datatype

When The size of exception > 2000 , i see the error "AuditLogs"."Exceptions" (actual: 2738, maximum: 2000) Then I don't see the exception being inserted in the AuditLogs table in the database. How to solve this in order to have logs being inserted in the AuditLogs table?

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

Yes, But I don't recommend to downgrade.

Thanks so much

HI

Bootstrap v5: Internet Explorer is not supported. If you require Internet Explorer support, please use Bootstrap v4.

https://getbootstrap.com/docs/5.0/getting-started/browsers-devices/#internet-explorer

Thanks so much If i want to use the Bootstrap v4, i have to downgrade the version of Abp Commercial?