iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

Copyright © 2024 · iT Synergy·

Issues when working with the BizTalk Adapter for Oracle Database
Issues when working with the BizTalk Adapter for Oracle Database avatar

By Leave a Comment

Recently I’ve been working on a new project where we have to integrate Oracle within some workflows we are implementing using BizTalk Server 2010.

I have encountered several issues, so I preferred to document the solution as I got them solved.  Hope it helps!

What I needed to do was to have a Polling Receive Location Listening from an Oracle Database. So I had to first test the connection from Visual Studio 2010 and import the schemas, then I had to create the receive location, with Transport Type WCF-Custom and Binding Type OracleDbBinding.  Within the Visual Studio Solution I made a simple orchestration where I have a Receive Port (From Oracle DB) and a Send Port (FILE) so I could see the file that was being generating from the Receive Location.

So, this is how I got it working:

My Environment Configuration

I have my development environment configured as follows:

  • Windows Server 2008 R2
  • Visual Studio 2010
  • BizTalk Server 2010
  • WCF LOB Adapter SDK x64
  • BizTalk Adapter Pack for both x32 and x64 bit machines
  • Oracle 11g Client 11.0.7.0 for both x32 and x64 (One home for each).

Issue 1: Error “Connecting to the LOB System has failed”

When trying to connect to the oracle database while importing the schemas from the Consume Adapter Service Console you get this error:

In my case was because I had installed only the 64 bit version of the Oracle 11g Client. So I had to install the 32 bit version also.

After installing the 32 bit version, I tested it again and now it worked like a charm.

Issue 2: Unable to load OraMTS Error when configuring a Polling Receive Location

After I deployed my sample biztalk solution for the polling exercise, I had to create the Receive Location that was supposed to do the polling on the Oracle Database. The Polling Statement was set to a simple SELECT * FROM Sentence. The receive location was configured having the WCF-Custom Transport Type with the OracleDbBinding Binding Type.  The polling interval was set to 60 seconds.  After the receive location was configured, an error kept on showing in the Event Viewer saying that it was Unable to load OraMTS.

For this to be fixed it is necessary to install the Oracle Services for Microsoft Transaction Server.  Since I had both 32 and 64 oracle client versions installed, I installed the Oracle Services for MTS for both:

Make sure you restart your machine after this installation, otherwise the error will keep on happening.

Cambio en la extension de Proyectos BizTalk de .btproj a .btproj.csproj
Cambio en la extension de Proyectos BizTalk de .btproj a .btproj.csproj avatar

By Leave a Comment

 

Si está utilizando el WCF LOB Adapter SDK SP2, es posible que al tratar de importar schemas  en un proyecto existente de BizTalk (.btproj) por la opcion “Add Generated Items –> Consume Adapter Service” le pase que el proyecto cambie de nombre a .btproj.csproj, y si revisa en la carpeta fisica en donde se encuentra el archivo del proyecto, probablemente verá dos proyectos uno btproj y uno csproj.  Esto es un bug con el SP2 del WCF LOB Adapter SDK.  Para solucionarlo Microsoft ya liberó un hotfix que lo puede solicitar en la siguiente pagina:

 

http://support.microsoft.com/kb/979096

 

Despues de aplicar el hotfix que recibió por correo, no olvide cerrar el visual studio y volverlo a abrir para que los cambios del hotfix tengan efecto.

Deshabilitar la Encripción de Itinerarios en ESB 2.0
Deshabilitar la Encripción de Itinerarios en ESB 2.0 avatar

By Leave a Comment

 

Por default, el diseñador de itinerarios del ESB Toolkit 2.0 tiene habilitada una encripción por certificados, lo que ocasiona un error cuando se intenta validar o exportar el itinerario, y no se ha seleccionado un certificado.  El error que se ve es de este tipo:

 

Error    1    A X509 Certificate is required in the model property ‘EncryptionCertificate’ to encrypt any sensitive property in the designer.   

 

Para deshabilitar la opción de utilizar el certificado, y poder validar y exportar los itinerarios sin que aparezca este error, se debe hacer lo siguiente:

1. En el directorio de instalación del ESB ir a la siguiente ruta: C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Tools\Itinerary Designer

2. Abrir el archivo ruleset.config

3. Ubicar la sección <property name=”EncryptionCertificate”>

4. Colocar en comentario la primera regla. Se debería ver algo así:

<property name=”EncryptionCertificate”>
<!–<validator type=”Microsoft.Practices.Modeling.Validation.X509CertificateContainerValidator, Microsoft.Practices.Modeling.Validation”
messageTemplate=”A X509 Certificate is required in the model property ‘{0}’ to encrypt any sensitive property in the designer.”
name=”EncryptingCertificate validator”/> –>
<!– Warning message when not enforcing encryption –>
            <validator type=”Microsoft.Practices.Modeling.Validation.X509CertificateContainerValidator, Microsoft.Practices.Modeling.Validation”
messageTemplate=”Some data may not be secured because no X509 Certificate was specified in the model property ‘{0}’.”
tag=”Warning”
name=”EncryptingCertificate (warning) validator”/>
</property>

 

5. Guardar los cambios.

6. Probar nuevamente y el error ya no debe aparecer.

Nota: Si el error pesiste, puede ser necesario cerrar y volver a abrir el Visual Studio.