<?xml version="1.0" encoding="utf-8"?> <configuration> <location path="." inheritInChildApplications="false"> <system.webServer> <handlers> <add name="aspNetCore" path="" verb="" modules="AspNetCoreModuleV2" resourceType="Unspecified" /> </handlers> <aspNetCore processPath=".\Mcp.IdentityManager.Web.exe" stdoutLogEnabled="false" stdoutLogFile=".\logs\stdout" hostingModel="InProcess" /> </system.webServer> </location> </configuration> <!--ProjectGuid: 6FE54035-9C11-4702-A5E2-D16F23101468-->
{
"App": {
"SelfUrl": "https://dev-idm.testdomain.com"
},
"RemoteServices": {
"Default": {
"BaseUrl": "https://dev-idm.testdomain/idmapi/"
}
},
"Redis": {
"Configuration": "127.0.0.1"
},
"AuthServer": {
"Authority": "https://dev-ids.testdomain.com/",
"RequireHttpsMetadata": "true",
"ClientId": "IdentityManager_Web",
"ClientSecret": "1q2w3e*"
},
"StringEncryption": {
"DefaultPassPhrase": "KdJ301s5dk73YlJq"
},
"AbpLicenseCode": ""
}
hi you need web.confg or appsetting
i done all table prefix - only missing is "AbpPermissionGrants".. unable to set prefix ? please help me on this?
i done all table prefix - only missing is "AbpPermissionGrants".. unable to set prefix ? please help me on this?
so how can get my cutom propertiy if have added as USER_ID_NH (DEFAULT SEQ),, Then get this value from token
let say if have added USER_ID AS CUSTOM FILED, this can get from token as token claims
it is not working as tested
I am trying to create the EFCore Oracle tables, but we need have all tables as PK as Int or Long or Decimal .. Is there any way custmizse. as you ASP.NET ALL TABLES AS custom ID
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.