Forum Replies Created
-
AuthorPosts
-
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.
May 26, 2008 at 1:42 PM in reply to: Standard Functoids and Inline XLST Template (Scripting Functoid) #19749Yes, 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=YourSQLInstanceRemember 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”/>
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…
May 26, 2008 at 8:20 AM in reply to: Cannot access a disposed object named CEventingReadStream #19746Hi Greg,
Thanks for giving the hint about Message Tracking. Disabling it for this pipeline resolved the error being created.
Ronald Brink
May 26, 2008 at 5:14 AM in reply to: Cannot access a disposed object named CEventingReadStream #19745I 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
May 26, 2008 at 4:19 AM in reply to: Breakpoints aren’t hit when attaching custom pipeline component to Btsntsvc.exe #19743Just be sure to have both your pipeline component and the debug file copied to the BizTalk server pipelines folder.
R. Brink
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?
May 26, 2008 at 4:12 AM in reply to: Need to access MSMQ Context properties within an Orchestation #19741To 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.
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) > 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) > 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>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″ ?>
<BUKRS>ELCO</BUKRS><BLART>SK</BLART><BUDAT>20080514</BUDAT><XBLNR>E02090</XBLNR><BKTXT>CL-070508-72M8VC:8903</BKTXT></I_BKPF><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><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><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><PARK_DOC /></I_PARK_DOC></ns0:Z_BC_FI_PARK_DOCUMENT_Response>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,
NealGreg,
Thanks for your reply. I want to through an error if there are duplicates in it.
Thanks
Damodar
May 23, 2008 at 9:47 AM in reply to: RosettaNet 3.5 PrivateResponder Orch failing for No subscriptions #19733Turns 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.
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
May 23, 2008 at 6:28 AM in reply to: Standard Functoids and Inline XLST Template (Scripting Functoid) #19730Hey 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?
-
AuthorPosts