Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

OData return 500 error #6243

Closed
MohammadMobasher opened this issue Sep 1, 2021 · 12 comments
Closed

OData return 500 error #6243

MohammadMobasher opened this issue Sep 1, 2021 · 12 comments
Labels
wontfix

Comments

@MohammadMobasher
Copy link

MohammadMobasher commented Sep 1, 2021 •
edited
Loading

hi guys
i recently use this framework and i want to use OData. everything are ok like

  1. expane
  2. filter
  3. count
    and so on, but when i want to use aggregate the endpoint response 500 error without any other info, just 500 error.

my configuration is :

startup.cs
builder.EntitySet<TestTbl>("TestTbl").EntityType.Count().Filter().OrderBy().Expand().Select().Page().;

TestTblController.cs

public override IQueryable<TestTbl> Get() { return this._repository.GetAll().Include("Tenant"); }

and my url is:
/odata/testTbl?$count=true&$apply=aggregate($count as testCount)
or
/odata/testTbl?$count=true&$apply=groupby((Name),aggregate($count as Total))

on both url i got this error and i don't know what should i do? please help me
tanks
@ismcagdas
Copy link
Member

Hi @MohammadMobasher

The detailed error log should be written to server side log file. Can you check it to see the error details? You can find it under App_Data/Logs folder of your web project.

@MohammadMobasher
Copy link
Author

this is the error

