Forum Replies Created
-
AuthorPosts
-
The node in question is the Authors node in O/p xml ……. the Record->Author node in i/p is mapped to Authors->Author of o/p
even though the record –>Author value repeats in i/p it appears only once in Authors–> Author
I/p
<ns0:LibraryData LibraryName=”LibraryName_0″ xmlns:ns0=”http://Library.Books.Schemas.LibraryData”>
<ns0:Record>
<ns0:Title>ABC</ns0:Title>
<ns0:Author>JOHN</ns0:Author>
<ns0:ISBN>123234123123</ns0:ISBN>
<ns0:CheckOutDate>CheckOutDate_0</ns0:CheckOutDate>
</ns0:Record>
<ns0:Record>
<ns0:Title>XYZ</ns0:Title>
<ns0:Author>JOHN</ns0:Author>
<ns0:ISBN>5435345123</ns0:ISBN>
<ns0:CheckOutDate>CheckOutDate_0</ns0:CheckOutDate>
</ns0:Record>
<ns0:Record>
<ns0:Title>HIJ</ns0:Title>
<ns0:Author>BOB</ns0:Author>
<ns0:ISBN>65445435123</ns0:ISBN>
<ns0:CheckOutDate>CheckOutDate_0</ns0:CheckOutDate>
</ns0:Record>
<ns0:Record>
<ns0:Title>SWT</ns0:Title>
<ns0:Author>JOHN</ns0:Author>
<ns0:ISBN>65445435128</ns0:ISBN>
<ns0:CheckOutDate>CheckOutDate_0</ns0:CheckOutDate>
</ns0:Record>
<ns0:Record>
<ns0:Title>LMN</ns0:Title>
<ns0:Author>BOB</ns0:Author>
<ns0:ISBN>65445435124</ns0:ISBN>
<ns0:CheckOutDate>CheckOutDate_0</ns0:CheckOutDate>
</ns0:Record>
</ns0:LibraryData>O/P
<ns0:ExportList xmlns:ns0=”http://Library.Books.Schemas.ExportList”>
<ns0:BatchData ns0:BatchIdentifier=”BatchIdentifier_0″>
<ns0:Authors>
<ns0:Author>
<ns0:Name>JOHN</ns0:Name>
<ns0:Code>Code_0</ns0:Code>
</ns0:Author>
<ns0:Author>
<ns0:Name>BOB</ns0:Name>
<ns0:Code>Code_1</ns0:Code>
</ns0:Author>
</ns0:Authors>
<ns0:BookRecords>
<ns0:Book>
<ns0:Title>ABC</ns0:Title>
<ns0:ISBN>123234123123</ns0:ISBN>
<ns0:LastUsedDate>CheckOutDate_0</ns0:LastUsedDate>
</ns0:Book>
<ns0:Book>
<ns0:Title>XYZ</ns0:Title>
<ns0:ISBN>5435345123</ns0:ISBN>
<ns0:LastUsedDate>CheckOutDate_0</ns0:LastUsedDate>
</ns0:Book>
<ns0:Book>
<ns0:Title>HIJ</ns0:Title>
<ns0:ISBN>65445435123</ns0:ISBN>
<ns0:LastUsedDate>CheckOutDate_0</ns0:LastUsedDate>
</ns0:Book>
<ns0:Book>
<ns0:Title>SWT</ns0:Title>
<ns0:ISBN>65445435128</ns0:ISBN>
<ns0:LastUsedDate>CheckOutDate_0</ns0:LastUsedDate>
</ns0:Book>
<ns0:Book>
<ns0:Title>LMN</ns0:Title>
<ns0:ISBN>65445435124</ns0:ISBN>
<ns0:LastUsedDate>CheckOutDate_0</ns0:LastUsedDate>
</ns0:Book>
</ns0:BookRecords>
</ns0:BatchData>
</ns0:ExportList>-Jerry
Thanks for a very good answer. I tried the last bit, configured the map’s custom Xslt property to point to the xslt file. It went about 20 percent faster, so it helps 🙂 I will try do do your first suggestion, do you think it will improve perfomance much? Any other special tips for speeding up? 🙂
Sorry about the double post
If I type a dot at the end of “Msg_Request.DebiteringsunderlagsId” I dont see any additional field names
This is what I found on when surfing to web of HamtaStatus
POST /duws/du.asmx HTTP/1.1
Host: sesoaw252
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: “http://debiteringsunderlag.se/hamtaStatus“<?xml version=”1.0″ encoding=”utf-8″?>
<soap:Envelope xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/“>
<soap:Body>
<hamtaStatus xmlns=”http://debiteringsunderlag.se/“>
<DebiteringsunderlagsId>
<int>int</int>
<int>int</int>
</DebiteringsunderlagsId>
<KallaID>int</KallaID>
</hamtaStatus>
</soap:Body>
</soap:Envelope>I didnt notice that your response was on the second page. [:)]
This a part of the wsdl file of HamtaStatus<wsdl:types>
<s:schema elementFormDefault=”qualified” targetNamespace=”http://debiteringsunderlag.se/“>
<s:element name=”hamtaStatus”>
<s:complexType>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”DebiteringsunderlagsId” type=”tns:ArrayOfInt” />
<s:element minOccurs=”1″ maxOccurs=”1″ name=”KallaID” type=”s:int” />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name=”ArrayOfInt”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”unbounded” name=”int” type=”s:int” />
</s:sequence>
</s:complexType>
<s:element name=”hamtaStatusResponse”>
<s:complexType>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”hamtaStatusResult” type=”tns:Status” />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name=”Status”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”underlag” type=”tns:ArrayOfUnderlag” />
</s:sequence>
</s:complexType>
<s:complexType name=”ArrayOfUnderlag”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”unbounded” name=”underlag” nillable=”true” type=”tns:underlag” />
</s:sequence>
</s:complexType>
<s:complexType name=”underlag”>
<s:sequence>
<s:element minOccurs=”1″ maxOccurs=”1″ name=”DebiteringsunderlagsID” type=”s:int” />
<s:element minOccurs=”1″ maxOccurs=”1″ name=”StatusID” type=”s:int” />
<s:element minOccurs=”0″ maxOccurs=”1″ name=”Status” type=”s:string” />
<s:element minOccurs=”0″ maxOccurs=”1″ name=”Meddelande” type=”s:string” />
</s:sequence>
</s:complexType>I didnt notice that your response was on the second page. [:)]
This a part of the wsdl file of HamtaStatus<wsdl:types>
<s:schema elementFormDefault=”qualified” targetNamespace=”http://debiteringsunderlag.se/“>
<s:element name=”hamtaStatus”>
<s:complexType>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”DebiteringsunderlagsId” type=”tns:ArrayOfInt” />
<s:element minOccurs=”1″ maxOccurs=”1″ name=”KallaID” type=”s:int” />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name=”ArrayOfInt”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”unbounded” name=”int” type=”s:int” />
</s:sequence>
</s:complexType>
<s:element name=”hamtaStatusResponse”>
<s:complexType>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”hamtaStatusResult” type=”tns:Status” />
</s:sequence>
</s:complexType>
</s:element>
<s:complexType name=”Status”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”1″ name=”underlag” type=”tns:ArrayOfUnderlag” />
</s:sequence>
</s:complexType>
<s:complexType name=”ArrayOfUnderlag”>
<s:sequence>
<s:element minOccurs=”0″ maxOccurs=”unbounded” name=”underlag” nillable=”true” type=”tns:underlag” />
</s:sequence>
</s:complexType>
<s:complexType name=”underlag”>
<s:sequence>
<s:element minOccurs=”1″ maxOccurs=”1″ name=”DebiteringsunderlagsID” type=”s:int” />
<s:element minOccurs=”1″ maxOccurs=”1″ name=”StatusID” type=”s:int” />
<s:element minOccurs=”0″ maxOccurs=”1″ name=”Status” type=”s:string” />
<s:element minOccurs=”0″ maxOccurs=”1″ name=”Meddelande” type=”s:string” />
</s:sequence>
</s:complexType>This is what I can found on when surfing to web of HamtaStatus
POST /duws/du.asmx HTTP/1.1
Host: sesoaw252
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: “http://debiteringsunderlag.se/hamtaStatus“<?xml version=”1.0″ encoding=”utf-8″?>
<soap:Envelope xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema” xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/“>
<soap:Body>
<hamtaStatus xmlns=”http://debiteringsunderlag.se/“>
<DebiteringsunderlagsId>
<int>int</int>
<int>int</int>
</DebiteringsunderlagsId>
<KallaID>int</KallaID>
</hamtaStatus>
</soap:Body>
</soap:Envelope>I think you are assigning the int array from the helper class to the wrong thing. You really need to examine the structure of the web service request message and pay close attention to the field types. If you type a dot on the end of “Msg_Request.DebiteringsunderlagsId”, do you see any additional field names?
Here is a another picture of the error message http://www40.brinkster.com/aspvbnerd/IntToIntArray.jpg
Hope you can help me
What is the full error message in the expression editor? I can tell it’s a type mismatch, but the end of the message got cut off. We know the helper class returns an int array, so I suspect that “Msg_Request.DebiteringsunderlagsId” is not of type int[].
What happen to the picture I dont know
This is the link to the first picture http://www40.brinkster.com/aspvbnerd/IntToArray.jpgAnd this is the second link
http://www40.brinkster.com/aspvbnerd/webservice.jpgOk, I have created class library and paste your code so it looks lite this.
using System;
using System.Collections.Generic;
using System.Text;namespace Ncc.BizTalk.Core.WebService
{
[Serializable]
public static class Helper
{
public static int[] IntToIntArray(int number)
{
return new int[] { number };
}
}
}I am calling the helper class in the message assignment like this an it complains. This is how i look.

