Error al inscribir candidatos a concurso

Question

Dentro del concurso de seleccion, en la parte de Inscripcion de candidatos, realizo una busqueda, cuando le doy click al boton de cruz verde para agregar al candidato me muestra este error

alt text

Sucede lo mismo con candidatos internos y externos

Ahorita no tengo configurada ninguna alerta

Aqui esta el detalle del error:
System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_cfgale_cfgnta". The conflict occurred in database "EvoData", table "cfg.ale_alertas", column 'ale_codigo'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) 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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary2 identifierValues, List1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at Aseinfo.VH4.Data.AppDataContext.SaveChanges(SaveOptions options) at Aseinfo.Infrastructure.Base.Entity.GenericEntityRepository.SaveChanges() at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase`2.SaveChanges() at Aseinfo.VH4.Reclutamiento.Controllers.ConcursoSeleccionController.AgregarCandidato(Int32 id, Int32 candidatoId, TipoCandidatoConcurso tipo)

Answer 1

Cambia el trigger de la tabla rys.ccs_candidatos_concurso por esto:

    declare @codale_notif varchar(50)
    set @codale_notif = '075E8B0A-9897-4C40-B1B5-BA134676805C'

    insert into cfg.nta_notif_temp_alerta(nta_codale, nta_notificando)
    select @codale_notif, ccs_codigo
      from inserted
     where exists (select null from cfg.ale_alertas where ale_codigo = @codale_notif);

    delete cfg.nta_notif_temp_alerta
     where nta_codale = @codale_notif and exists(select 1 from deleted where nta_notificando = ccs_codigo)

Error al inscribir candidatos a concurso

Follow this question

Evolution en BitBucket

Evolution en JIRA

Related questions