a que se debe este error cuando levanto el servicio del appjob:
2020-11-05 19:05:13,347 [1] INFO Quartz.Impl.StdSchedulerFactory - Quartz scheduler 'AppJobWinServiceScheduler' initialized
2020-11-05 19:05:13,355 [1] INFO Quartz.Impl.StdSchedulerFactory - Quartz scheduler version: 3.0.5.0
2020-11-05 19:05:13,363 [1] INFO Quartz.Core.QuartzScheduler - JobFactory set to: Aseinfo.VH4.MicroServices.AppJobs.QuartzServer.UnityJobFactory
2020-11-05 19:05:13,370 [1] INFO Main - Quartz Server initialized
2020-11-05 19:05:13,379 [1] INFO QuartzServer - Creando la tarea de Notificación
2020-11-05 19:05:13,396 [1] INFO QuartzServer - Chequeando si existe el Job de notificaciones
2020-11-05 19:05:13,449 [9] INFO QuartzServer - Agendando la ejecución del job para procesar notificaciones:
{
"JobKey": "NotificationJob",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.NotificationJob",
"TriggerKey": "NotificationJob",
"TriggerStartTime": "2020-11-05T19:05:13.4363427-06:00"
}
2020-11-05 19:05:14,499 [5] ERROR QuartzServer - Quartz Server failed to start. Se intentará de nuevo en 30 segundos. Error:Failure obtaining db row lock: Violation of PRIMARY KEY constraint 'PK_QRTZ_LOCKS'. Cannot insert duplicate key in object 'dbo.QRTZ_LOCKS'. The duplicate key value is (AppJobWinServiceScheduler, TRIGGER_ACCESS).
The statement has been terminated.
Quartz.Impl.AdoJobStore.LockException: Failure obtaining db row lock: Violation of PRIMARY KEY constraint 'PK_QRTZ_LOCKS'. Cannot insert duplicate key in object 'dbo.QRTZ_LOCKS'. The duplicate key value is (AppJobWinServiceScheduler, TRIGGER_ACCESS).
The statement has been terminated. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_QRTZ_LOCKS'. Cannot insert duplicate key in object 'dbo.QRTZ_LOCKS'. The duplicate key value is (AppJobWinServiceScheduler, TRIGGER_ACCESS).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore.<LockViaInsert>d__8.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\UpdateRowLockSemaphore.cs:line 163
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore.<ExecuteSQL>d__6.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\UpdateRowLockSemaphore.cs:line 93
--- End of inner exception stack trace ---
at Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore.<ExecuteSQL>d__6.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\UpdateRowLockSemaphore.cs:line 120
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.DBSemaphore.<ObtainLock>d__13.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\DBSemaphore.cs:line 111
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.JobStoreSupport.<ExecuteInNonManagedTXLock>d__262`1.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3697
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Quartz.Impl.AdoJobStore.JobStoreSupport.<ExecuteInNonManagedTXLock>d__262`1.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3712
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.JobStoreSupport.<StoreJobAndTrigger>d__147.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 828
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Core.QuartzScheduler.<ScheduleJob>d__82.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Core\QuartzScheduler.cs:line 616
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Aseinfo.VH4.MicroServices.AppJobs.QuartzServer.QuartzServer.<CreateNotificationJobAsync>d__15.MoveNext() in C:\vh4\VH4\MicroServices\AppJob\QuartzServer\QuartzServer.cs:line 254
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Aseinfo.VH4.MicroServices.AppJobs.QuartzServer.QuartzServer.<StartAsync>d__20.MoveNext() in C:\vh4\VH4\MicroServices\AppJob\QuartzServer\QuartzServer.cs:line 300 [See nested exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_QRTZ_LOCKS'. Cannot insert duplicate key in object 'dbo.QRTZ_LOCKS'. The duplicate key value is (AppJobWinServiceScheduler, TRIGGER_ACCESS).
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader(Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryAsync(IAsyncResult asyncResult)
at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore.<LockViaInsert>d__8.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\UpdateRowLockSemaphore.cs:line 163
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.UpdateLockRowSemaphore.<ExecuteSQL>d__6.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\UpdateRowLockSemaphore.cs:line 93
ClientConnectionId:30085a7f-3cf4-42e7-b2a4-c169f1c1e8cd
Error Number:2627,State:1,Class:14]
Actualización 11/11/2020
como comentaba aparentemente ya esta funcionando correctamente el AppJob y se envían las peticiones al quartz pero el Job no las procesa
log appjob
2020-11-10 23:23:46,290 [1] INFO Main - ASEINFO Evolution - Ejecutor de tareas programadas.
2020-11-10 23:23:46,408 [1] INFO AppJobDatabaseTool.DatabaseHelper - Chequeando conexión a base de datos SQL Server EvoDB..
2020-11-10 23:23:47,185 [1] INFO AppJobDatabaseTool.DatabaseHelper - Chequeando si existen las tablas en la base SQL Server de Quartz .
2020-11-10 23:23:47,656 [1] INFO Main - Obtaining instance of an IQuartzServer
2020-11-10 23:23:47,938 [1] INFO Main - Initializing Quartz Server
2020-11-10 23:23:53,072 [1] INFO QuartzServer - Inicializando el Quartz Server
2020-11-10 23:23:53,079 [1] INFO QuartzServer - Configurando Unity...
2020-11-10 23:23:57,893 [1] INFO QuartzServer - Resolviendo el CryptographyService ...
2020-11-10 23:23:57,974 [1] INFO QuartzServer - Resolviendo CacheService ...
2020-11-10 23:23:57,984 [1] INFO QuartzServer - Configurando EntitySet Mapping Dictionaries...
2020-11-10 23:23:58,095 [1] INFO QuartzServer - Fin de Configuración Unity...
2020-11-10 23:23:58,102 [1] INFO QuartzServer - Creando el Quartz Scheduler Factory
2020-11-10 23:23:58,128 [1] INFO QuartzServer - Obteniendo el Scheduler del Factory
2020-11-10 23:23:59,263 [1] INFO Quartz.Util.DBConnectionManager - Registering datasource 'default' with db provider: 'Quartz.Impl.AdoJobStore.Common.DbProvider'
2020-11-10 23:23:59,278 [1] INFO Quartz.Impl.StdSchedulerFactory - Using object serializer: Quartz.Simpl.BinaryObjectSerializer, Quartz
2020-11-10 23:23:59,379 [1] INFO Quartz.Core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: Quartz.Core.SchedulerSignalerImpl
2020-11-10 23:23:59,389 [1] INFO Quartz.Core.QuartzScheduler - Quartz Scheduler v.3.0.5.0 created.
2020-11-10 23:23:59,405 [1] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Using thread monitor-based data access locking (synchronization).
2020-11-10 23:23:59,413 [1] INFO Quartz.Impl.AdoJobStore.JobStoreTX - JobStoreTX initialized.
2020-11-10 23:23:59,601 [1] INFO Quartz.Simpl.RemotingSchedulerExporter - Remoting is allowing remote calls
2020-11-10 23:23:59,606 [1] INFO Quartz.Simpl.RemotingSchedulerExporter - Registering remoting channel of type 'System.Runtime.Remoting.Channels.Tcp.TcpChannel' to port (8001) with name (http)
2020-11-10 23:23:59,620 [1] INFO Quartz.Simpl.RemotingSchedulerExporter - Remoting channel registered successfully
2020-11-10 23:23:59,626 [1] INFO Quartz.Simpl.RemotingSchedulerExporter - Successfully marshalled remotable scheduler under name 'Aseinfo.VH4.WindowsServices.AppJobService'
2020-11-10 23:23:59,635 [1] INFO Quartz.Core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v3.0.5.0) 'AppJobWinServiceScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'Quartz.Core.QuartzScheduler' - access via remote invocation.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'Quartz.Simpl.DefaultThreadPool' - with 10 threads.
Using job-store 'Quartz.Impl.AdoJobStore.JobStoreTX' - which supports persistence. and is not clustered.
2020-11-10 23:23:59,643 [1] INFO Quartz.Impl.StdSchedulerFactory - Quartz scheduler 'AppJobWinServiceScheduler' initialized
2020-11-10 23:23:59,651 [1] INFO Quartz.Impl.StdSchedulerFactory - Quartz scheduler version: 3.0.5.0
2020-11-10 23:23:59,658 [1] INFO Quartz.Core.QuartzScheduler - JobFactory set to: Aseinfo.VH4.MicroServices.AppJobs.QuartzServer.UnityJobFactory
2020-11-10 23:23:59,666 [1] INFO Main - Quartz Server initialized
2020-11-10 23:23:59,691 [1] INFO QuartzServer - Creando la tarea de Notificación
2020-11-10 23:23:59,904 [1] INFO QuartzServer - Chequeando si existe el Job de notificaciones
2020-11-10 23:24:00,293 [10] INFO QuartzServer - Agendando la ejecución del job para procesar notificaciones:
{
"JobKey": "NotificationJob",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.NotificationJob",
"TriggerKey": "NotificationJob",
"TriggerStartTime": "2020-11-10T23:24:00.2269294-06:00"
}
2020-11-10 23:24:00,419 [8] INFO QuartzServer - Starting Quartz Service
2020-11-10 23:24:00,452 [5] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Freed -2 triggers from 'acquired' / 'blocked' state.
2020-11-10 23:24:00,470 [7] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Handling 7 trigger(s) that missed their scheduled fire-time.
2020-11-10 23:24:00,723 [10] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Recovering 0 jobs that were in-progress at the time of the last shut-down.
2020-11-10 23:24:00,730 [10] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Recovery complete.
2020-11-10 23:24:00,740 [8] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Removed 0 'complete' triggers.
2020-11-10 23:24:00,787 [10] INFO Quartz.Impl.AdoJobStore.JobStoreTX - Removed -1 stale fired job entries.
2020-11-10 23:24:00,829 [10] INFO Quartz.Core.QuartzScheduler - Scheduler AppJobWinServiceScheduler_$_NON_CLUSTERED started.
2020-11-10 23:24:00,838 [10] INFO QuartzServer - Quartz Scheduler started successfully
Log website
2020-11-10 23:24:06,081 [1] INFO Log4NetLoggingService - Iniciando global.asax.Application_Start()
2020-11-10 23:24:06,101 [11] INFO Log4NetLoggingService - InitializeAppDataContext
2020-11-10 23:24:12,416 [1] INFO Log4NetLoggingService - Generating Actual Fingerprint from ManagementObjectSearcher
Manufacturer: Dell Inc.
Name: Base Board
SerialNumber: /GRK6GC2/CN12963668022C/
Manufacturer: Dell Inc.
SerialNumber: GRK6GC2
ProcessorId: BFEBFBFF000406E3
Name: Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz
Manufacturer: GenuineIntel
SerialNumber: 00329-10280-00000-AA425
UUID: 4C4C4544-0052-4B10-8036-C7C04F474332
PNPDeviceID: PCI\VEN_1002&DEV_6660&SUBSYS_06B21028&REV_81\4&2370267D&0&00E0
PNPDeviceID: PCI\VEN_8086&DEV_1916&SUBSYS_06B21028&REV_07\3&11583659&0&10
Device Serial Number: WXD1A36PJZHR
Device Fingerprint:
76E964494482BD0E6A05ACFC57FAB1B371457673808686FF0A55CA6156DCB706
Based on the following measurements:
MeasureBaseboard = True
MeasureBios = True
MeasureCpu = True
MeasureActiveNICs = False
MeasureVideoboard = True
MeasureOSSerialNumber = True
MeasureSystemUUID = True
MeasureHDDSerialNumber = True
2020-11-10 23:24:15,410 [1] INFO Log4NetLoggingService - No se encontró ningun DLL de Plugins. Se continúa la ejecución normal
2020-11-10 23:24:20,475 [11] INFO Log4NetLoggingService - Finalizando - InitializeAppDataContext - 14.3735701
2020-11-10 23:24:23,480 [1] INFO Log4NetLoggingService - Finalizó Global.asax.Application_Start()
2020-11-10 23:24:24,040 [4] INFO Log4NetLoggingService - Programando job para inicio de Alertas desde la base de datos:
{
"JobKey": "EjecucionAlerta_/",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.EjecucionAlertaJob",
"TriggerKey": "EjecucionAlerta_/",
"TriggerStartTime": "2020-11-10T23:24:23.8388217-06:00",
"SegundosIntervaloJob": 600,
"MaximoNumeroRegistrosIncluidosEnCadaEjecucion": 5
}
2020-11-10 23:24:24,146 [14] INFO Log4NetLoggingService - Programando job para Inicio de Flujos desde la base de datos:
{
"JobKey": "InicioFlujoEntidades_/",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.IniciaFlujoEntidadJob",
"TriggerKey": "InicioFlujoEntidades_/",
"TriggerStartTime": "2020-11-10T23:24:24.1460014-06:00",
"SegundosIntervaloJob": 600,
"MaximoNumeroRegistrosIncluidosEnCadaEjecucion": 20
}
2020-11-10 23:24:24,173 [15] INFO Log4NetLoggingService - Programando job para generación de índices de Lucene:
{
"JobKey": "EmpleadosIndex",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.LuceneIndexGenerationJob",
"TriggerKey": "EmpleadosIndex",
"TriggerStartTime": "2020-11-10T23:24:24.1689394-06:00",
"GenerationIntervalInSeconds": 300,
"ProbingStoredProcedureName": "rys.GetEmpIndexUltimaModif",
"DataStoredProcedureName": "rys.GetEmpleadosIndexData",
"RutaIndice": "C:\\ASEINFO\\Evolution Components 1.19.1.0\\wwwEvolution\\App_Data\\EmpleadosIndex"
}
2020-11-10 23:24:24,377 [15] INFO Log4NetLoggingService - Programando job para generación de índices de Lucene:
{
"JobKey": "CandidatosIndex",
"JobGroup": "DEFAULT",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.LuceneIndexGenerationJob",
"TriggerKey": "CandidatosIndex",
"TriggerStartTime": "2020-11-10T23:24:24.3777125-06:00",
"GenerationIntervalInSeconds": 300,
"ProbingStoredProcedureName": "rys.GetCanIndexUltimaModif",
"DataStoredProcedureName": "rys.GetCandidatosIndexData",
"RutaIndice": "C:\\ASEINFO\\Evolution Components 1.19.1.0\\wwwEvolution\\App_Data\\CandidatosIndex"
}
2020-11-10 23:24:24,445 [10] INFO Log4NetLoggingService - Session_Start (bughrlitmvkgfkcppgq14kg4) -> Session.Mode == InProc
2020-11-10 23:25:04,811 [10] FATAL Log4NetLoggingService - Errors - Aseinfo.Infrastructure.Base.Exceptions.UploadFileException: El archivo buscado 'C:\inetpub\wwwroot\Evolution\UploadFile\Image\942D2A6C-76B6-414D-AE6B-5CF19271C82F' no se encontró. Código de UploadFile es: '942D2A6C-76B6-414D-AE6B-5CF19271C82F'
at Aseinfo.Infrastructure.Services.UploadFileService.GetUploadFileContent(UploadFile entity) in C:\vh4\Infrastructure\Services\UploadFiles\UploadFileService.cs:line 136
at Aseinfo.VH4.UI.Web.Controllers.CommonController.ViewFile(String id, Nullable`1 width, Nullable`1 height) in C:\vh4\vh4\UI\Web\Controllers\CommonController.cs:line 302
at lambda_method(Closure , ControllerBase , Object[] )
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_6.<BeginInvokeAction>b__4()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult)
2020-11-10 23:25:24,921 [17] INFO Aseinfo.VH4.General.Controllers.AlertaController - Programando job para ejecutar la Alerta:
{
"JobKey": "17C8D35C-D41F-4745-A8E1-88203620D09C",
"JobGroup": "AlertaEjecucionInmediata",
"JobType": "Aseinfo.VH4.MicroServices.AppJobs.QuartzJobs.AlertaJob",
"TriggerKey": "17C8D35C-D41F-4745-A8E1-88203620D09C",
"TriggerStartTime": "2020-11-10T23:25:24.9124484-06:00",
"Alerta": {
"Codigo": "17C8D35C-D41F-4745-A8E1-88203620D09C",
"EsAutomatica": true,
"ExpresionCron": "0 45 9 1 1,2,3,4,5,6,7,8,9,10,11 ?",
"FechaInicio": "2020-01-01T00:00:00",
"FechaFin": null,
"EjecucionInmediata": true,
"Usuario": "jcsoria"
}
}
2020-11-10 23:25:25,216 [17] FATAL Log4NetLoggingService - Errors - Aseinfo.Infrastructure.Base.Exceptions.ApplicationJobWindowsServiceException: La Alerta fue guardada correctamente, pero el servicio de ejecución de tareas no puedo iniciar la programación de la Alerta. ---> Quartz.JobPersistenceException: Couldn't store job: Unable to store Job: 'AlertaEjecucionInmediata.17C8D35C-D41F-4745-A8E1-88203620D09C', because one already exists with this identification. ---> Quartz.ObjectAlreadyExistsException: Unable to store Job: 'AlertaEjecucionInmediata.17C8D35C-D41F-4745-A8E1-88203620D09C', because one already exists with this identification.
at Quartz.Impl.AdoJobStore.JobStoreSupport.<StoreJob>d__151.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 899
--- End of inner exception stack trace ---
Server stack trace:
at Quartz.Impl.AdoJobStore.JobStoreSupport.<StoreJob>d__151.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 914
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.JobStoreSupport.<>c__DisplayClass147_0.<<StoreJobAndTrigger>b__0>d.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 830
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.JobStoreSupport.<ExecuteInNonManagedTXLock>d__262`1.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3697
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Quartz.Impl.AdoJobStore.JobStoreSupport.<ExecuteInNonManagedTXLock>d__262`1.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 3712
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Impl.AdoJobStore.JobStoreSupport.<StoreJobAndTrigger>d__147.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Impl\AdoJobStore\JobStoreSupport.cs:line 828
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Core.QuartzScheduler.<ScheduleJob>d__82.MoveNext() in C:\projects\quartznet-6fcn8\src\Quartz\Core\QuartzScheduler.cs:line 616
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Quartz.Core.QuartzScheduler.Quartz.Simpl.IRemotableQuartzScheduler.ScheduleJob(IJobDetail jobDetail, ITrigger trigger) in C:\projects\quartznet-6fcn8\src\Quartz\Core\QuartzScheduler.cs:line 2291
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Quartz.Simpl.IRemotableQuartzScheduler.ScheduleJob(IJobDetail jobDetail, ITrigger trigger)
at Quartz.Impl.RemoteScheduler.CallInGuard[T](Func`2 func) in C:\projects\quartznet-6fcn8\src\Quartz\Impl\RemoteScheduler.cs:line 704
at Quartz.Impl.RemoteScheduler.ScheduleJob(IJobDetail jobDetail, ITrigger trigger, CancellationToken cancellationToken) in C:\projects\quartznet-6fcn8\src\Quartz\Impl\RemoteScheduler.cs:line 288
at Aseinfo.VH4.General.Controllers.AlertaController.<ScheduleJobAsync>d__43.MoveNext() in C:\vh4\VH4\General\Controllers\AlertaController.cs:line 1210
--- End of inner exception stack trace ---
at Aseinfo.VH4.General.Controllers.AlertaController.<ScheduleJobAsync>d__43.MoveNext() in C:\vh4\VH4\General\Controllers\AlertaController.cs:line 1215
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Aseinfo.VH4.General.Controllers.AlertaController.<StartImmediateAlerta>d__38.MoveNext() in C:\vh4\VH4\General\Controllers\AlertaController.cs:line 709
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass8_0.<BeginInvokeAsynchronousActionMethod>b__1(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_6.<BeginInvokeAction>b__4()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult)
triggers quartz
se puede observar la alerta, una solicitud de generación de planilla y una finalización, que es de la entidad centro de costo, pendiente.
