iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

Copyright © 2024 · iT Synergy·

MSE Collaborative Development – XML Static Response
MSE Collaborative Development – XML Static Response avatar

By Leave a Comment

Managed Services Engine nos permite entregar respuestas de los servicios virtualizados así no tengamos construida la lógica de estos sino solo la fachada construida (contract first). La solución para este tema es static response. Veamos un ejemplo con el siguiente escenario.

En este escenario podemos considerar dos temas importantes, el primero es que los servicios no han sido finalizados, solo crearon sus fachadas, el segundo es que solo el servidor MSE tiene acceso a los Servidores de Servicios pero el Desarrollador no, el objetivo es virtualizar por medio del MSE los servicios del Server A Y B, crear una respuesta static y realizar el llamado desde la Developer Machine

1. Virtualización el Servicio

 

Las operaciones debemos virtualizarlas normalmente como cualquier otro servicio

2. Definir Static Response a la Operación

En el Layout End to End Item Management, damos click a la operación y con esta podemos ver en la parte inferior derecha las Entidades de Datos (Data Entities), un entidad es tipo Request y Otra tipo Response, para esta caso vamos a usar la entidad de Respuesta llamada CrearOrdenResponse

Al dar doble click sobre la Entidad podemos visualizar el contenido del Schema

Con la definición de este schema podemos crear el archivo XML de Respuesta, para esto nos podemos apoyar en la herramienta Liquid XML Studio http://www.liquid-technologies.com/ .

Copiamos el contenido del schemas en un archivo lo guardamos con extensión .xsd y lo abrimos con XML Liquid, con este podemos ir al Menu tools y generar un archivo XML de Ejemplo

 

Este es un ejemplo del archivo que genera la herramienta

Para copiar el xml de respuesta debemos ir a la operación (Crear Orden) y darle doble click, esto lo hacemos por el layout End to End Item Management, con la operacion desplegada  copiamos el contenido en la pestaña Static Response . Para que MSE pueda responder sin ir al servicio debemos deseleccionar la opción Active y Seleccionar la opción Testable

Con esto ya configurado podemos realizar un llamado al servicio y este nos responde. Incluso si no enviamos parámetro alguno.

WCF TestClient Portable
WCF TestClient Portable avatar

By Leave a Comment

En diferentes proyectos hemos necesitado de esta herramienta para testear servicios en Producción, WCF Test client viene con Visual Studio 2008/2010, esta versión se puede descargar aquí, y se puede mover de un sitio a otro. Pueden descargarla WcfTestClient

Existen ciertas limitaciones con esta herramienta para ciertas operaciones de servicios WCF o tipos complejos datos de retorno (array)

Otra Herramienta interesante es wizdl. Pueden entrar a http://wizdl.codeplex.com/ , esta nos da facilidad de ingresar los datos de array de una manera más sencilla.

The BizTalk Adapter for Oracle Database – Making Polling work
The BizTalk Adapter for Oracle Database – Making Polling work avatar

By Leave a Comment

After troubleshooting my previous issues with the connection to the Oracle Database using the Oracle Database Adapter (see my previous post)  I was able now to focus on making the polling to the oracle database work.

I implemented a sample BizTalk solution where I have an orchestration which only has the receive and the send ports.

The Receive is supposed to do the polling by means of a SELECT Statement to a table in my Oracle DB, and the Send Port sends the received message to a FILE Send Port.  That’s it.

First I had to import the schemas in the Consume Service Adapter Wizard, on my first try I did it wrong, I imported the schemas without specifying a pollingId, and without specifying the SELECT statement.  What I did was just to get the Select from the Table:

This actually imported the schemas.  After setting the MessageType to the imported schema, and deploying my BizTalk Solution I configured my receive and send ports.  The Receive Location was configured with the SELECT sentence in the PollingStatement, and I set the PollingInterval to 60 seconds. Also, this receive location was configured with WCF-Custom Transport Type and OracleDbBinding for the Binding Type. The Receive Pipeline was set to XML Receive.

For the send port, I just made a simple FILE Send Port and configured it with Send Pipeline XML Transmit.

After binding the orchestration to the recently created receive and send ports, and starting the application, the thing never worked.  I was complicating my life more than I had to…

When the application was started, and the polling began, there was an error happening. In the Event Viewer I started to see the following:

There was a failure executing the receive pipeline: “Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35” Source: “XML disassembler” Receive Port: “Rcv_OraclePolling” URI: “oracledb://dddddd” Reason: Finding the document specification by message type “http://Microsoft.LobServices.OracleDB/2007/03/POLLINGSTMT#POLLINGSTMT” failed. Verify the schema deployed properly.

Well, this wasn’t the schema I was expecting.  I went through some reading and found that the way I had imported the schemas was very wrong.

The right way to do it is as follows.

In the Consume Service Adapter Wizard specify the SELECT query and a Polling Id to identify the query (this will help a lot if you are going to have more than one polling receive location in your BizTalk solution):

After setting this you are set to go.  Click OK and then try to Connect:

You can notice several things here.  First you have a PollingId in the URI string, second in the Contract Type you have to select Service (Inbound Operations), and third, when you click the Root (/) under the Category selection, you will find in the available categories and operations windows the POLLINGSTMT,  WOW!! Yep, this is what BizTalk was expecting from the query polled.

After this you have the right schema, and also you have the Binding for the Receive Location generated (so you don’t have to worry about creating it from scratch).

Then I just change the Message Type to the correct Schema POLLINGSTMT and change the Requests types for the Receive and Send Ports. Then deployed, imported the binding file to create the receive location and that’s it!  It worked!

I would finally get my output file as desired.

For some people there must be much easier just to get the Oracle Database Adapter Sample available from http://msdn.microsoft.com/en-us/biztalk/gg491395, well, I actually got the sample and opened in my Visual Studio, the thing was that I never understood that the POLLINGSTMT schema was supposed to be created from the schema generation in the Consume Adapter Service Wizard.  So after spending some time with the errors and reading a bit, a finally got to the understand and get my solution to work.  Hope it helps!

Some good links for understanding Polling:

http://msdn.microsoft.com/en-us/library/cc185291(BTS.10).aspx

http://msdn.microsoft.com/en-us/library/cc185181(BTS.10).aspx

http://msdn.microsoft.com/en-us/library/dd788457(BTS.10).aspx

http://msdn.microsoft.com/en-us/library/dd788193(v=BTS.10).aspx

http://msdn.microsoft.com/en-us/library/dd788064(BTS.10).aspx