Recibo el siguiente error al generar planilla en Evolution, el sitio web está instalado en una maquina virtual WinServer 2008, y la BD en mi equipo. El DTC está habilitado en ambos equipos al igual que las reglas de Firewall para que puedan comunicarse.

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<error host="EVOLUTIONLAFISE" type="System.Runtime.InteropServices.COMException" message="Error HRESULT E_FAIL has been returned from a call to a COM component." source="System.Transactions" detail="System.Data.EntityException: The underlying provider failed on Open. ---> System.Transactions.TransactionManagerCommunicationException: Communication with the underlying transaction manager has failed. ---> System.Runtime.InteropServices.COMException: Error HRESULT E_FAIL has been returned from a call to a COM component.
 at System.Transactions.Oletx.IDtcProxyShimFactory.ReceiveTransaction(UInt32 propgationTokenSize, Byte[] propgationToken, IntPtr managedIdentifier, Guid& transactionIdentifier, OletxTransactionIsolationLevel& isolationLevel, ITransactionShim& transactionShim)
 at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken)
 --- End of inner exception stack trace ---
 at System.Transactions.TransactionInterop.GetOletxTransactionFromTransmitterPropigationToken(Byte[] propagationToken)
 at System.Transactions.TransactionStatePSPEOperation.PSPEPromote(InternalTransaction tx)
 at System.Transactions.TransactionStateDelegatedBase.EnterState(InternalTransaction tx)
 at System.Transactions.EnlistableStates.Promote(InternalTransaction tx)
 at System.Transactions.Transaction.Promote()
 at System.Transactions.TransactionInterop.ConvertToOletxTransaction(Transaction transaction)
 at System.Transactions.TransactionInterop.GetExportCookie(Transaction transaction, Byte[] whereabouts)
 at System.Data.SqlClient.SqlInternalConnection.GetTransactionCookie(Transaction transaction, Byte[] whereAbouts)
 at System.Data.SqlClient.SqlInternalConnection.EnlistNonNull(Transaction tx)
 at System.Data.SqlClient.SqlInternalConnection.Enlist(Transaction tx)
 at System.Data.SqlClient.SqlInternalConnectionTds.Activate(Transaction transaction)
 at System.Data.ProviderBase.DbConnectionInternal.ActivateConnection(Transaction transaction)
 at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
 at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
 at System.Data.SqlClient.SqlConnection.Open()
 at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
 --- End of inner exception stack trace ---
 at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure)
 at System.Data.EntityClient.EntityConnection.Open()
 at System.Data.Objects.ObjectContext.EnsureConnection()
 at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)
 at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
 at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
 at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
 at Aseinfo.VH4.Expedientes.Services.EmpleoService.GetEmpleosSegunCodigos(IEnumerable`1 codigosEmpleados, Expression`1[] includes) in c:\BuildAgent\work\5ed3bec7206feb61\VH4\Expedientes\Services\Empleos\EmpleoService.cs:line 56
 at Aseinfo.VH4.Expedientes.Services.EmpleoService.GetEmpleosSegunCodigos(IEnumerable`1 codigosEmpleados) in c:\BuildAgent\work\5ed3bec7206feb61\VH4\Expedientes\Services\Empleos\EmpleoService.cs:line 45
 at Aseinfo.VH4.Salarios.Controllers.PeriodoPlanillaController.GenerarPlanilla(List`1 codigosPeriodoPlanilla) in c:\BuildAgent\work\5ed3bec7206feb61\VH4\Salarios\Controllers\PeriodoPlanillaController.cs:line 225
 at lambda_method(Closure , ControllerBase , Object[] )
 at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
 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.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()
 at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
 at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()
 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)" user="admin" time="2013-05-30T22:26:13.4039200Z">
