community-content

Forum Replies Created

Viewing 15 posts - 8,341 through 8,355 (of 9,652 total)
  • Author
    Posts
  • in reply to: Problem configuring WSSLib adapter #13527

    Hello ,
    i have installed WSSLib adapter to integrate SharePoint portal server with BIztalk 2004. but receive and send ports of my scenario are not working. the orchestration seems to be fine and the URL is also correct. i wonder if there is some problem in the WSS adapter configuration.
    if someone has worked on WSSLib adapter kindky guide me what am i doing wrong. i also have tried the scenario downloaded with WSSLib adapter files.

    Regards,
    Jan.

    in reply to: Email Attachment’s filename #13520

    Merry,

    The FILE.ReceivedFileName property will return the complete path of the received file.

    To extract just the filename you will need code like this:

    [code:1:7cf09cb70c]OriginalPath = ReceivedMessageType(FILE.ReceivedFileName);
    OriginalFN = OriginalPath.Substring(OriginalPath.LastIndexOf(’\\\\’) + 1);
    SMTPUtils.Part.SetFileName(MSGtoSend.Attachment,OriginalFN); [/code:1:7cf09cb70c]

    You do not need a custom pipeline component. The FILE.ReceivedFileName property is set by the File Adapter.

    in reply to: Issue with Empty file in Orch #13523

    Hi,

    We have a scenario where in the process of integration between two systems needs to be initiated cheking for a presence of a file \”taskcomplete.txt\”. This txt file is an [b:2761977626]empty file.[/b:2761977626]

    The orch that implements the integration process, need to poll a location for this txt file. When this file appears in the recieve location, the orch needs to be initiated.

    The txt file being empty is never picked up by the file adapter. As a result the integration process does not occur at all.

    Is there any way to deal with this without modifying this txt file contents, Please suggest…..

    Many Thanks in advance.

    in reply to: functoid & schema #14633

    You could use a scripting functoid with this inline XSLT
    [code:1:1a3db90128]<ns0:A xmlns:ns0=\"yourschematargetnamespace\">
    <xsl:copy-of select=\"B[index]\"/>
    </ns0:A>[/code:1:1a3db90128]

    How are you going to pass the index of B into the transformation

    Have you considered debatching the message in a pipeline or using xpath in the orchestration?
    .

    i deploy it again and it works….

    in reply to: SQL Server To SQL Server Integration Problem #13513

    By change in database mean change in data. e.g. insert or update.

    also if u can help me with some example or with some detailed steps to be followed, i shall be thankful.

    Regards,
    Jan

    in reply to: deleting -1 on mapping #14625

    Forgot about blank nodes.
    i.e. <Record type=\”27\”/>

    [code:1:49afc212aa] <xsl:stylesheet 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:template match=\"/\">
    <xsl:call-template name=\"recursive\"/>
    </xsl:template>
    <xsl:template name=\"recursive\">
    <xsl:for-each select=\"attribute::*\">
    <xsl:variable name=\"var:a1\" select=\"local-name()\"/>
    <xsl:attribute name=\"{$var:a1}\">
    <xsl:value-of select=\".\"/>
    </xsl:attribute>
    </xsl:for-each>
    <xsl:for-each select=\"child::*\">
    <xsl:variable name=\"var:name\" select=\"local-name()\"/>
    <xsl:variable name=\"var:ns\" select=\"namespace-uri()\"/>
    <xsl:choose>
    <xsl:when test=\"count(child::*) > 0\">
    <xsl:element namespace=\"{$var:ns}\" name=\"{$var:name}\">
    <xsl:call-template name=\"recursive\"/>
    </xsl:element>
    </xsl:when>
    <xsl:otherwise>
    <xsl:if test=\"(text() != ‘-1’) or (string-length(text()) = 0)\">
    <xsl:element namespace=\"{$var:ns}\" name=\"{$var:name}\">
    <xsl:for-each select=\"attribute::*\">
    <xsl:variable name=\"var:a1\" select=\"local-name()\"/>
    <xsl:attribute name=\"{$var:a1}\">
    <xsl:value-of select=\".\"/>
    </xsl:attribute>
    </xsl:for-each>
    <xsl:value-of select=\".\"/>
    </xsl:element>
    </xsl:if>
    </xsl:otherwise>
    </xsl:choose>
    </xsl:for-each>
    </xsl:template>
    </xsl:stylesheet>[/code:1:49afc212aa]

    in reply to: cluster aware #13493

    [quote:ab417a68bb=\”mmarovic\”]
    1. What does \”being cluster aware\” actually mean?
    2. Is bts 2006 \”cluster aware\”?[/quote:ab417a68bb]

    Cluster aware mean that the product can be installed on, and take advantage of the reliability features offered by the clustering services built into Windows Server, such as creating an Active/Passive cluster for failover.

    The quote you mentioned talked about BizTalk not being cluster aware in a very specific scenario related to the use of the MSMQ adapter. Clustering (and reliability) in biztalk is usually a more complex matter because it depends a lot on what you are doing in biztalk and what adapters you’re using. Notice that for reliabilitty you should always cluster your BizTalk databases, which can be done because SQL Server.

    After that, some protocols (and hence, some of the adapters biztalk supports) have characteristics that make them more appropriate for other scalability and reliability mechanism than clustering, and so you need to consider very carefully what adapters you’ll be using and what the characteristics of your load will be to design an appropriate biztalk processing infrastructure.

    For example, if you mostly receive messages through HTTP/WebServices, then putting multiple BizTalk boxes and using load balancing (such as NLB) is a far better approach than clustering. Also, with biztalk you can do very cool things like dedicating specific servers in your biztalk group to only receive messages but not process them, while dedicating other boxes to just running orchestrations, and other to sending messages. Or you could even dedicate some boxes to running especific business processes. This is all possible thanks to the very flexible host/instance/binding model used throughout biztalk and the shared messagebox of the group.

    However, for MSMQ, things are somewhat different. The MSMQ protocol itself does not lend itself very well to load balancing, and hence, load balancing is rarely a good choice for improving availability of MSMQ receiving applications (and hence biztalk if you use the MSMQ adapter). The core MSMQ services in the OS, though, are cluster aware, which means that the MSMQ service can run on a cluster and do failover and have the MSMQ persistent queues stored as part of the cluster quorum (shared storage).

    Since BizTalk 2004 did not support clustering very well (if at all), building a really, really reliable MSMQ receiver using BizTalk was not a very supported scenario. In BizTalk 2006, however, you can install biztalk on the cluster nodes, and then cluster the BizTalk host where the MSMQ Receive adapter/handler is configured, and have biztalk do failover alongside the MSMQ service on the cluster. For the people that need this kind of reliabilty, this makes it considerably easier to build more reliably biztalk environments (and it can be done alongside non-clustered biztalk nodes dedicated to other purposes, as well, so it does not brake the overall architecture).

    HTH

    in reply to: one input at a time #14629

    I have a send SQL adapter and i send a message to it so a database could be changed.

    it all works good only it is only for 1 record at the time.
    I’d like this for many records in an xml document at the time, but then he stops…

    does anyone know this answer?

    Thx
    Thomas

    in reply to: deleting -1 on mapping #14626

    Ok, so here is what I’m trying!
    Have a map with 2 identical schemas as Source and Destination schema!

    I want a custom XSLT that deletes nodes that have -1 values from the source, making the destination schema have less nodes than the source.

    Any help!? Is it possible!?

    Thanks in adavance!

    in reply to: getting back the source file #13504

    msgIncomingRequest(FILE.ReceivedFileName);
    Through this youll get the Name of the file dropped.

    Regards
    NISHIL
    http://biztalkblogs.com/nishil/default.aspx

    in reply to: SQL Server To SQL Server Integration Problem #13511

    First let me know \”changes in source Sql table\” means what.
    Did you meant changes in design…if so then biztalk cant help you.
    If you meant changes in data…insertion or deletion or updation of data then you can easily reflect it in the other table using Sql adapter at both ends. See Sql adapter depends upon the Stored procedure you call. So if you stored procedure can sense the changes then you can reflect it or else youll have to handle it inside orchestration that what is to be done….So be clear with the requirements. In any scenario you need the primary key of one column…..and the operation to be performed…Just concentrate how would you get these 2 things.

    Regards
    NISHIL
    http://biztalkblogs.com/nishil/default.aspx

    in reply to: Warning 5743 #14603

    As I understood, I can’t send message to receive port(request-response) without orhcerstration or without assembly reference?

    It’s only happens, when I am using request-response port, using only request port all works correctly.

    in reply to: Need help regarding SQL Adapter #13517

    Hello,
    i badly need some material or samples regarding SQL Adapter. Any body plz help.

    Regards,
    Jan.

    it looks to me duplicate receive port version issue…..

    look at your receive ports on BizTalk explorer, if already there delete it and deploy project again.

    Nar-

Viewing 15 posts - 8,341 through 8,355 (of 9,652 total)