Activities of "tdv.yazilim"

We are using default.

Thank you for support.

Hi @ismcagdas

No problem. I tried your said. sourceUserId and targetUserId existed in db. hasActiveDelegation returned null. But these user IDs exist in DB.

Screen Shot:

Then I thought this problem was from the start date configuration. For example it didn't work when startDate: 2023-05-12 09:00. My current time is 2023-05-12 9:30. I changed the start date to 2023-05-12 06:00. it worked. I think this issue is due to time configuration. How do I fixed this problem?

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.

Hi, We have sent the files you requested to the [email protected] e-mail address. We can also show you the problem we encounter as an online meeting.

Hi, We do not use Redis in token transactions in our application. We also reviewed the codes on github you mentioned above. We did not detect any changes in our project.

We did our experiments on the new empty Zero project. We faced the same problem in the new project.

We did our tests with jmeter with the settings you specified at https://blog.aspnetzero.com/blogs/asp.net-zero/running-load-test-on-asp.net-zero. We are getting this error even in 50 users in our environments.

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.

Thank you, for support

• 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