SQL SERVER.
Al escalar de forma simultanea incrementos dio error de edeadlock. Adjunto archivo para su análisis WorkflowService_20180207.LOG (algunos códigos de flujo que se intentaron escalar en el mismo momento: 1588b03c-8d79-48c2-a114-d9d635cd87f4 ;
5a0f6f64-deda-463c-922e-021bcd999bdc ;
ab5fdd24-01f5-48aa-9f51-e63f0d66bec8 ;
b79446f6-e474-43dc-b4df-da0c6949fad1 ;
c411f7e8-6f3a-4980-bb7e-2e89de487281)
Aseinfo.Infrastructure.Base.Exceptions.AuthorizationWorkflowException: Sucedio un error en el flujo. Se está logueando el exception interno y luego se logueará el que terminará la instancia ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 108) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() --- End of inner exception stack trace --- at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at Aseinfo.VH4.Data.AppDataContext.SaveChanges(SaveOptions options) in C:\vh4\VH4\Data\AppDataContext.cs:line 98 at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase`2.SaveChanges() in C:\vh4\Infrastructure\Base\Entity\EntityServiceBase.cs:line 563 at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase`2.DoUpdate(T entity, Boolean saveChanges) in C:\vh4\Infrastructure\Base\Entity\EntityServiceBase.cs:line 996 at Aseinfo.VH4.WorkflowServices.Services.AuthorizationWorkflowService.EscalarActividad(Int32 codigoActividad) in C:\vh4\VH4\WorkflowServices\WorkflowServices\Services\AuthorizationWorkflowService.cs:line 486 at Aseinfo.VH4.WorkflowServices.Services.AuthorizationWorkflowStaticService.EscalarActividad(Int32 codigoActividad, WorkflowContext context) in C:\vh4\VH4\WorkflowServices\WorkflowServices\Services\AuthorizationWorkflowStaticService.cs:line 160 --- End of inner exception stack trace --- at System.Activities.Statements.MethodExecutor.InvokeAndUnwrapExceptions(Func`3 func, Object targetInstance, Object[] actualParameters) at System.Activities.Statements.MethodResolver.SyncMethodExecutor.BeginMakeMethodCall(AsyncCodeActivityContext context, Object target, AsyncCallback callback, Object state) at System.Activities.Statements.MethodExecutor.BeginExecuteMethod(AsyncCodeActivityContext context, AsyncCallback callback, Object state) at System.Activities.AsyncCodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager) at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
LOG DEL SQL SERVER
***UN INSTANTE ANTES
Date 2/7/2018 12:39:00 AM
Log SQL Server (Current - 11/28/2017 1:59:00 PM)
Source Logon
****INICIO
Message
Login succeeded for user 'NT AUTHORITYSYSTEM'. Connection made using Windows authentication. [CLIENT: <local machine="">]
Date 2/7/2018 12:39:08 AM
Log SQL Server (Current - 11/28/2017 1:59:00 PM)
Source Logon
****DESPUÉS APARECEN 12 REGISTROS IDÉNTICOS COMO LOS SIGUIENTES (LOS SERVICIOS SE CONECTAN COMO LOCAL SYSTEM)
Message
Login succeeded for user 'evolution'. Connection made using SQL Server authentication. [CLIENT: X.XXX.XX.XXX]
Date 2/7/2018 12:39:10 AM
Log SQL Server (Current - 11/28/2017 1:59:00 PM)
Source Logon
Message
Login succeeded for user 'NT AUTHORITYSYSTEM'. Connection made using Windows authentication. [CLIENT: <local machine="">]
