Open Closed

email configuration #1274


User avatar
0
vijay.nallala created
  • ABP Framework version: 4.3.0
  • UI type: MVC
  • DB provider: MongoDB
  • Tiered (MVC) or Identity Server Separated (Angular): yes / no
  • Exception message and stack trace:
  • Steps to reproduce the issue: after login i am going change setting screen to email configuration but giving error. also unable to set the self registration turn on/off.
    i tried from local giving runtime issue.

7 Answer(s)
  • User Avatar
    0
    maliming created
    Support Team Fullstack Developer

    hi

    Can you check the logs of your app to see the detail error?

  • User Avatar
    0
    vijay.nallala created
    2021-05-06 07:41:49.481 -04:00 [ERR] 2021-05-06 07:41:49.481448 ThreadID:34  (ERROR)   OracleRelationalCommand.ExecuteReaderAsync() :  Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("ADM"."AbpSettings"."Value")
    ORA-06512: at line 3
       at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
       at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
       at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
       at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
       at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
    --- End of stack trace from previous location ---
       at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
    2021-05-06 07:41:49.481 -04:00 [ERR] Failed executing DbCommand (6ms) [Parameters=[:p0='?' (DbType = Binary), :p1='?' (Size = 128), :p2='?' (Size = 64), :p3='?' (Size = 64), :p4='?' (Size = 2000), :p5='?' (DbType = Binary), :p6='?' (Size = 128), :p7='?' (Size = 64), :p8='?' (Size = 64), :p9='?' (Size = 2000), :p10='?' (DbType = Binary), :p11='?' (Size = 128), :p12='?' (Size = 64), :p13='?' (Size = 64), :p14='?' (Size = 2000), :p15='?' (DbType = Binary), :p16='?' (Size = 128), :p17='?' (Size = 64), :p18='?' (Size = 64), :p19='?' (Size = 2000)], CommandType='"Text"', CommandTimeout='0']
    BEGIN
    
    INSERT INTO "AbpSettings" ("Id", "Name", "ProviderKey", "ProviderName", "Value")
    VALUES (:p0, :p1, :p2, :p3, :p4);
    INSERT INTO "AbpSettings" ("Id", "Name", "ProviderKey", "ProviderName", "Value")
    VALUES (:p5, :p6, :p7, :p8, :p9);
    INSERT INTO "AbpSettings" ("Id", "Name", "ProviderKey", "ProviderName", "Value")
    VALUES (:p10, :p11, :p12, :p13, :p14);
    INSERT INTO "AbpSettings" ("Id", "Name", "ProviderKey", "ProviderName", "Value")
    VALUES (:p15, :p16, :p17, :p18, :p19);
    END;
    2021-05-06 07:41:49.498 -04:00 [ERR] An error occurred using a transaction.
    2021-05-06 07:41:49.500 -04:00 [ERR] 2021-05-06 07:41:49.500192 ThreadID:34  (ERROR)   OracleExecutionStrategy.ExecuteAsync() :  Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details.
     ---> Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("ADM"."AbpSettings"."Value")
    ORA-06512: at line 3
       at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
       at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
       at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
       at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
       at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
    --- End of stack trace from previous location ---
       at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
      
    2021-05-06 07:41:49.508 -04:00 [INF] Request finished HTTP/2 POST https://dev-idm.nirvanahealth.com/api/setting-management/emailing application/json 232 - 500 - - 221.0759ms
    2021-05-06 07:41:50.931 -04:00 [ERR] GetHealthReport threw an exception when trying to get report from /health-status configured with name IdenityManager Health Status.
    System.InvalidOperationException: An invalid request URI was provided. The request URI must either be an absolute URI or BaseAddress must be set.
       at System.Net.Http.HttpClient.PrepareRequestMessage(HttpRequestMessage request)
       at System.Net.Http.HttpClient.SendAsync(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationToken cancellationToken)
       at HealthChecks.UI.Core.HostedService.HealthCheckReportCollector.GetHealthReport(HealthCheckConfiguration configuration)
    2021-05-06 07:41:50.932 -04:00 [INF] Notification is sent on same window time.
    
  • User Avatar
    0
    vijay.nallala created

  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    HI,

    I can't reproduce the problem, Could you use abp suite to create a new project to reproduce the problem? share the project via email: shiwei.liang@volosoft.com

  • User Avatar
    0
    vijay.nallala created

    yes - i did morethan 10 times it giving same error on devlopment - here the log file

    2021-05-26 13:49:35.473 -04:00 [INF] Authorization was successful. 2021-05-26 13:49:35.474 -04:00 [INF] Entity Framework Core 5.0.5 initialized 'SettingManagementDbContext' using provider 'Oracle.EntityFrameworkCore' with options: QuerySplittingBehavior=SplitQuery 2021-05-26 13:49:35.477 -04:00 [INF] Executed DbCommand (2ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.478 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.479 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.481 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.482 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.484 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.485 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.487 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.488 -04:00 [INF] Executed DbCommand (1ms) [Parameters=[:name_0='?' (Size = 128), :providerName_1='?' (Size = 64)], CommandType='"Text"', CommandTimeout='0'] SELECT "s"."Id", "s"."Name", "s"."ProviderKey", "s"."ProviderName", "s"."Value" FROM "IDM"."Settings" "s" WHERE (((("s"."Name" = :name_0) AND ("s"."ProviderName" = :providerName_1))) AND ("s"."ProviderKey" IS NULL)) ORDER BY "s"."Id" FETCH FIRST 1 ROWS ONLY 2021-05-26 13:49:35.488 -04:00 [INF] Entity Framework Core 5.0.5 initialized 'AbpAuditLoggingDbContext' using provider 'Oracle.EntityFrameworkCore' with options: QuerySplittingBehavior=SplitQuery 2021-05-26 13:49:35.492 -04:00 [INF] Executed DbCommand (2ms) [Parameters=[:p0='?' (DbType = Binary), :p1='?' (Size = 96), :p2='?' (Size = 512), :p3='?' (Size = 64), :p4='?' (Size = 64), :p5='?' (Size = 128), :p6='?' (Size = 256), :p7='?' (Size = 40), :p8='?' (Size = 64), :p9='?' (Size = 2000), :p10='?' (DbType = Int32), :p11='?' (DbType = DateTime), :p12='?' (Size = 2000), :p13='?' (Size = 16), :p14='?' (DbType = Int32), :p15='?' (DbType = Binary), :p16='?' (DbType = Binary), :p17='?' (DbType = Binary), :p18='?' (Size = 2000), :p19='?' (Size = 256), :p20='?' (DbType = Binary), :p21='?' (Size = 256)], CommandType='"Text"', CommandTimeout='0'] BEGIN

    INSERT INTO "IDM"."AuditLogs" ("Id", "ApplicationName", "BrowserInfo", "ClientId", "ClientIpAddress", "ClientName", "Comments", "ConcurrencyStamp", "CorrelationId", "Exceptions", "ExecutionDuration", "ExecutionTime", "ExtraProperties", "HttpMethod", "HttpStatusCode", "ImpersonatorTenantId", "ImpersonatorUserId", "TenantId", "TenantName", "Url", "UserId", "UserName") VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21); END; 2021-05-26 13:49:35.495 -04:00 [INF] Executed DbCommand (2ms) [Parameters=[:p22='?' (DbType = Binary), :p23='?' (DbType = Binary), :p24='?' (DbType = Int32), :p25='?' (DbType = DateTime), :p26='?' (Size = 2000), :p27='?' (Size = 128), :p28='?' (Size = 2000), :p29='?' (Size = 256), :p30='?' (DbType = Binary)], CommandType='"Text"', CommandTimeout='0'] BEGIN

    INSERT INTO "IDM"."AuditLogActions" ("Id", "AuditLogId", "ExecutionDuration", "ExecutionTime", "ExtraProperties", "MethodName", "Parameters", "ServiceName", "TenantId") VALUES (:p22, :p23, :p24, :p25, :p26, :p27, :p28, :p29, :p30); END; 2021-05-26 13:49:35.501 -04:00 [ERR] 2021-05-26 13:49:35.501753 ThreadID:20 (ERROR) OracleRelationalCommand.ExecuteReaderAsync() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("IDM"."Settings"."Value") ORA-06512: at line 3 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) 2021-05-26 13:49:35.501 -04:00 [ERR] Failed executing DbCommand (2ms) [Parameters=[:p0='?' (DbType = Binary), :p1='?' (Size = 128), :p2='?' (Size = 64), :p3='?' (Size = 64), :p4='?' (Size = 2000), :p5='?' (DbType = Binary), :p6='?' (Size = 128), :p7='?' (Size = 64), :p8='?' (Size = 64), :p9='?' (Size = 2000), :p10='?' (DbType = Binary), :p11='?' (Size = 128), :p12='?' (Size = 64), :p13='?' (Size = 64), :p14='?' (Size = 2000), :p15='?' (DbType = Binary), :p16='?' (Size = 128), :p17='?' (Size = 64), :p18='?' (Size = 64), :p19='?' (Size = 2000)], CommandType='"Text"', CommandTimeout='0'] BEGIN

    INSERT INTO "IDM"."Settings" ("Id", "Name", "ProviderKey", "ProviderName", "Value") VALUES (:p0, :p1, :p2, :p3, :p4); INSERT INTO "IDM"."Settings" ("Id", "Name", "ProviderKey", "ProviderName", "Value") VALUES (:p5, :p6, :p7, :p8, :p9); INSERT INTO "IDM"."Settings" ("Id", "Name", "ProviderKey", "ProviderName", "Value") VALUES (:p10, :p11, :p12, :p13, :p14); INSERT INTO "IDM"."Settings" ("Id", "Name", "ProviderKey", "ProviderName", "Value") VALUES (:p15, :p16, :p17, :p18, :p19); END; 2021-05-26 13:49:35.503 -04:00 [ERR] An error occurred using a transaction. 2021-05-26 13:49:35.504 -04:00 [ERR] 2021-05-26 13:49:35.504688 ThreadID:20 (ERROR) OracleExecutionStrategy.ExecuteAsync() : Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("IDM"."Settings"."Value") ORA-06512: at line 3 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) --- End of inner exception stack trace --- at Microsoft.EntityFrameworkCore.Update.ReaderModificationCommandBatch.ExecuteAsync(IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Update.Internal.BatchExecutor.ExecuteAsync(IEnumerable1 commandBatches, IRelationalConnection connection, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(IList1 entriesToSave, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.ChangeTracking.Internal.StateManager.SaveChangesAsync(DbContext _, Boolean acceptAllChangesOnSuccess, CancellationToken cancellationToken) at Oracle.EntityFrameworkCore.Storage.Internal.OracleExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) 2021-05-26 13:49:35.505 -04:00 [ERR] An exception occurred in the database while saving changes for context type 'Volo.Abp.SettingManagement.EntityFrameworkCore.SettingManagementDbContext'. Microsoft.EntityFrameworkCore.DbUpdateException: An error occurred while updating the entries. See the inner exception for details. ---> Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01400: cannot insert NULL into ("IDM"."Settings"."Value") ORA-06512: at line 3 at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone) at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken) --- End of stack trace from previous location --- at

  • User Avatar
    0
    liangshiwei created
    Support Team Fullstack Developer

    HI,

    Can I check it remotely? shiwei.liang@volosoft.com

  • User Avatar
    0
    ServiceBot created
    Support Team Automatic process manager

    This question has been automatically marked as stale because it has not had recent activity.

Made with ❤️ on ABP v9.1.0-preview. Updated on December 05, 2024, 12:19