Hi,
Thanks for the reply
I am try to login Host side with enable Identity server.
& try to remote debugging but getting null user so its redirect index page after successfull login.
Find user on loginResult with succeed result
but getting null in session user.
Log file details https://drive.google.com/file/d/1Lldbza1jkSwIvUh_PXEM1eSbC69U6Ruc/view?usp=sharing
WHERE (((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_1 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL)) AND ([a].[Id] = @__p_0) INFO 2021-06-07 21:19:00,348 [27 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:00,607 [27 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (121ms) [Parameters=[@__ef_filter__p_2='?' (DbType = Boolean), @__ef_filter__p_3='?' (DbType = Boolean), @__ef_filter__p_0='?' (DbType = Boolean), @__user_Id_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SELECT [t].[Name] FROM [AbpUserRoles] AS [a]
INNER JOIN ( SELECT [a0].[OrganizationUnitId], [a0].[RoleId] FROM [AbpOrganizationUnitRoles] AS [a0] WHERE ((@__ef_filter__p_3 = CAST(1 AS bit)) OR ([a0].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_4 = CAST(1 AS bit)) OR [a0].[TenantId] IS NULL) ) AS [t] ON [a].[OrganizationUnitId] = [t].[OrganizationUnitId] INNER JOIN ( SELECT [a1].[Id], [a1].[Name] FROM [AbpRoles] AS [a1] WHERE ((@__ef_filter__p_6 = CAST(1 AS bit)) OR ([a1].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_7 = CAST(1 AS bit)) OR [a1].[TenantId] IS NULL) ) AS [t0] ON [t].[RoleId] = [t0].[Id] WHERE (((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_1 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL)) AND ([a].[UserId] = @__user_Id_0) INFO 2021-06-07 21:19:00,894 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:01,141 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (120ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__ef_filter__p_1='?' (DbType = Boolean), @__normalizedName_0='?' (Size = 32)], CommandType='Text', CommandTimeout='30'] SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[DisplayName], [a].[IsDefault], [a].[IsDeleted], [a].[IsStatic], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[NormalizedName], [a].[TenantId] FROM [AbpRoles] AS [a] WHERE (((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_1 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL)) AND ([a].[NormalizedName] = @__normalizedName_0) INFO 2021-06-07 21:19:01,291 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:01,543 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (122ms) WHERE (((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ((@__ef_filter__p_1 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL)) AND ([a].[Id] = @__p_0) INFO 2021-06-07 21:19:02,060 [26 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:02,315 [26 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (122ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__roleId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SELECT [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[Discriminator], [a].[IsGranted], [a].[Name], [a].[TenantId], [a].[RoleId] FROM [AbpPermissions] AS [a] WHERE (([a].[Discriminator] = N'RolePermissionSetting') AND ((@__ef_filter__p_0 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL)) AND ([a].[RoleId] = @__roleId_0) INFO 2021-06-07 21:19:02,956 [26 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None WARN 2021-06-07 21:19:03,162 [26 ] EntityFrameworkCore.Database.Transaction - Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(RelationalEventId.SavepointsDisabledBecauseOfMARS))'. INFO 2021-06-07 21:19:03,386 [27 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (219ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = Int64), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (Size = 512), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (Size = 1) (DbType = Byte), @p8='?' (DbType = Int16)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AbpBackgroundJobs] ([CreationTime], [CreatorUserId], [IsAbandoned], [JobArgs], [JobType], [LastTryTime], [NextTryTime], [Priority], [TryCount]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8); SELECT [Id] FROM [AbpBackgroundJobs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); INFO 2021-06-07 21:19:03,512 [27 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (123ms) [Parameters=[@p0='?' (DbType = Guid), @p1='?' (Size = -1) (DbType = Binary), @p2='?' (Size = 4000), @p3='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AppBinaryObjects] ([Id], [Bytes], [Description], [TenantId]) VALUES (@p0, @p1, @p2, @p3); INFO 2021-06-07 21:19:03,651 [27 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None WARN 2021-06-07 21:19:03,772 [27 ] EntityFrameworkCore.Database.Transaction - Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(RelationalEventId.SavepointsDisabledBecauseOfMARS))'. INFO 2021-06-07 21:19:03,893 [26 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (120ms) [Parameters=[@p0='?' (Size = 512), @p1='?' (Size = 64), @p2='?' (Size = 128), @p3='?' (Size = 2000), @p4='?' (Size = 2000), @p5='?' (Size = 1024), @p6='?' (DbType = Int32), @p7='?' (DbType = DateTime2), @p8='?' (DbType = Int32), @p9='?' (DbType = Int64), @p10='?' (Size = 256), @p11='?' (Size = 1024), @p12='?' (Size = 4000), @p13='?' (Size = 256), @p14='?' (DbType = Int32), @p15='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; INSERT INTO [AbpAuditLogs] ([BrowserInfo], [ClientIpAddress], [ClientName], [CustomData], [Exception], [ExceptionMessage], [ExecutionDuration], [ExecutionTime], [ImpersonatorTenantId], [ImpersonatorUserId], [MethodName], [Parameters], [ReturnValue], [ServiceName], [TenantId], [UserId]) VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15); SELECT [Id] FROM [AbpAuditLogs] WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity(); INFO 2021-06-07 21:19:04,028 [26 ] tonsoftJson.NewtonsoftJsonResultExecutor - Executing JsonResult, writing value of type 'Abp.Web.Models.AjaxResponse'. INFO 2021-06-07 21:19:04,037 [26 ] c.Infrastructure.ControllerActionInvoker - Executed action SmartSuite.Web.Controllers.UsersController.ImportFromExcel (SmartSuite.Web.Host) in 4098.3742ms INFO 2021-06-07 21:19:04,038 [26 ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'SmartSuite.Web.Controllers.UsersController.ImportFromExcel (SmartSuite.Web.Host)' INFO 2021-06-07 21:19:04,039 [25 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/2 POST https://localhost:44388/Users/ImportFromExcel multipart/form-data;+boundary=----WebKitFormBoundaryWk4KQga0Hl9W2dIx 11315 - 200 - application/json;+charset=utf-8 4139.0746ms INFO 2021-06-07 21:19:04,577 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:04,817 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (120ms) [Parameters=[@__p_1='?' (DbType = Int32), @__Now_0='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30'] SELECT TOP(@__p_1) [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[IsAbandoned], [a].[JobArgs], [a].[JobType], [a].[LastTryTime], [a].[NextTryTime], [a].[Priority], [a].[TryCount] FROM [AbpBackgroundJobs] AS [a] WHERE ([a].[IsAbandoned] <> CAST(1 AS bit)) AND ([a].[NextTryTime] <= @__Now_0) ORDER BY [a].[Priority] DESC, [a].[TryCount], [a].[NextTryTime] WARN 2021-06-07 21:19:05,002 [25 ] Abp.BackgroundJobs.BackgroundJobManager - Object does not match target type. System.Reflection.TargetException: Object does not match target type. at System.Reflection.RuntimeMethodInfo.CheckConsistency(Object target) at System.Reflection.RuntimeMethodInfo.InvokeArgumentsCheck(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at Abp.BackgroundJobs.BackgroundJobManager.TryProcessJobAsync(BackgroundJobInfo jobInfo) INFO 2021-06-07 21:19:05,044 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None WARN 2021-06-07 21:19:05,168 [25 ] EntityFrameworkCore.Database.Transaction - Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(RelationalEventId.SavepointsDisabledBecauseOfMARS))'. INFO 2021-06-07 21:19:05,298 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (126ms) [Parameters=[@p9='?' (DbType = Int64), @p0='?' (DbType = DateTime2), @p1='?' (DbType = Int64), @p2='?' (DbType = Boolean), @p3='?' (Size = 4000), @p4='?' (Size = 512), @p5='?' (DbType = DateTime2), @p6='?' (DbType = DateTime2), @p7='?' (Size = 1) (DbType = Byte), @p8='?' (DbType = Int16)], CommandType='Text', CommandTimeout='30'] SET NOCOUNT ON; UPDATE [AbpBackgroundJobs] SET [CreationTime] = @p0, [CreatorUserId] = @p1, [IsAbandoned] = @p2, [JobArgs] = @p3, [JobType] = @p4, [LastTryTime] = @p5, [NextTryTime] = @p6, [Priority] = @p7, [TryCount] = @p8 WHERE [Id] = @p9; SELECT @@ROWCOUNT; INFO 2021-06-07 21:19:10,458 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:10,700 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (120ms) [Parameters=[@__p_1='?' (DbType = Int32), @__Now_0='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30'] SELECT TOP(@__p_1) [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[IsAbandoned], [a].[JobArgs], [a].[JobType], [a].[LastTryTime], [a].[NextTryTime], [a].[Priority], [a].[TryCount] FROM [AbpBackgroundJobs] AS [a] WHERE ([a].[IsAbandoned] <> CAST(1 AS bit)) AND ([a].[NextTryTime] <= @__Now_0) ORDER BY [a].[Priority] DESC, [a].[TryCount], [a].[NextTryTime] INFO 2021-06-07 21:19:15,837 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None INFO 2021-06-07 21:19:16,091 [25 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (130ms) [Parameters=[@__p_1='?' (DbType = Int32), @__Now_0='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30'] SELECT TOP(@__p_1) [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[IsAbandoned], [a].[JobArgs], [a].[JobType], [a].[LastTryTime], [a].[NextTryTime], [a].[Priority], [a].[TryCount] FROM [AbpBackgroundJobs] AS [a] WHERE ([a].[IsAbandoned] <> CAST(1 AS bit)) AND ([a].[NextTryTime] <= @__Now_0) ORDER BY [a].[Priority] DESC, [a].[TryCount], [a].[NextTryTime] INFO 2021-06-07 21:19:21,238 [25 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None 22:39:43,011 [49 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'SmartSuiteDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None WARN 2021-06-07 22:39:43,132 [49 ] EntityFrameworkCore.Database.Transaction - Savepoints are disabled because Multiple Active Result Sets (MARS) is enabled. If 'SaveChanges' fails, then the transaction cannot be automatically rolled back to a known clean state. Instead, the transaction should be rolled back by the application before retrying 'SaveChanges'. See https://go.microsoft.com/fwlink/?linkid=2149338 for more information. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(RelationalEventId.SavepointsDisabledBecauseOfMARS))'. INFO 2021-06-07 22:39:43,147 [5 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/2 OPTIONS https://localhost:44388/Users/ImportFromExcel - - INFO 2021-06-07 22:39:43,148 [5 ] pNetCore.Cors.Infrastructure.CorsService - CORS policy execution successful. INFO 2021-06-07 22:39:43,148 [5 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/2 OPTIONS https://localhost:44388/Users/ImportFromExcel - - - 204 - - 0.8641ms INFO 2021-06-07 22:39:43,159 [49 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/2 POST https://localhost:44388/Users/ImportFromExcel multipart/form-data;+boundary=----WebKitFormBoundaryas6QA0AEApQRtNMZ 10393 INFO 2021-06-07 22:39:43,159 [49 ] pNetCore.Cors.Infrastructure.CorsService - CORS policy execution successful. INFO 2021-06-07 22:39:43,197 [49 ] uthentication.JwtBearer.JwtBearerHandler - Successfully validated the token. INFO 2021-06-07 22:39:43,198 [49 ] uthorization.DefaultAuthorizationService - Authorization was successful. INFO 2021-06-07 22:39:43,198 [49 ] ft.AspNetCore.Routing.EndpointMiddleware - Executing endpoint 'SmartSuite.Web.Controllers.UsersController.ImportFromExcel (SmartSuite.Web.Host)' INFO 2021-06-07 22:39:43,205 [49 ] c.Infrastructure.ControllerActionInvoker - Route matched with {action = "ImportFromExcel", controller = "Users", area = ""}. Executing controller action with signature System.Threading.Tasks.Task 1[Microsoft.AspNetCore.Mvc.JsonResult] ImportFromExcel() on controller SmartSuite.Web.Controllers.UsersController
Same issue, not able to download metronic theme. Also, How we can download version 8 of metronic theme ?
Hi @ismcagdas is there any update on the above issue
Hi @ismcagdas is there any update on the above issue
I have send it the credientials [email protected]. with ticket
I have send it the credientials [email protected]. with ticket
Hi @ismcagdas , I will give you the credientials for accessing the application, please share your email
Thanks
Hi @ismcagdas , I will give you the credientials for accessing the application, please share your email
Thanks
Hi @ismcagdas , no in normal window we are facing this issue and also now when I am trying to access the API in post man it gives me unsuppoerted media type as error
and also I have tried https://support.aspnetzero.com/QA/Questions/6969/Error-405-on-Swagger-with-update-and-delete-service#answer-22bcbe8f-c259-b28b-3e98-39eda8d8ab08 but is not working