DEBUG 2021-09-04 07:45:47,923 [1    ] Abp.Modules.AbpModuleManager             - Loading Abp modules...
DEBUG 2021-09-04 07:45:47,937 [1    ] Abp.Modules.AbpModuleManager             - Found 16 ABP modules in total.
DEBUG 2021-09-04 07:45:47,952 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: markaz.Web.Host.Startup.markazWebHostModule, markaz.Web.Host, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,954 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: markaz.markazWebCoreModule, markaz.Web.Core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,954 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: markaz.markazApplicationModule, markaz.Application, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,954 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: markaz.markazCoreModule, markaz.Core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,954 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.AbpZeroCoreModule, Abp.ZeroCore, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,954 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.AbpZeroCommonModule, Abp.Zero.Common, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,955 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AbpKernelModule, Abp, Version=6.3.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,955 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AutoMapper.AbpAutoMapperModule, Abp.AutoMapper, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,955 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: markaz.EntityFrameworkCore.markazEntityFrameworkModule, markaz.EntityFrameworkCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,955 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Zero.EntityFrameworkCore.AbpZeroCoreEntityFrameworkCoreModule, Abp.ZeroCore.EntityFrameworkCore, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,955 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.EntityFrameworkCore.AbpEntityFrameworkCoreModule, Abp.EntityFrameworkCore, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,956 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.EntityFramework.AbpEntityFrameworkCommonModule, Abp.EntityFramework.Common, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,956 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetCore.AbpAspNetCoreModule, Abp.AspNetCore, Version=6.3.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,956 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.Web.AbpWebCommonModule, Abp.Web.Common, Version=6.3.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,956 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetCore.SignalR.AbpAspNetCoreSignalRModule, Abp.AspNetCore.SignalR, Version=6.3.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,956 [1    ] Abp.Modules.AbpModuleManager             - Loaded module: Abp.AspNetCore.OData.AbpAspNetCoreODataModule, Abp.AspNetCore.OData, Version=6.3.1.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:47,959 [1    ] Abp.Modules.AbpModuleManager             - 16 modules loaded.
DEBUG 2021-09-04 07:45:48,001 [1    ] o.Configuration.LanguageManagementConfig - Converted Abp (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2021-09-04 07:45:48,001 [1    ] o.Configuration.LanguageManagementConfig - Converted AbpZero (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2021-09-04 07:45:48,001 [1    ] o.Configuration.LanguageManagementConfig - Converted markaz (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2021-09-04 07:45:48,001 [1    ] o.Configuration.LanguageManagementConfig - Converted AbpWeb (Abp.Localization.Dictionaries.DictionaryBasedLocalizationSource) to MultiTenantLocalizationSource
DEBUG 2021-09-04 07:45:48,237 [1    ] ameworkCore.AbpEntityFrameworkCoreModule - Registering DbContext: markaz.EntityFrameworkCore.markazDbContext, markaz.EntityFrameworkCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null
DEBUG 2021-09-04 07:45:48,598 [1    ] Abp.Localization.LocalizationManager     - Initializing 4 localization sources.
DEBUG 2021-09-04 07:45:48,631 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: Abp
DEBUG 2021-09-04 07:45:48,639 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: AbpZero
DEBUG 2021-09-04 07:45:48,644 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: markaz
DEBUG 2021-09-04 07:45:48,647 [1    ] Abp.Localization.LocalizationManager     - Initialized localization source: AbpWeb
DEBUG 2021-09-04 07:45:48,691 [1    ] Abp.BackgroundJobs.BackgroundJobManager  - Start background worker: Castle.Proxies.BackgroundJobManagerProxy
DEBUG 2021-09-04 07:45:48,713 [1    ] , Culture=neutral, PublicKeyToken=null]] - Start background worker: Abp.Authorization.Users.UserTokenExpirationWorker`2[[markaz.MultiTenancy.Tenant, markaz.Core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null],[markaz.Authorization.Users.User, markaz.Core, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]
DEBUG 2021-09-04 07:45:48,747 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - Found 20 classes define auto mapping attributes
DEBUG 2021-09-04 07:45:48,747 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Models.TokenAuth.ExternalLoginProviderInfoModel
DEBUG 2021-09-04 07:45:48,752 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Users.Dto.CreateUserDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Users.Dto.UserDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Test.Dto.CreateTestTblDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Test.Dto.TestDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Sessions.Dto.TenantLoginInfoDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Sessions.Dto.UserLoginInfoDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.Roles.Dto.PermissionDto
DEBUG 2021-09-04 07:45:48,753 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.MultiTenancy.Dto.CreateTenantDto
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.MultiTenancy.Dto.TenantDto
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DetailGroupCoding.DTO.CreateDetailGroupCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DetailGroupCoding.DTO.DetailGroupCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DetailCoding.DTO.CreateDetailCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DetailCoding.DTO.DetailCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DefaultCoding.DTO.CreateDefaultCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DefaultCoding.DTO.DefaultCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DefaultCoding.DTO.CreateStandardCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.DefaultCoding.DTO.StandardCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.AccountCoding.DTO.AccountCodingDTO
DEBUG 2021-09-04 07:45:48,754 [1    ] Abp.AutoMapper.AbpAutoMapperModule       - markaz.AccountCoding.DTO.CreateAccountCodingDTO
WARN  2021-09-04 07:45:49,714 [1    ] oft.EntityFrameworkCore.Model.Validation - Entity 'Edition' has a global query filter defined and is the required end of a relationship with the entity 'EditionFeatureSetting'. This may lead to unexpected results when the required entity is filtered out. Either configure the navigation as optional, or define matching query filters for both entities in the navigation. See https://go.microsoft.com/fwlink/?linkid=2131316 for more information.
INFO  2021-09-04 07:45:49,874 [1    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:50,327 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (19ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[DisplayName], [a].[IsDeleted], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name]
FROM [AbpEditions] AS [a]
WHERE [a].[Name] = N'Standard'
INFO  2021-09-04 07:45:50,464 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (18ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,468 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,469 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,470 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,472 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,473 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,474 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,475 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,476 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,477 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,478 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,479 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,480 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__language_Name_1='?' (Size = 128)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpLanguages] AS [a]
        WHERE [a].[TenantId] IS NULL AND ([a].[Name] = @__language_Name_1)) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,491 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[Description], [a].[DisplayName], [a].[IsDefault], [a].[IsDeleted], [a].[IsStatic], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[NormalizedName], [a].[TenantId]
FROM [AbpRoles] AS [a]
WHERE [a].[TenantId] IS NULL AND ([a].[Name] = N'Admin')
INFO  2021-09-04 07:45:50,544 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (5ms) [Parameters=[@__adminRoleForHost_Id_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Name]
FROM [AbpPermissions] AS [a]
WHERE ([a].[Discriminator] = N'RolePermissionSetting') AND ([a].[TenantId] IS NULL AND ([a].[RoleId] = @__adminRoleForHost_Id_0))
INFO  2021-09-04 07:45:50,555 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[AuthenticationSource], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[EmailAddress], [a].[EmailConfirmationCode], [a].[IsActive], [a].[IsDeleted], [a].[IsEmailConfirmed], [a].[IsLockoutEnabled], [a].[IsPhoneNumberConfirmed], [a].[IsTwoFactorEnabled], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[LockoutEndDateUtc], [a].[Name], [a].[NormalizedEmailAddress], [a].[NormalizedUserName], [a].[Password], [a].[PasswordResetCode], [a].[PhoneNumber], [a].[SecurityStamp], [a].[Surname], [a].[TenantId], [a].[UserName]
FROM [AbpUsers] AS [a]
WHERE [a].[TenantId] IS NULL AND ([a].[UserName] = N'admin')
INFO  2021-09-04 07:45:50,633 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__name_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpSettings] AS [a]
        WHERE (([a].[Name] = @__name_0) AND [a].[TenantId] IS NULL) AND [a].[UserId] IS NULL) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,634 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__name_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpSettings] AS [a]
        WHERE (([a].[Name] = @__name_0) AND [a].[TenantId] IS NULL) AND [a].[UserId] IS NULL) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,636 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [Parameters=[@__name_0='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM [AbpSettings] AS [a]
        WHERE (([a].[Name] = @__name_0) AND [a].[TenantId] IS NULL) AND [a].[UserId] IS NULL) THEN CAST(1 AS bit)
    ELSE CAST(0 AS bit)
END
INFO  2021-09-04 07:45:50,695 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConnectionString], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[EditionId], [a].[IsActive], [a].[IsDeleted], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[TenancyName]
FROM [AbpTenants] AS [a]
WHERE [a].[TenancyName] = N'Default'
INFO  2021-09-04 07:45:50,728 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [Parameters=[@___tenantId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[Description], [a].[DisplayName], [a].[IsDefault], [a].[IsDeleted], [a].[IsStatic], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[NormalizedName], [a].[TenantId]
FROM [AbpRoles] AS [a]
WHERE ([a].[TenantId] = @___tenantId_0) AND ([a].[Name] = N'Admin')
INFO  2021-09-04 07:45:50,734 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (3ms) [Parameters=[@___tenantId_0='?' (DbType = Int32), @__adminRole_Id_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Name]
FROM [AbpPermissions] AS [a]
WHERE ([a].[Discriminator] = N'RolePermissionSetting') AND (([a].[TenantId] = @___tenantId_0) AND ([a].[RoleId] = @__adminRole_Id_1))
INFO  2021-09-04 07:45:50,744 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (5ms) [Parameters=[@___tenantId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[AccessFailedCount], [a].[AuthenticationSource], [a].[ConcurrencyStamp], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[EmailAddress], [a].[EmailConfirmationCode], [a].[IsActive], [a].[IsDeleted], [a].[IsEmailConfirmed], [a].[IsLockoutEnabled], [a].[IsPhoneNumberConfirmed], [a].[IsTwoFactorEnabled], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[LockoutEndDateUtc], [a].[Name], [a].[NormalizedEmailAddress], [a].[NormalizedUserName], [a].[Password], [a].[PasswordResetCode], [a].[PhoneNumber], [a].[SecurityStamp], [a].[Surname], [a].[TenantId], [a].[UserName]
FROM [AbpUsers] AS [a]
WHERE ([a].[TenantId] = @___tenantId_0) AND ([a].[UserName] = N'admin')
INFO  2021-09-04 07:45:50,791 [1    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:50,810 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (5ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__ef_filter__p_1='?' (DbType = Boolean)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[DisplayName], [a].[Icon], [a].[IsDeleted], [a].[IsDisabled], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[TenantId]
FROM [AbpLanguages] 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)
INFO  2021-09-04 07:45:50,888 [1    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:50,904 [1    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean)], CommandType='Text', CommandTimeout='30']
SELECT [a].[Id], [a].[CreationTime], [a].[CreatorUserId], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[TenantId], [a].[UserId], [a].[Value]
FROM [AbpSettings] AS [a]
WHERE ((@__ef_filter__p_0 = CAST(1 AS bit)) OR [a].[TenantId] IS NULL) AND ([a].[UserId] IS NULL AND [a].[TenantId] IS NULL)
INFO  2021-09-04 07:45:50,936 [1    ] tCore.Builder.RequestLocalizationOptions - Supported Request Localization Cultures: es-MX,fr,de,it,nl,pt-BR,tr,ru,ar,fa,ja,zh-Hans
INFO  2021-09-04 07:45:52,005 [1    ] taProtection.KeyManagement.XmlKeyManager - User profile is available. Using 'C:\Users\m.mobasher\AppData\Local\ASP.NET\DataProtection-Keys' as key repository and Windows DPAPI to encrypt keys at rest.
INFO  2021-09-04 07:45:52,053 [6    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/ - -
INFO  2021-09-04 07:45:52,140 [6    ] ft.AspNetCore.Routing.EndpointMiddleware - Executing endpoint 'markaz.Web.Host.Controllers.HomeController.Index (markaz.Web.Host)'
INFO  2021-09-04 07:45:53,273 [6    ] c.Infrastructure.ControllerActionInvoker - Route matched with {action = "Index", controller = "Home", area = ""}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult Index() on controller markaz.Web.Host.Controllers.HomeController (markaz.Web.Host).
INFO  2021-09-04 07:45:53,665 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:53,681 [6    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (6ms) [Parameters=[@__ef_filter__p_0='?' (DbType = Boolean), @__p_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [a].[Id], [a].[ConnectionString], [a].[CreationTime], [a].[CreatorUserId], [a].[DeleterUserId], [a].[DeletionTime], [a].[EditionId], [a].[IsActive], [a].[IsDeleted], [a].[LastModificationTime], [a].[LastModifierUserId], [a].[Name], [a].[TenancyName]
FROM [AbpTenants] AS [a]
WHERE ((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([a].[IsDeleted] <> CAST(1 AS bit))) AND ([a].[Id] = @__p_0)
INFO  2021-09-04 07:45:53,700 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:53,725 [9    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:53,747 [9    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (3ms) [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-09-04 07:45:53,828 [5    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (8ms) [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-09-04 07:45:53,881 [5    ] vc.Infrastructure.RedirectResultExecutor - Executing RedirectResult, redirecting to /swagger.
INFO  2021-09-04 07:45:53,885 [5    ] c.Infrastructure.ControllerActionInvoker - Executed action markaz.Web.Host.Controllers.HomeController.Index (markaz.Web.Host) in 608.3351ms
INFO  2021-09-04 07:45:53,886 [5    ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'markaz.Web.Host.Controllers.HomeController.Index (markaz.Web.Host)'
INFO  2021-09-04 07:45:53,900 [8    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/ - - - 302 - - 1847.6744ms
INFO  2021-09-04 07:45:53,900 [5    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/swagger/index.html - -
INFO  2021-09-04 07:45:53,999 [6    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/swagger/index.html - - - 200 - text/html;charset=utf-8 99.5173ms
INFO  2021-09-04 07:45:54,649 [5    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/_framework/aspnetcore-browser-refresh.js - -
INFO  2021-09-04 07:45:54,651 [5    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/_framework/aspnetcore-browser-refresh.js - - - 200 3090 application/javascript;+charset=utf-8 1.8259ms
INFO  2021-09-04 07:45:56,173 [5    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/AntiForgery/SetCookie - -
INFO  2021-09-04 07:45:56,177 [5    ] ft.AspNetCore.Routing.EndpointMiddleware - Executing endpoint 'markaz.Web.Host.Controllers.AntiForgeryController.SetCookie (markaz.Web.Host)'
INFO  2021-09-04 07:45:56,181 [5    ] c.Infrastructure.ControllerActionInvoker - Route matched with {action = "SetCookie", controller = "AntiForgery", area = ""}. Executing controller action with signature Void SetCookie() on controller markaz.Web.Host.Controllers.AntiForgeryController (markaz.Web.Host).
INFO  2021-09-04 07:45:56,190 [5    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:56,194 [5    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:45:56,200 [5    ] .Mvc.Infrastructure.ObjectResultExecutor - Executing ObjectResult, writing value of type 'Abp.Web.Models.AjaxResponse'.
INFO  2021-09-04 07:45:56,262 [6    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/swagger/v1/swagger.json - -
INFO  2021-09-04 07:45:56,268 [5    ] c.Infrastructure.ControllerActionInvoker - Executed action markaz.Web.Host.Controllers.AntiForgeryController.SetCookie (markaz.Web.Host) in 86.0791ms
INFO  2021-09-04 07:45:56,268 [5    ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'markaz.Web.Host.Controllers.AntiForgeryController.SetCookie (markaz.Web.Host)'
INFO  2021-09-04 07:45:56,269 [5    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/AntiForgery/SetCookie - - - 200 101 application/json;+charset=utf-8 95.7374ms
INFO  2021-09-04 07:45:56,487 [8    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/swagger/v1/swagger.json - - - 200 - application/json;charset=utf-8 224.5714ms
INFO  2021-09-04 07:45:58,776 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:45:58,782 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:03,812 [5    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:03,815 [5    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:08,828 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:08,831 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:13,843 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:13,845 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:18,864 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:18,867 [6    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:23,892 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:23,896 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:28,910 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:28,913 [6    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:33,926 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:33,930 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (2ms) [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-09-04 07:46:38,947 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:38,951 [6    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:43,967 [8    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:43,971 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:47,791 [6    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request starting HTTP/1.1 GET http://localhost:21021/odata/testTbl?$apply=groupby((Name),aggregate(Id%20with%20sum%20as%20aa)) - -
INFO  2021-09-04 07:46:47,987 [6    ] ft.AspNetCore.Routing.EndpointMiddleware - Executing endpoint 'markaz.Web.Host.Controllers.TestTblController.Get (markaz.Web.Host)'
INFO  2021-09-04 07:46:47,999 [6    ] c.Infrastructure.ControllerActionInvoker - Route matched with {action = "Get", controller = "TestTbl", area = ""}. Executing controller action with signature System.Linq.IQueryable`1[markaz.TestTable.TestTbl] Get() on controller markaz.Web.Host.Controllers.TestTblController (markaz.Web.Host).
INFO  2021-09-04 07:46:48,122 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:48,165 [6    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:48,169 [8    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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-09-04 07:46:48,228 [8    ] c.Infrastructure.ControllerActionInvoker - Executed action markaz.Web.Host.Controllers.TestTblController.Get (markaz.Web.Host) in 228.9268ms
INFO  2021-09-04 07:46:48,228 [8    ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'markaz.Web.Host.Controllers.TestTblController.Get (markaz.Web.Host)'
ERROR 2021-09-04 07:46:48,303 [8    ] AspNetCore.Server.IIS.Core.IISHttpServer - Connection ID "18158513703463419946", Request ID "8000002b-0001-fc00-b63f-84710c7967bb": An unhandled exception was thrown by the application.
System.InvalidOperationException: Processing of the LINQ expression 'GroupByShaperExpression:
KeySelector: new GroupByWrapper{ GroupByContainer = new LastInChain{ 
        Name = N'Name', 
        Value = t.Name 
    }
     }
, 
ElementSelector:new FlatteningWrapper<TestTbl>{ 
    Source = EntityShaperExpression: 
        EntityType: TestTbl
        ValueBufferExpression: 
            ProjectionBindingExpression: Source
        IsNullable: False
    , 
    GroupByContainer = new LastInChain{ 
        Name = ProjectionBindingExpression: GroupByContainer.Name, 
        Value = ProjectionBindingExpression: GroupByContainer.Value 
    }
     
}
' by 'RelationalProjectionBindingExpressionVisitor' failed. This may indicate either a bug or a limitation in Entity Framework. See https://go.microsoft.com/fwlink/?linkid=2101433 for more detailed information.
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitExtension(Expression extensionExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitUnary(UnaryExpression unaryExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitUnary(UnaryExpression unaryExpression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitMemberAssignment(MemberAssignment memberAssignment)
   at System.Linq.Expressions.ExpressionVisitor.VisitMemberBinding(MemberBinding node)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitMemberInit(MemberInitExpression memberInitExpression)
   at System.Linq.Expressions.MemberInitExpression.Accept(ExpressionVisitor visitor)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitMemberAssignment(MemberAssignment memberAssignment)
   at System.Linq.Expressions.ExpressionVisitor.VisitMemberBinding(MemberBinding node)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.VisitMemberInit(MemberInitExpression memberInitExpression)
   at System.Linq.Expressions.MemberInitExpression.Accept(ExpressionVisitor visitor)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Visit(Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.RelationalProjectionBindingExpressionVisitor.Translate(SelectExpression selectExpression, Expression expression)
   at Microsoft.EntityFrameworkCore.Query.RelationalQueryableMethodTranslatingExpressionVisitor.TranslateSelect(ShapedQueryExpression source, LambdaExpression selector)
   at Microsoft.EntityFrameworkCore.Query.QueryableMethodTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
   at Microsoft.EntityFrameworkCore.Query.QueryCompilationContext.CreateQueryExecutor[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Storage.Database.CompileQuery[TResult](Expression query, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass12_0`1.<ExecuteAsync>b__0()
   at Microsoft.EntityFrameworkCore.Query.Internal.CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.ExecuteAsync[TResult](Expression query, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.ExecuteAsync[TResult](Expression expression, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetAsyncEnumerator(CancellationToken cancellationToken)
   at Microsoft.AspNetCore.Mvc.Infrastructure.AsyncEnumerableReader.ReadInternal[T](Object value)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor.ExecuteAsyncEnumerable(ActionContext context, ObjectResult result, Object asyncEnumerable, Func`2 reader)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResultFilterAsync>g__Awaited|29_0[TFilter,TFilterAsync](ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResultExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.ResultNext[TFilter,TFilterAsync](State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.InvokeResultFilters()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextResourceFilter>g__Awaited|24_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Rethrow(ResourceExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Microsoft.AspNet.OData.Batch.ODataBatchMiddleware.Invoke(HttpContext context)
   at Abp.AspNetCore.Uow.AbpUnitOfWorkMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Abp.AspNetCore.Security.AbpSecurityHeadersMiddleware.Invoke(HttpContext httpContext)
   at Microsoft.AspNetCore.Watch.BrowserRefresh.BrowserRefreshMiddleware.InvokeAsync(HttpContext context)
   at Microsoft.AspNetCore.Builder.Extensions.MapMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Server.IIS.Core.IISHttpContextOfT`1.ProcessRequestAsync()
INFO  2021-09-04 07:46:48,306 [9    ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/1.1 GET http://localhost:21021/odata/testTbl?$apply=groupby((Name),aggregate(Id%20with%20sum%20as%20aa)) - - - 500 - - 515.3846ms
INFO  2021-09-04 07:46:48,983 [9    ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'markazDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO  2021-09-04 07:46:48,986 [9    ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (1ms) [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]

@MohammadMobasher
Copy link
Author

I think the bug is about Link but the question is, how can i fix this?

@MohammadMobasher
Copy link
Author

any idea?

@ismcagdas
Copy link
Member

Hi @MohammadMobasher I couldn't be sure if this problem is related to AspNet Boilerplate or not. You can try several options like removing Include from your query or remove groupBy operation and see if it works.

@MohammadMobasher
Copy link
Author

I did all of this and always appear this error.

@ismcagdas
Copy link
Member

Could you provide a sample project so we can work on it ?

@Robert-Laverick
Copy link

It looks like it's having trouble grouping by Name, is Name a string, or is it an object (I thinking something with a first and last name inside it or something)? I know group by EF code has issues grouping by complex objects from past experience, you'd have to group by NameID or Name.Firstname, Name.Lastname or something along those lines if it is complex.

@MohammadMobasher
Copy link
Author

@Robert-Laverick hi, the Name is just a simple string.

@MohammadMobasher
Copy link
Author

hi @ismcagdas

this is my entity class
`public class TestTbl : Entity, IHasModificationTime, IHasCreationTime, ISoftDelete, IDeletionAudited, IMustHaveTenant
{
public string Name { get; set; }
public string Title { get; set; }
public virtual bool IsDeleted { get; set; }
public virtual long? DeleterUserId { get; set; }
//public virtual long? LastModifierUserId { get; set; }
public virtual DateTime? DeletionTime { get; set; } = DateTime.Now;
public virtual DateTime CreationTime { get; set; } = DateTime.Now;
public virtual DateTime? LastModificationTime { get; set; } = DateTime.Now;
public int TenantId { get; set; }
public Tenant Tenant { get; set; }

}`

the Odata controller

`[DontWrapResult]
public class TestTblController : AbpODataEntityController, ITransientDependency
{
private readonly IRepository _repository;

    public TestTblController(IRepository<TestTbl> repository)
        : base(repository)
    {
        this._repository = repository;
    }


    public override IQueryable<TestTbl> Get()
    {
        return this._repository.GetAll().Include("Tenant");
        //return base.Get();
    }

}`

and my startup just like the sample in website.

@ismcagdas
Copy link
Member

@MohammadMobasher it would be really helpful if you can share a running project which includes this problem.

@stale
Copy link

stale bot commented Nov 16, 2021

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix label Nov 16, 2021
@stale stale bot closed this as completed Jan 9, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
wontfix
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ismcagdas @Robert-Laverick @MohammadMobasher