Import from excel user not working & Move tenant to another editions also not working. #10367

shedspotter created 3 years ago

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

Import from excel user not working & Move tenant to another editions also not working. #10367

2 Answer(s)