Me dispongo a generar planilla, pero algunas veces cuando lo realizo me surge el error
Se ha producido un inconveniente...
La acción 'GenerarPlanilla' del controlador 'PeriodoPlanilla' ha lanzado la excepción 'UpdateException' con el mensaje: An error occurred while updating the entries. See the inner exception for details.
Ocultar información técnica
System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.InvalidOperationException: The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements. at System.Data.SqlClient.SqlInternalConnectionTds.CheckEnlistedTransactionBinding() at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc) 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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 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) in c:\clientes\AEI\VH4\Data\Model\AppDataContext.cs:line 81 at Aseinfo.Infrastructure.Base.Entity.GenericEntityRepository.SaveChanges() in c:\EvolutionAEI\Infrastructure\Base\Entity\GenericEntityRepository.cs:line 201 at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase`2.SaveChanges() in c:\EvolutionAEI\Infrastructure\Base\Entity\EntityServiceBase.cs:line 519 at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase`2.DoInsert(T entity, Boolean saveChanges, Boolean bypassWorkflowInitialization) in c:\EvolutionAEI\Infrastructure\Base\Entity\EntityServiceBase.cs:line 776 at Aseinfo.VH4.Salarios.Controllers.PeriodoPlanillaController.GenerarPlanilla(List`1 codigosPeriodoPlanilla) in c:\BuildAgent\work\5ed3bec7206feb61\VH4\Salarios\Controllers\PeriodoPlanillaController.cs:line 229 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
Y lo soluciono con el reinicio del servicio de generación de planilla.
Esto pasa muy seguido, como podría arreglarlo?
asked
12 Jun '13, 22:55
JulioRosales
(suspended)
accept rate:
26%
¿Cuando creaste las colas del MSMQ, las creaste transaccionales?
Correcto tal y como lo indica la presentación de instalación
A mí también me ha pasado algunas veces; pero no hay patrón definido. Yo no tengo que reiniciar el servicio, solo volver a generar la planilla.