Activities of "tdv.yazilim"

Hi,

We are using V.12.1 Core.Mvc. Our problem is ValidateUserDelegation Method. This situation at Azure PaaS DB. But We tried at Local DB. It's working. Atboth of them start and end date configurations true. But not working at live. Select button came at user menu.

I'am sharing logs at you.

ERROR 2023-05-09 15:06:54,654 [18   ] spNetCore.Antiforgery.DefaultAntiforgery - An exception was thrown while deserializing the token.
Microsoft.AspNetCore.Antiforgery.AntiforgeryValidationException: The antiforgery token could not be decrypted.
 ---> System.Security.Cryptography.CryptographicException: The key {b3a8d62f-7ed6-4648-9e30-b38f5d8f42fd} was not found in the key ring. For more information go to http://aka.ms/dataprotectionwarning
   at Microsoft.AspNetCore.DataProtection.KeyManagement.KeyRingBasedDataProtector.UnprotectCore(Byte[] protectedData, Boolean allowOperationsOnRevokedKeys, UnprotectStatus& status)
   at Microsoft.AspNetCore.DataProtection.KeyManagement.KeyRingBasedDataProtector.Unprotect(Byte[] protectedData)
   at Microsoft.AspNetCore.Antiforgery.DefaultAntiforgeryTokenSerializer.Deserialize(String serializedToken)
   --- End of inner exception stack trace ---
   at Microsoft.AspNetCore.Antiforgery.DefaultAntiforgeryTokenSerializer.Deserialize(String serializedToken)
   at Microsoft.AspNetCore.Antiforgery.DefaultAntiforgery.GetCookieTokenDoesNotThrow(HttpContext httpContext)