<serverVariables>
<item name="ALL_HTTP">
<value string="HTTP_CACHE_CONTROL:max-age=0
 HTTP_CONNECTION:keep-alive
 HTTP_CONTENT_LENGTH:335
 HTTP_CONTENT_TYPE:application/x-www-form-urlencoded
 HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 HTTP_ACCEPT_ENCODING:gzip,deflate,sdch
 HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.8
 HTTP_COOKIE:ASP.NET_SessionId=kq5zai15nmml0uw0uboi20ox; .ASPXFORMSAUTH=A873A13D58D422CCD1080A7E99938E876A7E116DA4B891D24CF3FFA9DF5D74220A62B98D2C0B2027F23A8A7A6970F137115A5828F7F5D9DB3EB12D21BB719904B49BF527F910070BCC95B54958F55FA4FAB558DED3E865EC9CD9FDC8A9AA764BCE5100B9156F15D7E80B7FE4C49D2785FC63A53C003A90582B56FD430C9F27A4F0CBCAAE22415260080E5103E82C92CA; UsernameCookieKey=; __RequestVerificationToken_L0V2b2x1dGlvbg__=nBONAl5hrnJ2d/b4HZy/W4bOLJ0hj1HCMMEy7il27dgObEffWmOz9wWOlUtC6E29Wq0xlzOzWmyF0QHiB8qlkuCmNu4jYhSGTN92ZFzaI0cQhU9HQ7XYmxU07vXPYHnk/HNLwqVGPoTg2gNw+9giwQJQVgZfeyt+cKv7tEtmO/I=
 HTTP_HOST:localhost
 HTTP_REFERER:http://localhost/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla
 HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.94 Safari/537.36
 HTTP_ORIGIN:http://localhost
 "/>
</item>
<item name="ALL_RAW">
<value string="Cache-Control: max-age=0
 Connection: keep-alive
 Content-Length: 335
 Content-Type: application/x-www-form-urlencoded
 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
 Accept-Encoding: gzip,deflate,sdch
 Accept-Language: en-US,en;q=0.8
 Cookie: ASP.NET_SessionId=kq5zai15nmml0uw0uboi20ox; .ASPXFORMSAUTH=A873A13D58D422CCD1080A7E99938E876A7E116DA4B891D24CF3FFA9DF5D74220A62B98D2C0B2027F23A8A7A6970F137115A5828F7F5D9DB3EB12D21BB719904B49BF527F910070BCC95B54958F55FA4FAB558DED3E865EC9CD9FDC8A9AA764BCE5100B9156F15D7E80B7FE4C49D2785FC63A53C003A90582B56FD430C9F27A4F0CBCAAE22415260080E5103E82C92CA; UsernameCookieKey=; __RequestVerificationToken_L0V2b2x1dGlvbg__=nBONAl5hrnJ2d/b4HZy/W4bOLJ0hj1HCMMEy7il27dgObEffWmOz9wWOlUtC6E29Wq0xlzOzWmyF0QHiB8qlkuCmNu4jYhSGTN92ZFzaI0cQhU9HQ7XYmxU07vXPYHnk/HNLwqVGPoTg2gNw+9giwQJQVgZfeyt+cKv7tEtmO/I=
 Host: localhost
 Referer: http://localhost/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla
 User-Agent: Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.94 Safari/537.36
 Origin: http://localhost
 "/>
