Activities of "shedspotter"

Hi ismcagdas , sorry but we can not share the credientials of our user but we can show you the screen shot from clarity in which you can see that the user is using host.anywhereapp.io

Thanks

Hi @ismcagdas , could you please help me to undersatand how can we open and closed the signalR connection in asp.net zero application.

Thanks

Hi @ismcgdas, Here is the test credentials you requested:

URL: http://taritas.anywhereapp.in/app/admin/auditLogs ID: [email protected] PW: ]%>`xMyCK!Z['x3'

Notice how you get an exception when you visit the Audit Log page, kindly take a look & let us know if we can do something without having to update the ADB version as an immediate fix.

Looking forward to your response.

Thanks

HI, We are still waiting for an answer to understand this.

The developers acces the DB from local machine time to time, should this show the local dev path in Audit Logs in tanant audit logs?

I have used the same code which you have shared with us I have just copied and paste it

HI @ismcagdas , Thanks for the response.

1.Is it possible that your developers are connecting to Azure DB from their local machines ? ANS = Yes our developer always using azure DB loaclly

2. Can you see different paths in the Audit Logs table ? ANS = there is no difference between the paths

and we run the server loaclly it will always pick the loacl machines path

Thanks

HI ismcagdas, after changing the list and saving the time zone for user it is given us below exception and it is not allowing user to access the application

Exception of type 'System.TimeZoneNotFoundException' was thrown. System.TimeZoneNotFoundException: Exception of type 'System.TimeZoneNotFoundException' was thrown. at TimeZoneConverter.TZConvert.GetTimeZoneInfo(String windowsOrIanaTimeZoneId)
at Abp.Timing.Timezone.TimezoneHelper.FindTimeZoneInfo(String windowsOrIanaTimeZoneId) at Abp.Web.Configuration.AbpUserConfigurationBuilder.GetUserTimingConfig()
at Abp.Web.Configuration.AbpUserConfigurationBuilder.GetAll()
at Abp.AspNetCore.Mvc.Controllers.AbpUserConfigurationController.GetAll() at lambda_method2024(Closure , Object )
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Awaited|12_0(ControllerActionInvoker invoker, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.

Hi ismcagdas , sure we will send the credentials with you. I have debugg the audit logs api and I have found that the API is getting all the data of the tenant and than it will doing the query based on user id , i think this is the point where the time is taking. actully the api need to get the records from the db directly with the user id query .

Thanks

Hi ismcagdas, Thanks for the response. SingalR basically work for the live update to the client site. In our case we have one method which creates new item but inside that method we are colling some other methods which do some other task like sending data to 3rd party app, updating the DB etc becuase of that the response for getting new item id is taking time due to which it is tasking time in reflecting client site as well and also we can not remove thses method and also all the methods does not return data as well. for example : Parent method 1. child mehtod 2. child mehtod 3. child mehtod 4. child mehtod 5. child mehtod

return parent mehtod
so we want child method should be run in background and parent method return the result without waiting for child methods

Thanks

HI @ismcagdas Here is the exception detais:

Routing Destination:fec47a56e385.HS2.tr1038.eastasia1-a.worker.database.windows.net,11008 ERROR 2022-01-05 11:43:57,137 [175 ] Mvc.ExceptionHandling.AbpExceptionFilter - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__169_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke() at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) --- End of stack trace from previous location --- at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.InitializeReaderAsync(DbContext _, Boolean result, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TState state, Func4 operation, Func4 verifySucceeded, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable1.AsyncEnumerator.MoveNextAsync() at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at Microsoft.EntityFrameworkCore.Query.ShapedQueryCompilingExpressionVisitor.SingleAsync[TSource](IAsyncEnumerable1 asyncEnumerable, CancellationToken cancellationToken) at SmartSuite.Auditing.AuditLogAppService.GetAuditLogs(GetAuditLogsInput input) in D:\Taritas Projects\Anywhere\aspnet-core\src\SmartSuite.Application\Auditing\AuditLogAppService.cs:line 63 at lambda_method13534(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, ValueTask`1 actionResultValueTask) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.