And this is my windows applicationcode

Russell, why does this not work?
Russell, I am very thankful for the help that you are helping me withHi Greg,
What you say is about the web service wrapping the biztalk class and having to install the dlls and make registry entries is completely at odds with the process I have tried out here, where the IIS server used is a dedicated IIS server that has never had Biztalk installed on it.
The web service was created on my PC using the wizard (publish schemas as web services), which created the web service in inetpub.
I copied the created directory to the IIS server and added it to the default web site – this web service can now be browsed using IE.
Using Visual Studio I created a receive port and receive location on the BizTalk server, with the location using SOAP and the address settings configured to point at the IIS server and the appropriate virtual directory and asmx page.
This receive location takes the message into the message box, from which point an existing process takes over to send an email.
By using a test application, I can call the web service on the IIS server, the BizTalk receive location receives the message and the email gets sent.
There was no work needed on the IIS server beyond the copy of the directory and adding it to the default web site – how does this tie up with your thoughts on the subject?
Are you thinking of an exposed orchestration (perhaps this behaves differently?) or is there another explanation?
Cheers
Stu.
The web service published by Biztalk is a wrapper around the Microsoft.BizTalk.WebServices.ServerProxy.ServerProxy class. This object takes the received SOAP message, runs the pipeline and publishes the resulting Biztalk message into the MessageBox database. In order to move the published web service to another server you will need to install a subset of the Biztalk dlls, and add various Biztalk registry entries to config the location of the both the BiztalkMgmtDb and BiztalkMsgboxDb. The most reliable way to do this is to install Biztalk on that server – hence the license fee. Even if you manage to parse out the required dlls and config settings, I am not sure what the Microsoft view of this would be in regard to licensing. Not to mention being an unsupported configuration
You will also need to open SQL ports thru your fire wall to enable the IIS process access to these Biztalk databases. I suspect your security guys would not like this.
Alternatives:
1. Write you own web service as an intermediary
2. Use a reverse proxy e.g. ISA, Cisco Xml gateway in the DMZI’m not sure what extra license cost you mean – I was talking about one BizTalk box and one server with IIS on it (both of which exist).
Currently we have our Web Services running on IIS on the BizTalk server, and the receive locations point at the local web services.
The scenario I was curious about is one where you use a seperate IIS server to host the Web Services, and the receive locations point at these “remote” web services.
The IIS does not need access to the BizTalk SQL database, this is handled by the usual BizTalk box.
The reasons for looking at this idea are that we have received some advice from our internal security team that they would prefer a service in the DMZ not communicate directly with the BizTalk server (as they perceive this as a risk). Their suggestion was to intruduce an app server internally to act as an imtermediary between the DMZ initiated contact and the BizTalk web services.
By looking at hosting the web services on the IIS server, it may give them the separation they want without developing or deploying anything extra.
Does that make sense?
Cheers
Stu.
-
AuthorPosts