community-content

Forum Replies Created

Viewing 15 posts - 4,516 through 4,530 (of 9,648 total)
  • Author
    Posts
  • in reply to: SQL Adapter Wizard disappears while generating schema #19750

     This is just a wild guess, but do you have SqlXml installed?  This should be installed as a prerequisite when you install Biztalk.  If this is a production machine, I would seriously consider reinstalling or repairing BizTalk.  If it’s just a developer box, maybe try downloading and running the SqlXml SP3 install and running it:  http://www.microsoft.com/downloads/details.aspx?familyid=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en.

    Yes, the Biztalk, Test Map function will perform the DB Lookup.

    You need to examine the resulting XSLT from the Validate Map function, you will be able to see how the DB Lookup is called, basically call embedded C# scripts. You should be able to replicate this in the template.

    The connection string will look something like  this:
    Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=YourDb;Data Source=YourSQLInstance 

    Remember the host instance service account must have access to the database.

    I tend to use XSLT for all maps that are more complicated than straight field to field mapping. Create an XSLT file and then specify this file in the map Custom XSL Path. You can then debug this XSLT using the standard VS2005 XSL debugger (with the XSL file open, check out the XML menu item).

    The Biztalk Mapper compiler generates some less than desirable code. My all time favorite is the Logical Existence functoid which does this:

    <xsl:if test=”userCSharp:LogicalExistence(boolean(ns0:element))”/>

    public bool LogicalExistence(bool val)
    {
        return val;
    }

    This can be replaced by the following XSLT:

    <xsl:if test=”ns0:element”/>

     

     

    in reply to: Messaging Service Instance Active since many days #19748

     

    I see this a lot when I expose schemas or orchestrations as web services (SOAP or WCF adapters) and an error occurs somewhere within messaging or an orchestration.  I don’t think these threads are really open for days on end, but rather their statuses in the Message Box just gets left as Active when the error occurs.  They won’t go away when I try to terminate them, or even when I run the CleanupMsgBox stored procedure.  Occasionally they all mysteriously get cleared out.  Strange…

     Hi Greg,

    Thanks for giving the hint about Message Tracking. Disabling it for this pipeline resolved the error being created.

    Ronald Brink

     

     I think the CEventingReadStream is used in Message Tracking.

    Can you expalin a bit about your Disassembly component, particualrly in regard to how it handles the streams

     Just be sure to have both your pipeline component and the debug file copied to the BizTalk server pipelines folder.

    R. Brink

     

    in reply to: I need an exception decoder ring #19742

     

    This is strange, I have a number of solicit/response ports (i.e. receive then send), they all have an outbound faults (connect to a send shape).

    Can you supply more details about the port configuration, particularly the direct binding? 

    To access message context properties within an orchestration the syntax is:

    myVariable = MSMQMessage(MSMQ.Label);

    myVariable is an orchestration variable of type System.String and MSMQMessage is the input message received from the MSMQ queue.

     

    in reply to: Detecting duplicate nodes in BizTalk #19738

     Here is a sample XSL that can be used in a map:

    It will detect duplicate <item> records. If there are duplicate items it will output an <Errors> document listing all the nodes in error, otherwise it will output the original input file.

    This map can be used in the receive pipeline or an orchestration. If you are using in a pipeline, then you will need some process to subscribe to the Errors document and take appropriate action. If used in an orchestration then you can use a decide shape to test the output and take action on error. 

    <

    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:key name=“duplicateKey“ match=“Item“ use=“.“/>
    <
    xsl:template match=“/“>
    <
    xsl:apply-templates select=“/Items“ />
    </
    xsl:template>
    <
    xsl:template match=“/Items“>
    <
    xsl:variable name=“Errors“>
    <
    xsl:for-each select=“Item“>
    <
    xsl:variable name=“group“ select=“key(‘duplicateKey’,.)“/>
    <
    xsl:if test=“generate-id($group[1]) = generate-id()“>
    <
    xsl:if test=“count($group) &gt; 1“>
    <
    xsl:element name=“error“>
    <
    xsl:value-of select=“$group[1]“/>
    </
    xsl:element>
    </
    xsl:if>
    </
    xsl:if>
    </
    xsl:for-each>
    </
    xsl:variable>
    <
    xsl:choose>
    <
    xsl:when test=“count(msxsl:node-set($Errors)/error) &gt; 0“>
    <
    xsl:element name=“Errors“>
    <
    xsl:copy-of select=“$Errors“/>
    </
    xsl:element>
    </
    xsl:when>
    <
    xsl:otherwise>
    <
    xsl:copy-of select=“.“/>
    </
    xsl:otherwise>
    </
    xsl:choose>
    </
    xsl:template>
    </
    xsl:stylesheet>

    in reply to: Invoking BAPI using Biztalk Server 2006 BTS2006 #19737

     Hi Thomas…

    I had checked on SAP the RFC is not BAPI its ABAP…

    SAP is generating voucher number in SAP which i can cross check..and also when i send wrong data the ZMESSAGE field gets field with message which means SAP is responding to input xml…but not returning back PARK_DOC

    here is the request xml which i am sending to SAP …

    <ns0:Z_BC_FI_PARK_DOCUMENT_Request
    xmlns:ns0=”http://schemas.microsoft.com/BizTalk/2003“>
      <ZFILENAME> </ZFILENAME>
       <I_BKPF>
        
         <BUKRS>EGO</BUKRS>
         <BLART>SK</BLART>
         <BUDAT>2008-04-05</BUDAT>
         <XBLNR>E02090</XBLNR>
         <BKTXT>CL-070508-72M8VC:8903</BKTXT>
        
       </I_BKPF>
       <I_BSEG>
        
         <BUZEI>1</BUZEI>
         <BSCHL>40</BSCHL>
         <UMSKZ></UMSKZ>
         <SHKZG>S</SHKZG>
         <DMBTR>7603</DMBTR>
         <SGTXT>Car insurance paid vide cheq no 201942 dtd 9/4/08.</SGTXT>
         <ZUONR></ZUONR>
         <KOSTL>13200</KOSTL>
         <ZSAKNR>624101</ZSAKNR>
       </I_BSEG>
       <I_BSEG> 
         <BUZEI>2</BUZEI>
         <BSCHL>40</BSCHL>
         <UMSKZ></UMSKZ>
         <SHKZG>S</SHKZG>
         <DMBTR>1350</DMBTR>
         <SGTXT>petrol exps…………………….</SGTXT>
         <ZUONR></ZUONR>
         <KOSTL>13200</KOSTL>
         <ZSAKNR>600200</ZSAKNR>
       </I_BSEG>
       <I_BSEG>
         <BUZEI>3</BUZEI>
         <BSCHL>50</BSCHL>
         <UMSKZ></UMSKZ>
         <SHKZG>H</SHKZG>
         <DMBTR>8903</DMBTR>
         <SGTXT>Expense : 8903……………………</SGTXT>
         <ZUONR></ZUONR>
         <KOSTL>13200</KOSTL>
         <ZSAKNR>350012</ZSAKNR>
        
       </I_BSEG>

    <I_PARK_DOC>

      <PARK_DOC> </PARK_DOC>

    </I_PARK_DOC>
                      

          <ZMESSAGE>
          <ZMESSAGE></ZMESSAGE>
            </ZMESSAGE>

    </ns0:Z_BC_FI_PARK_DOCUMENT_Request>
     
     

     

    and here is the response xml i am getting from SAP..

    <?xml version=”1.0″ encoding=”utf-8″ ?>

    – <ns0:Z_BC_FI_PARK_DOCUMENT_Response xmlns:ns0=”http://schemas.microsoft.com/BizTalk/2003“>
    – <I_BKPF>
      <BUKRS>ELCO</BUKRS>
      <BLART>SK</BLART>
      <BUDAT>20080514</BUDAT>
      <XBLNR>E02090</XBLNR>
      <BKTXT>CL-070508-72M8VC:8903</BKTXT>
      </I_BKPF>
    – <I_BSEG>
      <BUZEI>001</BUZEI>
      <BSCHL>40</BSCHL>
      <UMSKZ />
      <SHKZG>S</SHKZG>
      <DMBTR>7603.00</DMBTR>
      <SGTXT>Car insurance paid vide cheq no 201942 dtd 9/4/08.</SGTXT>
      <ZUONR />
      <KOSTL>13200</KOSTL>
      <ZSAKNR>624101</ZSAKNR>
      </I_BSEG>
    – <I_BSEG>
      <BUZEI>002</BUZEI>
      <BSCHL>40</BSCHL>
      <UMSKZ />
      <SHKZG>S</SHKZG>
      <DMBTR>1350.00</DMBTR>
      <SGTXT>petrol exps…………………….</SGTXT>
      <ZUONR />
      <KOSTL>13200</KOSTL>
      <ZSAKNR>600200</ZSAKNR>
      </I_BSEG>
    – <I_BSEG>
      <BUZEI>003</BUZEI>
      <BSCHL>50</BSCHL>
      <UMSKZ />
      <SHKZG>H</SHKZG>
      <DMBTR>8903.00</DMBTR>
      <SGTXT>Expense : 8903……………………</SGTXT>
      <ZUONR />
      <KOSTL>13200</KOSTL>
      <ZSAKNR>350012</ZSAKNR>
      </I_BSEG>
    – <I_PARK_DOC>
      <PARK_DOC />
      </I_PARK_DOC>
      </ns0:Z_BC_FI_PARK_DOCUMENT_Response>
    in reply to: I need an exception decoder ring #19735

     In my case I have what we call a “mapping” orchestration.  We have a web page calling a WCF Published schema.  I can’t put all the conflicting maps on the Receive Port, so I have to do the mapping in the orchestration to our common message format (a requirement of our ESB architecture). 

    So my orchestration then calls a WCF service that we wrote.  It has the scope with a catch/exception, and I use a common Fault schema to grab the error.  So after your post, I just added a “Send” shape in the Exception handler, associated it with the same fault message.

    I then added a fault message to the WCF receive port (direct binding), and associated it with the same schema.

    So now, my problem is that the WCF fault message has an outgoing shape on the port, thus it want to connect to a “Receive”, not a “Send”.  The logical port is of course configured “I’ll be receive a request and sending a response.”  Could this be a bug?  Seems like the fault message should be able to connect to a send on this type of port.

    Thanks again,
    Neal

     

    in reply to: Detecting duplicate nodes in BizTalk #19734

     Greg,

    Thanks for your reply. I want to through an error if there are duplicates in it.

    Thanks

    Damodar

     Turns out that this was caused by the “Is Single Action” paramater in the 3A4 process settings was set to Yes on that server.  Changed it, and it started to work as expected for the 3A4.

    in reply to: Odd problem with web service communication #19731

    Hello ruselw,

    This sounds like something that might lead to a solution. Right now I’m busy, but I will try it out on monday.

    Thank you for the quick reply !

     

    Regards, Michael

    Hey Greg,

    Questions:

     

    1. When I Test a map from VS will it perform the DB Lookup?

    2. How can I do a DB call from within a template?

    3. What format should the Connection String parameter bein for the DB Lookup Functoid?

    4. How do you debug XSLT? I’ve done it as a seperate project, but I found this very tedious and time consuming. Is there a way to directly debug XSLT from within my BizTalk Project?

Viewing 15 posts - 4,516 through 4,530 (of 9,648 total)