</item>
<item name="APPL_MD_PATH">
<value string="/LM/W3SVC/1/ROOT/Evolution"/>
</item>
<item name="APPL_PHYSICAL_PATH">
<value string="C:\inetpub\wwwroot\Evolution\"/>
</item>
<item name="AUTH_TYPE">
<value string="Forms"/>
</item>
<item name="AUTH_USER">
<value string="admin"/>
</item>
<item name="AUTH_PASSWORD">
<value string=""/>
</item>
<item name="LOGON_USER">
<value string="admin"/>
</item>
<item name="REMOTE_USER">
<value string="admin"/>
</item>
<item name="CERT_COOKIE">
<value string=""/>
</item>
<item name="CERT_FLAGS">
<value string=""/>
</item>
<item name="CERT_ISSUER">
<value string=""/>
</item>
<item name="CERT_KEYSIZE">
<value string=""/>
</item>
<item name="CERT_SECRETKEYSIZE">
<value string=""/>
</item>
<item name="CERT_SERIALNUMBER">
<value string=""/>
</item>
<item name="CERT_SERVER_ISSUER">
<value string=""/>
</item>
<item name="CERT_SERVER_SUBJECT">
<value string=""/>
</item>
<item name="CERT_SUBJECT">
<value string=""/>
</item>
<item name="CONTENT_LENGTH">
<value string="335"/>
</item>
<item name="CONTENT_TYPE">
<value string="application/x-www-form-urlencoded"/>
</item>
<item name="GATEWAY_INTERFACE">
<value string="CGI/1.1"/>
</item>
<item name="HTTPS">
<value string="off"/>
</item>
<item name="HTTPS_KEYSIZE">
<value string=""/>
</item>
<item name="HTTPS_SECRETKEYSIZE">
<value string=""/>
</item>
<item name="HTTPS_SERVER_ISSUER">
<value string=""/>
</item>
<item name="HTTPS_SERVER_SUBJECT">
<value string=""/>
</item>
<item name="INSTANCE_ID">
<value string="1"/>
</item>
<item name="INSTANCE_META_PATH">
<value string="/LM/W3SVC/1"/>
</item>
<item name="LOCAL_ADDR">
<value string="::1"/>
</item>
<item name="PATH_INFO">
<value string="/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla"/>
</item>
<item name="PATH_TRANSLATED">
<value string="C:\inetpub\wwwroot\Evolution\Salarios\PeriodoPlanilla\GenerarPlanilla"/>
</item>
<item name="QUERY_STRING">
<value string=""/>
</item>
<item name="REMOTE_ADDR">
<value string="::1"/>
</item>
<item name="REMOTE_HOST">
<value string="::1"/>
</item>
<item name="REMOTE_PORT">
<value string="49230"/>
</item>
<item name="REQUEST_METHOD">
<value string="POST"/>
</item>
<item name="SCRIPT_NAME">
<value string="/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla"/>
</item>
<item name="SERVER_NAME">
<value string="localhost"/>
</item>
<item name="SERVER_PORT">
<value string="80"/>
</item>
<item name="SERVER_PORT_SECURE">
<value string="0"/>
</item>
<item name="SERVER_PROTOCOL">
<value string="HTTP/1.1"/>
</item>
<item name="SERVER_SOFTWARE">
<value string="Microsoft-IIS/7.0"/>
</item>
<item name="URL">
<value string="/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla"/>
</item>
<item name="HTTP_CACHE_CONTROL">
<value string="max-age=0"/>
</item>
<item name="HTTP_CONNECTION">
<value string="keep-alive"/>
</item>
<item name="HTTP_CONTENT_LENGTH">
<value string="335"/>
</item>
<item name="HTTP_CONTENT_TYPE">
<value string="application/x-www-form-urlencoded"/>
</item>
<item name="HTTP_ACCEPT">
<value string="text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"/>
</item>
<item name="HTTP_ACCEPT_ENCODING">
<value string="gzip,deflate,sdch"/>
</item>
<item name="HTTP_ACCEPT_LANGUAGE">
<value string="en-US,en;q=0.8"/>
</item>
<item name="HTTP_COOKIE">
<value string="ASP.NET_SessionId=kq5zai15nmml0uw0uboi20ox; .ASPXFORMSAUTH=A873A13D58D422CCD1080A7E99938E876A7E116DA4B891D24CF3FFA9DF5D74220A62B98D2C0B2027F23A8A7A6970F137115A5828F7F5D9DB3EB12D21BB719904B49BF527F910070BCC95B54958F55FA4FAB558DED3E865EC9CD9FDC8A9AA764BCE5100B9156F15D7E80B7FE4C49D2785FC63A53C003A90582B56FD430C9F27A4F0CBCAAE22415260080E5103E82C92CA; UsernameCookieKey=; __RequestVerificationToken_L0V2b2x1dGlvbg__=nBONAl5hrnJ2d/b4HZy/W4bOLJ0hj1HCMMEy7il27dgObEffWmOz9wWOlUtC6E29Wq0xlzOzWmyF0QHiB8qlkuCmNu4jYhSGTN92ZFzaI0cQhU9HQ7XYmxU07vXPYHnk/HNLwqVGPoTg2gNw+9giwQJQVgZfeyt+cKv7tEtmO/I="/>
</item>
<item name="HTTP_HOST">
<value string="localhost"/>
</item>
<item name="HTTP_REFERER">
<value string="http://localhost/Evolution/Salarios/PeriodoPlanilla/GenerarPlanilla"/>
</item>
<item name="HTTP_USER_AGENT">
<value string="Mozilla/5.0 (Windows NT 6.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.94 Safari/537.36"/>
</item>
<item name="HTTP_ORIGIN">
<value string="http://localhost"/>
</item>
</serverVariables>
<form>
<item name="__RequestVerificationToken">
<value string="E3qHZhEKpU0qH9zvDzlrlMrHP2B5Vzg+9VsZHtB+6OYUi1HKClH8zqiMWoiigOOS4p1FIUGvxRqVj8IhyKp0taJS8GavjKBbBcCN/aP9CtaETnFlltWJ/3AbkzpI5sfQDYsUSzhPrqGfN5Jm0gFlJ8PmAeTkXtZQMfcw6OqQp5SBhL8tmSoFmo/zyl1MBnWE"/>
</item>
<item name="__ApplicationConsistencyKey">
<value string="u7JkNTJPlnFjZ/jsvToXixYqtOMM67qFev0TlYpwh+g="/>
</item>
<item name="codigosPeriodoPlanilla">
<value string="220"/>
</item>
</form>
<cookies>
<item name="ASP.NET_SessionId">
<value string="kq5zai15nmml0uw0uboi20ox"/>
</item>
<item name=".ASPXFORMSAUTH">
<value string="A873A13D58D422CCD1080A7E99938E876A7E116DA4B891D24CF3FFA9DF5D74220A62B98D2C0B2027F23A8A7A6970F137115A5828F7F5D9DB3EB12D21BB719904B49BF527F910070BCC95B54958F55FA4FAB558DED3E865EC9CD9FDC8A9AA764BCE5100B9156F15D7E80B7FE4C49D2785FC63A53C003A90582B56FD430C9F27A4F0CBCAAE22415260080E5103E82C92CA"/>
</item>
<item name="UsernameCookieKey">
<value string=""/>
</item>
<item name="__RequestVerificationToken_L0V2b2x1dGlvbg__">
<value string="nBONAl5hrnJ2d/b4HZy/W4bOLJ0hj1HCMMEy7il27dgObEffWmOz9wWOlUtC6E29Wq0xlzOzWmyF0QHiB8qlkuCmNu4jYhSGTN92ZFzaI0cQhU9HQ7XYmxU07vXPYHnk/HNLwqVGPoTg2gNw+9giwQJQVgZfeyt+cKv7tEtmO/I="/>
</item>
</cookies>
</error>

