Forum Replies Created
-
AuthorPosts
-
Please note that my original post was back in 2006 – someone else recently asked if there was a solution. That was two projects ago for me.
I believe we ended up sending a dummy message. We temporarily used a send to a flat file directory that we just purged regularly. We also discovered that someone provided a free downloadable adapter, I believe one was called a NULL adapter and maybe one called a NOPE? adapter that just “ate” the messages.
It’s still ashame there is no “InitCorrelation” command.
Neal
How selective? Somethings can be installed independently of others, such as SSO and Rules Engine, WSS Adapter Server side piece. BUt the main guts of BizTalk e.g. – messaging engine, orchestration engine cannot be installed selectively.
Neal,
Sorry for misspelling your name in my earlier post.
-Ben
Neil,
>> The it failed with a compilation error “a correlation may be initialized only once”
Try using one send shape to initialize the correlation and another to send all subsequent messages. Since you have already initialized a correlation set on the first one, if you are sending out other messages on the second send, that use the same correlation token, I belive your receive will pick these up as well.
>> Also, I want the programming logic to determine the number of instances (16 or more or less) so I was unable to use parallel shape.
Could you not two smaller loops inside of a bigger loop? One small loop would be to publish (n) number of messages at a time, the other would be to wait to receive all of the responses (scatter/gatherer as you spoke of earlier). THese two loops would be contained inside of a bigger loop that knows when all of the mapping is complete. Not sure if this will allow you to complete your maps in the time frame you have available, but it should be faster than 25 hours.
Hope this helps somewhat
-Ben
Hi Greg, that’s genius solution, with your suggestion, I was able to do the same thing by modifying your example slightly:
<xsl:stylesheet xmlns:ns0=”http://BizTalk_Server_Project1.Employees” xmlns:xsl=”http://www.w3.org/1999/XSL/Transform” xmlns:msxsl=”urn:schemas-microsoft-com:xslt” xmlns:var=”http://schemas.microsoft.com/BizTalk/2003/var” exclude-result-prefixes=”msxsl var” version=”1.0″>
<xsl:output omit-xml-declaration=”yes” method=”xml” version=”1.0″ />
<xsl:key name=”duplicateKey” match=”Employee/UserID” use=”.” />
<xsl:template match=”/”>
<xsl:apply-templates select=”/ns0:Employees” />
</xsl:template>
<xsl:template match=”/ns0:Employees”>
<xsl:variable name=”Employees”>
<xsl:for-each select=”Employee/UserID”>
<xsl:variable name=”group” select=”key(‘duplicateKey’,.)” />
<xsl:if test=”generate-id($group[1]) = generate-id()”>
<xsl:if test=”count($group) < 2 or count($group) > 1″>
<xsl:element name=”Employee”>
<xsl:element name=”UserID”>
<xsl:value-of select=”$group[1]” />
</xsl:element>
<xsl:element name=”FirstName”>
<xsl:value-of select=”/ns0:Employees/Employee[UserID=$group[1]]/FirstName” />
</xsl:element>
<xsl:element name=”LastName”>
<xsl:value-of select=”/ns0:Employees/Employee[UserID=$group[1]]/LastName” />
</xsl:element>
<xsl:element name=”RecordID”>
<xsl:value-of select=”/ns0:Employees/Employee[UserID=$group[1]]/RecordID” />
</xsl:element>
<xsl:element name=”Address”>
<xsl:value-of select=”/ns0:Employees/Employee[UserID=$group[1]]/Address” />
</xsl:element>
</xsl:element>
</xsl:if>
</xsl:if>
</xsl:for-each>
</xsl:variable>
<xsl:choose>
<xsl:when test=”count(msxsl:node-set($Employees)/Employee/UserID) > 0″>
<xsl:element name=”Employees” namespace=”http://BizTalk_Server_Project1.Employees”>
<xsl:copy-of select=”$Employees” />
</xsl:element>
</xsl:when>
<xsl:otherwise>
<xsl:copy-of select=”.” />
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet>Stephen, Do you have any suggestion for the above issue?
July 10, 2009 at 5:39 PM in reply to: I am trying to copy a file to 2 directories based on the filename #22834By creating the sendpipeline, I can create a txt file, but every record in the Input file is converted into an output file. I just want to copy the incoming file and send it through the Send port. How do I set my schema file for this?
July 10, 2009 at 4:10 PM in reply to: I am trying to copy a file to 2 directories based on the filename #22833Do I need to have a SendPipeline with a flatfile assembles?
July 10, 2009 at 7:52 AM in reply to: Is BizTalkServerIsolatedHost mandatory for published WCF HTTP? #22830Richard: An Isolated host is a virtual entity, it doesn’t exist per se. In this case, its role will usually be filled by IIS, where the WCF receive adapter is being hosted.
alternative you can use SSIS
Hi Greg
After a lot of faffing around I have managed to get the variables filled.
Basically I redid the schema for the incoming message and then changed the messages in the way described with the XML documents
Richard
hi Greg
Sorry for the slow response but I had just got around to lookiing at your msg when it came and we had a major power outage that took out our building [:'(]
RIght the iTex ValidationRequestMessage is based on on a web service that provides authentication for the request from our application, you can look at the service on https://sms.kirklees.gov.uk/sms/sms_biztalk.asmx
In the solution I have the XSD file from incorporating the service into the solution and this looks like this
<?xml version=”1.0″ encoding=”utf-16″ ?>– <xs:schema xmlns:tns=”kmc.sms.biztalk“ xmlns:b=”http://schemas.microsoft.com/BizTalk/2003“ elementFormDefault=”qualified“ targetNamespace=”kmc.sms.biztalk“ xmlns:xs=”http://www.w3.org/2001/XMLSchema“><property distinguished=”true“ xpath=”/*[local-name()=’ApplicationUser’ and namespace-uri()=’kmc.sms.biztalk’]/*[local-name()=’Authorised’ and namespace-uri()=’kmc.sms.biztalk’]“ /><property distinguished=”true“ xpath=”/*[local-name()=’ApplicationUser’ and namespace-uri()=’kmc.sms.biztalk’]/*[local-name()=’Username’ and namespace-uri()=’kmc.sms.biztalk’]“ /><property distinguished=”true“ xpath=”/*[local-name()=’ApplicationUser’ and namespace-uri()=’kmc.sms.biztalk’]/*[local-name()=’Password’ and namespace-uri()=’kmc.sms.biztalk’]“ /><property distinguished=”true“ xpath=”/*[local-name()=’ApplicationUser’ and namespace-uri()=’kmc.sms.biztalk’]/*[local-name()=’Exception’ and namespace-uri()=’kmc.sms.biztalk’]“ /><property distinguished=”true“ xpath=”/*[local-name()=’ApplicationUser’ and namespace-uri()=’kmc.sms.biztalk’]/*[local-name()=’MsgId’ and namespace-uri()=’kmc.sms.biztalk’]“ /></properties></xs:appinfo></xs:annotation></xs:element><xs:element minOccurs=”1“ maxOccurs=”1“ name=”Authorised“ type=”xs:boolean“ /><xs:element minOccurs=”0“ maxOccurs=”1“ name=”Username“ type=”xs:string“ /><xs:element minOccurs=”0“ maxOccurs=”1“ name=”Password“ type=”xs:string“ /><xs:element minOccurs=”0“ maxOccurs=”1“ name=”Exception“ type=”xs:string“ /><xs:element minOccurs=”0“ maxOccurs=”1“ name=”MsgId“ type=”xs:string“ /></xs:sequence></xs:complexType></xs:schema>All the distinguished fields are promoted in this
The code that builds the message looks like this
iTexValidationRequestMessage.Originator = MsgFromName;
iTexValidationRequestMessage.IPAddress = Server_ip;
iTexValidationRequestMessage.Username = “£$%^&*(“;
iTexValidationRequestMessage.Password = “!”£*(^%*(()”;
where MsgFromName and ServerIP address are variables that I am trying to set from the original incoming message based on Xpath statements to access the information in the incoming file
Regards
Richard
wsdl.exe (used with the older ASMX web services) generates proxy with the “Specified” convention.
ASMX web services stack was part of the .Net 1.0 and 1.1 framework. There were no way to represent null values for value types. Hence, the “Specified” convention. WCF does not use this convention because .Net 2.0 supports nullable types.
if you guys are generating the proxy class file in the command prompt, your co-worker may have been wsdl.exe (ASMX web service) to generate the proxy while you’re using svcutil.exe (WCF web service).
if Visual Studio is generating the proxy class file, he could be using Visual Studio 2005, without the WCF extension and/or .Net 3.0 installed.
Make sure the WSDL complies to the Data Contract Schema Reference. http://msdn.microsoft.com/en-us/library/ms733112.aspx
Check the published web service code and make sure, the service contract is using T? or Nullable<T>.
HTH,
An Phu
July 8, 2009 at 3:56 PM in reply to: Limiting the number of SQL Connections for SQL send ports #22820No – it’s still an issue we are looking to resolve…
July 8, 2009 at 2:27 PM in reply to: Limiting the number of SQL Connections for SQL send ports #22819Did you get this resolved? We have a similar issue where we are opening too many connections on the database we are querying using the SQL Send Adapter on BizTalk 2006.
Thanks,
Liz
-
AuthorPosts