iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2026 · iT Synergy·

Root element is missing cuando se visualiza un servicio web net.tcp

May 27, 2014 By Jaime Alonso Páez torres Leave a Comment

Error

El siguiente error surge con un esquema expuesto como un servicio en un receive location tipo WCF-Custom que usa binding Net.tcp y que se hospeda in-process a BizTalk Server.  La descripción del servicio (wsdl) esta expuesta vía http por medio de Internet Information Services.

Este error se presenta al momento de dar browse al servicio.

WebHost failed to process a request.

Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/62476613

Exception: System.ServiceModel.ServiceActivationException: The service ‘/Test/TestSchema/TestSchemaService.svc’ cannot be activated due to an exception during compilation.  The exception message is: Root element is missing.. —> System.Xml.XmlException: Root element is missing.

   at System.Xml.XmlTextReaderImpl.Throw(Exception e)

   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()

   at System.Xml.XmlTextReaderImpl.Read()

   at System.Xml.XmlReader.MoveToContent()

   at System.Xml.XmlReader.ReadStartElement(String name)

   at Microsoft.BizTalk.Adapter.Wcf.Metadata.ReceiveLocationProxy.ExtractProperties(String customCfg)

   at Microsoft.BizTalk.Adapter.Wcf.Metadata.ReceiveLocationProxy.CreateRLConfig()

   at Microsoft.BizTalk.Adapter.Wcf.Metadata.MexServiceHostFactory.CreateServiceHost(String constructorString, Uri[] baseAddresses)

   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.CreateService(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)

   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.ActivateService(ServiceActivationInfo serviceActivationInfo, EventTraceActivity eventTraceActivity)

   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)

   — End of inner exception stack trace —

   at System.ServiceModel.ServiceHostingEnvironment.HostingManager.EnsureServiceAvailable(String normalizedVirtualPath, EventTraceActivity eventTraceActivity)

   at System.ServiceModel.ServiceHostingEnvironment.EnsureServiceAvailableFast(String relativeVirtualPath, EventTraceActivity eventTraceActivity)

Process Name: w3wp

Alternativa de Solución

La solución no esta muy relacionada con el error arrojado por BizTalk Server ya que se trata de un problema de permisos de usuario.

El usuario usado en el application pool que hospeda el servicio (generalmente se usa un usuario que pertenezca al grupo de BizTalk Isolated Host User) para poder ver su wsdl debe pertenecer a los siguientes grupos de BizTalk Server:

  • SSO Administrators
  • SSO Affiliate Administrators
  • BizTalk Isolated Host Users
  • BizTalk Administrators (esto porque posiblemente se requiere para los procesos net.tcp ya que el servicio esta hospedado en BizTalk y no en IIS)

Por último reiniciar el servidor.

Espero les funcione!

Filed Under: BizTalk, WCF

Error working with CRM OptionSet mapping component – “Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer.”

April 28, 2014 By Ana María Orozco Zuluaga Leave a Comment

When we work with SSIS to get data from a source and load then into CRM Dynamics, we have some option which allow us to manage the particular CRM data type like Picklist. In this case we were working with the components from KingswaySoft to performance this particular task.

Normally we use the shape: Dynamics CRM OptionSet Mapping to map the values from source and the values we have to assign for each value, See the pictures bellow:

In the sheet general, we have to specify the input column we want to assign, the CRM entity ante the picklist field which contains the option.

 

 

In some cases, the values we are using to mapping are too large. In that case when you execute the ETL you get the next error: “Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too large to fit in the column data area of the buffer”.

To solution this error: right click the OptionSet Mapping component and choose “Show Advanced Editor”. In the sheet: Input and Output Properties page select output and find the field you are mapping as CRM OptionSet field, and increase its Length property. Be sure you are writing a correct length for each field you are working with.

Filed Under: CRM OptionSet mapping component, Dynamics, ETL, KingswaySoft, Picklist, SSIS

Manejo de tipo de datos personalizados de Oracle en BizTalk

