Hello,
I am using automatic audit logging for my inquiries. I am getting "Mvc.ExceptionHandling.AbpExceptionFilter - Sequence contains no elements." error while inserting to "AbpAuditLogs" log table.
Should I change any config to fix the issue? I am using default MsSql DB. Thanks
[Table("TableXYZ")]
[Audited]
public class TableXYZ : AuditedEntity<long>, IMayHaveTenant
WHERE ((@__ef_filter__p_0 = CAST(1 AS bit)) OR ([t].[TenantId] = @__ef_filter__CurrentTenantId_1)) AND ([t].[TerminalCode] = @__input_TerminalCode_0)
INFO 2021-12-24 10:37:28,862 [57 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'AccessDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO 2021-12-24 10:37:28,869 [13 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (4ms) [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();
ERROR 2021-12-24 10:37:28,871 [13 ] Mvc.ExceptionHandling.AbpExceptionFilter - Sequence contains no elements.
System.InvalidOperationException: Sequence contains no elements.
at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken)
at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken)
at Access.Tms.TmsTerminalsAppService.GetTerminalParameters(GetTmsTerminalInput input) in C:\projects\TMS\tms-backend\aspnet-core\src\Access.Application\Tms\TmsTerminalsAppService.cs:line 126
at lambda_method2525(Closure , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.AwaitableObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask1 actionResultValueTask)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
INFO 2021-12-24 10:37:28,874 [13 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'AccessDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO 2021-12-24 10:37:28,878 [13 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (3ms) [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-12-24 10:37:28,884 [13 ] .Mvc.Infrastructure.ObjectResultExecutor - Executing ObjectResult, writing value of type 'Abp.Web.Models.AjaxResponse'.
INFO 2021-12-24 10:37:28,885 [13 ] c.Infrastructure.ControllerActionInvoker - Executed action Access.Tms.TmsTerminalsAppService.GetTerminalParameters (Access.Application) in 98.46ms
INFO 2021-12-24 10:37:28,885 [13 ] ft.AspNetCore.Routing.EndpointMiddleware - Executed endpoint 'Access.Tms.TmsTerminalsAppService.GetTerminalParameters (Access.Application)'
INFO 2021-12-24 10:37:28,886 [69 ] Microsoft.AspNetCore.Hosting.Diagnostics - Request finished HTTP/2 GET https://localhost:44301/api/services/app/TmsTerminals/GetTerminalParameters?TerminalCode=TRM00001 - - - 500 207 application/json;+charset=utf-8 104.3203ms
INFO 2021-12-24 10:37:33,123 [71 ] osoft.EntityFrameworkCore.Infrastructure - Entity Framework Core 5.0.3 initialized 'AccessDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: None
INFO 2021-12-24 10:37:33,126 [71 ] oft.EntityFrameworkCore.Database.Command - Executed DbCommand (2ms) [Parameters=[@__p_1='?' (DbType = Int32), @__Now_0='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
Hello,
On stripe subscription there is trial_period option. Are you supporting this feature or do youe have a plan to support this feature? https://stripe.com/docs/billing/subscriptions/trials https://stripe.com/docs/api/subscriptions/create#create_subscription-trial_period_days
Kind regards
Hello,
I am confused about the TenantId assignment. If MultiTenancyEnabled = true, TenantId is assigned null. Is that correct usage?
namespace XDemo.Migrations.Seed.Host
{
public class DefaultLanguagesCreator
{
public static List InitialLanguages => GetInitialLanguages();
private readonly XDemoDbContext _context;
private static List<ApplicationLanguage> GetInitialLanguages()
{
var tenantId = XDemoConsts.MultiTenancyEnabled ? null : (int?)1;
...
public class XDemoConsts
{
public const string LocalizationSourceName = "XDemo";
public const string ConnectionStringName = "Default";
public const bool MultiTenancyEnabled = true;
...
I was excepting if MultiTenancyEnabled is true then an Id should be assigned to the tenants such as:
var tenantId = XDemoConsts.MultiTenancyEnabled ? (int?)1 : null ;
Kind regards
Hello,
I'd like to use metronic template latest version (Metronic v7.2.3). However on the page https://aspnetzero.com/Download you are providing v7.0.3
How can we properly access the latest version of metronic template?
Regards