iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

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

Copyright © 2025 · iT Synergy·

Manage DataEntities in Managed Service Engine
Manage DataEntities in Managed Service Engine avatar

January 10, 2011 By Marco Antonio Hernández Prado Leave a Comment

En varios clientes hemos encontrado el siguiente escenario, “se debe actualizar el servicio virtualizado ya que servicio original cambió, se virtualiza el servicio con la operación actualizada pero el servicio virtualizado no cambia”:

Para hacer más sencilla la explicación voy a realizar el ejemplo con un servicio mock generado para pruebas. Este servicio tiene una operación llamada AddNumbers esta operación tiene un MessageContract llamado NumberRequest y este tiene un DataContract llamado Numbers, la operación AddNumbers retorna un DataContract NumbersResponse. Este DataContract  en MSE se puede Visualizar en el Layout DataEntity Management.

 

Servicio visto con WCF Test Client con la operación AddNumbers, en esta podemos observar que obtiene el contrato Numbers, este tiene dos propiedades: Number1 y Number2

En MSE en el Layout DataEntity Management las podemos visualizar así:

Cambio en el Servicio

En el día a día nuestros servicios van cambiando tanto en sus operaciones como en sus contratos, en un mundo ideal deberíamos realizar cambios en los namespaces cuando cambie un contrato en un servicio, pero desafortunadamente así no es, en el mundo real de SOA MSE nos colabora con la administración de estas entidades (Contratos), primero veamos la actualización del Servicio WCF, esta fue hecha de una vez al contrato si haber realizado cambio alguno en el servicio o en el namespace.

 

 

Como hemos identificado que cambio el contrato, en el MSE lo que hacemos es una importación de schemas, no es necesario realizar importación de operaciones o de recursos.

 

Aquí seleccionamos Import Schemas

Seleccionamos los esquemas o esquema a importar, para nuestro caso vamos a seleccionarlos todos:

 

 

Después de la importación Exitosa, vamos al Menú Tools-Manage Service Model Components-Data Entities

 

En el menú desplegable seleccionamos el schema que queremos actualizar, para nuestro caso el schema numbers que está en el namespace http://xxxx/guidances/mockservices/datacontracts/numbers/1.0, seleccionamos la entidad de Tipo Complejo (Complex Type)

 

Si hay más de una versión(revisión)de esta entidad MSE nos muestra está información por fechas, aquí podemos ver que en la revisión del 1/11/2011 1:00:28 AM la entidad Numbers tiene dos propiedades, Number1 y Number2

image

La revisión Latest Revision la entidad Numbers tiene tres propiedades, Number1, Number2 y Number3, esta revisión es la que vamos a seleccionar

Seleccionamos Update Revision Reference

 

 

Aquí visualizamos que revisión hemos seleccionado:

En la pestaña Update References seleccionamos por cual revisión vamos a reemplazar la que seleccionamos, en este caso vamos a reemplazar la revisión Latest revision por la revisión 1/11/2011 1:00:28 AM

 

 

Cuando finalizamos el registro del Schema lo que sucede al final es la actualización de la Tabla SchemaObjectDependencies, cambia la asociación entre las columnas SchemaObjectID y ParentObjectID, después de la importación podemos reiniciar los servicios de MSE Runtime y hacer la actualización del Servicio expuesto por el MSE

 

Aquí volvemos a realizar el llamado por medio del WCF Test Client y ya vemos actualizada la entidad con el cambio solicitado

 

Filed Under: .NET, MSE, WCF Tagged With: MSE, WCF

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

January 4, 2011 By Sonia Elizabeth Soriano Contreras 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

Filed Under: BizTalk, BizTalk 2010 configurations, BizTalk Application, BizTalk Services, SOA

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

January 4, 2011 By Sonia Elizabeth Soriano Contreras 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.

Filed Under: BizTalk, BizTalk 2010 configurations, BizTalk Application, Integración, Oracle Data Adapter

  • « Previous Page
  • 1
  • …
  • 49
  • 50
  • 51
  • 52
  • 53
  • …
  • 72
  • Next Page »

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Sonia
Elizabeth Soriano

Diana
Díaz Grijalba

Carlos
Alberto Rueda

Bernardo
Enrique Cardales

Alexandra
Bravo Restrepo

Juan
Alberto Vélez

Diana
Paola Padilla

Jhon
Jairo Rodriguez

Brayan
Ruiz

Jesús
Javier Hernández

Alejandro
Garcia Forero

Gustavo
Adolfo Echeverry

Yully
Arias Castillo

Carlos
Andrés Vélez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Jimmy
Quejada Meneses

Natalia
Zartha Suárez

Josué
Leonardo Bohórquez

Mario
Andrés Cortés

Eric
Yovanny Martinez

Carolina
Torres Rodríguez

Juan
Mauricio García

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

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