April 8, 2014 By Jaime Alonso Páez torres Leave a Comment

Necesidad

Crear un parámetro de Oracle que recibe un parámetro tipo lista que posee más de un campo en su estructura, para que sea invocado desde BizTalk Server.

Error

Al intentar llamar el procedimiento de Oracle que recibe este parámetro personalizado desde el send port, se genera el siguiente error:

The adapter failed to transmit message going to send port “Cliente.XYZ.Proyecto.Subproyecto.ProcedimientoOracle_WCF-Custom” with URL “oracledb://127.0.0.1:1521/ORCL/Dedicated”. It will be retransmitted after the retry interval specified for this Send Port. Details:”Microsoft.ServiceModel.Channels.Common.MetadataException: The assembly required for type mapping not found.

image

Solución

Es necesario crear los asemblies de los tipos creados en Oracle y que corresponden a los interpretados por el WCF Lob Adapter. Para ello al momento de crear los esquemas desde la opción de Consume Adapter Service se debe crear estos assemblies espedificando: la ruta completa de la dll y el strong name key (.snk) que firmará la dll), esto se hace en las propiedades de UDT .NET Type Generation – Run Time.

  • GeneratedUserTypesAssemblyFilePath
  • GeneratedUserTypesAssemblyKeyFilePath

image

En el send port configurado para consumir el procedimiento en Oracle se debe especificar la ruta donde quedó generado la dll del tipo generado en el paso anterior.

image

Mona gracias por la respuesta!

Filed Under: BizTalk

  • « Previous Page
  • 1
  • …
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • 72
  • Next Page »

Blog Authors

avatar for Marco Antonio Hernández PradoMarco Antonio Hernández Prado
avatar for Jaime Alonso Páez torresJaime Alonso Páez torres
avatar for Luis Carlos Bernal ÁvilaLuis Carlos Bernal Ávila
avatar for Ana María Orozco ZuluagaAna María Orozco Zuluaga
avatar for Juan Camilo Zapata MontúfarJuan Camilo Zapata Montúfar
avatar for Sonia Elizabeth Soriano ContrerasSonia Elizabeth Soriano Contreras
avatar for Diana Díaz GrijalbaDiana Díaz Grijalba
avatar for Carlos Alberto Rueda ValenzuelaCarlos Alberto Rueda Valenzuela
avatar for Bernardo Enrique Cardales AcuñaBernardo Enrique Cardales Acuña
avatar for Alexandra Bravo RestrepoAlexandra Bravo Restrepo
avatar for Juan Alberto Vélez CasadiegoJuan Alberto Vélez Casadiego
avatar for Jhon Jairo RodriguezJhon Jairo Rodriguez
avatar for Diana Paola Padilla BeltránDiana Paola Padilla Beltrán
avatar for Alejandro Garcia ForeroAlejandro Garcia Forero
avatar for Gustavo Adolfo Echeverry LópezGustavo Adolfo Echeverry López
avatar for Jesús Javier Hernández LópezJesús Javier Hernández López
avatar for Yully Arias CastilloYully Arias Castillo
avatar for Brayan RuizBrayan Ruiz
avatar for Carlos Andrés Vélez CasadiegoCarlos Andrés Vélez Casadiego
avatar for Odahir Rolando Salcedo TangarifeOdahir Rolando Salcedo Tangarife
avatar for Josué Leonardo Bohórquez MorenoJosué Leonardo Bohórquez Moreno
avatar for Natalia Zartha SuárezNatalia Zartha Suárez
avatar for Oscar Alberto Urrea MartinezOscar Alberto Urrea Martinez
avatar for Jimmy Quejada MenesesJimmy Quejada Meneses
avatar for Carolina Torres RodríguezCarolina Torres Rodríguez
avatar for Mario Andrés CortésMario Andrés Cortés
avatar for Juan Mauricio García TorresJuan Mauricio García Torres
avatar for Eric Yovanny Martinez GonzalezEric Yovanny Martinez Gonzalez

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org