asked 30 May '13, 22:37

Danny%20Villalta's gravatar image

Danny Villalta
(suspended)
accept rate: 33%

edited 31 May '13, 15:17

sabanito's gravatar image

sabanito ♦♦
(suspended)


Para solucionar el error hice lo siguiente:

  • Desactivar el firewall del servidor web (Mi maquina virtual)

  • En mi equipo (Servidor BD), En el component services, Mi PC --> Propiedades --> Propiedades predeterminadas --> Habilitar COM en este equipo

  • Ejecutar el comando en SQL Management Studio: exec sp_configure 'remote proc trans','1' reconfigure with override

link

answered 31 May '13, 14:45

Danny%20Villalta's gravatar image

Danny Villalta
(suspended)
accept rate: 33%

Importante. La maquina virtual tuve que agregarla al mismo dominio que mi maquina (en mi caso aseinfo.com.pa ya que por defecto suele ser workgroup)

(31 May '13, 15:35) Danny Villalta Danny%20Villalta's gravatar image

Según veo en el error, no se pudo conectar con el MSDTC. Intentá de nuevo y antes baja el DTC y lo volves a subir...

link

answered 30 May '13, 22:46

sabanito's gravatar image

sabanito ♦♦
(suspended)
accept rate: 54%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Evolution en BitBucket

En este sitio puede acceder al código fuente, centro de descargas y reportar bugs, propuestas y mejoras para Evolution.

Evolution en JIRA

En este sitio puedes sugerir nueva funcionalidad para Evolution, o puedes votar por la funcionalidad ya propuesta por otros usuarios.

Tags:

×25
×7

Asked: 30 May '13, 22:37

Seen: 39,831 times

Last updated: 31 May '13, 15:35

[Acerca de] [Preguntas Frecuentes] [Privacidad] [Soporte] [Contacto]
Copyright 2013-2018. Asesores en Informática