WARN  2023-05-09 15:06:57,074 [18   ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
WARN  2023-05-09 15:06:57,175 [18   ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
WARN  2023-05-09 15:06:57,235 [18   ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
WARN  2023-05-09 15:07:24,042 [8    ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
WARN  2023-05-09 15:07:24,318 [50   ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.
ERROR 2023-05-09 15:07:24,436 [50   ] e.Diagnostics.ExceptionHandlerMiddleware - An unhandled exception has occurred while executing the request.
Abp.UI.UserFriendlyException: ThereIsNoActiveUserDelegationBetweenYourUserAndCurrentUser
   at TDV.Identity.SecurityStampValidator.ValidateUserDelegation(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 81
   at TDV.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 49
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync[TValidator](CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidatePrincipalAsync(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationEvents.ValidatePrincipal(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationHandler`1.AuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, String scheme)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
ERROR 2023-05-09 15:07:24,439 [50   ] e.Diagnostics.ExceptionHandlerMiddleware - An exception was thrown attempting to execute the error handler.
Abp.UI.UserFriendlyException: ThereIsNoActiveUserDelegationBetweenYourUserAndCurrentUser
   at TDV.Identity.SecurityStampValidator.ValidateUserDelegation(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 81
   at TDV.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 49
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync[TValidator](CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidatePrincipalAsync(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationEvents.ValidatePrincipal(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationHandler`1.AuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, String scheme)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.HandleException(HttpContext context, ExceptionDispatchInfo edi)
ERROR 2023-05-09 15:07:24,442 [50   ] AspNetCore.Server.IIS.Core.IISHttpServer - Connection ID "14843864373423789529", Request ID "8000563e-0000-ce00-b63f-84710c7967bb": An unhandled exception was thrown by the application.
Abp.UI.UserFriendlyException: ThereIsNoActiveUserDelegationBetweenYourUserAndCurrentUser
   at TDV.Identity.SecurityStampValidator.ValidateUserDelegation(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 81
   at TDV.Identity.SecurityStampValidator.ValidateAsync(CookieValidatePrincipalContext context) in C:\Workspaces\TDV.FYS\src\TDV.Core\Identity\SecurityStampValidator.cs:line 49
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidateAsync[TValidator](CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Identity.SecurityStampValidator.ValidatePrincipalAsync(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationEvents.ValidatePrincipal(CookieValidatePrincipalContext context)
   at Microsoft.AspNetCore.Authentication.Cookies.CookieAuthenticationHandler.HandleAuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationHandler`1.AuthenticateAsync()
   at Microsoft.AspNetCore.Authentication.AuthenticationService.AuthenticateAsync(HttpContext context, String scheme)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.HandleException(HttpContext context, ExceptionDispatchInfo edi)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddlewareImpl.<Invoke>g__Awaited|8_0(ExceptionHandlerMiddlewareImpl middleware, HttpContext context, Task task)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Abp.AspNetCore.Security.AbpSecurityHeadersMiddleware.Invoke(HttpContext httpContext)
   at Abp.AspNetCore.Mvc.Caching.GetScriptsResponsePerUserCacheMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Server.IIS.Core.IISHttpContextOfT`1.ProcessRequestAsync()
WARN  2023-05-09 15:07:46,585 [50   ] 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 and examples. To identify the code which triggers this warning, call 'ConfigureWarnings(w => w.Throw(SqlServerEventId.SavepointsDisabledBecauseOfMARS))'.

Best regards.

Hello,

Version is; 11,1 . Asp.net core mvc jquery.

We are using the host layer for our mobile application After a while, we get an error while taking tokens.

Our token taking period starts to increase after a while or we cannot perform any token takes. We are waiting for your help about this error. We have 2 different errors in the application logs related to this. These errors are listed below.

Error 1

System.ArgumentNullException: Value cannot be null. (Parameter 'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.') at Name.Web.Controllers.TokenAuthController.Authenticate(AuthenticateModel model) in C:\Users\A\source\repos\Name.ProjectName\src\ProjectName.Web.Core\Controllers\TokenAuthController.cs:line 239 at lambda_method1534(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__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)

Value cannot be null. (Parameter 'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.')

Error 2

System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry, SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverrides overrides) at Microsoft.Data.SqlClient.SqlConnection.Open() at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.OpenDbConnection(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(Boolean errorsExpected) at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.BeginTransaction(IsolationLevel isolationLevel) at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.<>c__DisplayClass22_0.<BeginTransaction>b__0(DatabaseFacade database) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_02.<Execute>b__0(DbContext c, TState s) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func`3 veri...

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

• product version? 9.3
• product type Core MVC
• product framework type net core

Hi,

We're going to switch from the version I mentioned above to the latest version 11.2. We've read the upgrade instruction, but in case of major version changes, is it okay to go straight to the latest version without switching to intermediate versions? Do you have any suggestions other than the information in the document?

https://docs.aspnetzero.com/en/common/latest/Version-Updating

Thanks, Best Regards

Hi, I downloaded the latest version of Asp.Net Zero. I am editing index.html pages for all entities. I added selectpicker or select2 class for all select box items. But it's not working. When I examined your Default Language page, I saw that it did not work the same way. How can I fix this problem.

Best regards.

js code $('.selectpicker').selectpicker({ liveSearch: true, maxOptions: 5 });

  html
  

  <div class="col-md-2">
                        <div class="form-group">
                            <label for="ContinentNameFilterId">(@L("Continent")) @L("Name")</label>

                            <select class="form-control selectpicker" data-size="7" data-live-search="true" name="continentNameFilter" id="ContinentNameFilterId">
                                <option value="-1">@L("All")</option>
                            </select>

                        </div>
                    </div>

My Project Informations

• V.11.1
• MVC
• .net Core
• Abp Framework 6.0
• Default Theme
• Default Settings

• V.10.5
• MVC
• CORE 5.0
• Abp Framework V.6.4.0
• Default Theme
• Default UI Settings

My problem is html viewurl error after adding new widget in CustomizableDashboard. I did the operations like here, everything looks the same, but the widget html cannot be found. https://docs.aspnetzero.com/en/aspnet-core-mvc/latest/Developing-Mvc-Core-Customizable-Dashboard How can I fixed? Have another setting?

Merhaba ,

Person tablosunda Country ve City tablolarına ilişki kurmaya çalışıyorum. Country tablosuna ilişki kurduktan sonra City tablosuna ilişki kurmaya çalıştığımızda aşağıdaki hata ile karşılaşmaktayız. City tablosunun Country tablosuyla ilişkisi var.

Konu ile ilgili desteğinizi beklemekteyiz.

Applying migration '20191001081151_Regenerated_Person4988'. Failed executing DbCommand (11ms) [Parameters=[], CommandType='Text', CommandTimeout='30'] ALTER TABLE [Person] ADD CONSTRAINT [FK_Person_City_CityId] FOREIGN KEY ([CityId]) REFERENCES [City] ([Id]) ON DELETE CASCADE; System.Data.SqlClient.SqlException (0x80131904): Introducing FOREIGN KEY constraint 'FK_Person_City_CityId' on table 'Person' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint or index. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite, String methodName) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection) at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration) at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String contextType) at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action) ClientConnectionId:5cf1d597-612d-4a18-b53d-7d8e68e2fc36 Error Number:1785,State:0,Class:16 Introducing FOREIGN KEY constraint 'FK_Person_City_CityId' on table 'Person' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint or index. See previous errors.

Merhaba, Aşağıdaki metod içerisindeki web katmanındaki startup içierisinde ABP framework yüklenirken aşağıdaki hatayı alıyoruz. System.MissingMethodException: 'Method not found: 'Void Abp.Runtime.Caching.Configuration.ICachingConfiguration.Configure(System.String, System.Action`1<Abp.Runtime.Caching.ICache>)'.'