[community-content]

I am not exactly sure how you are doing things, but my guess is that the message is malformed.  Likely namespacing is the problem.

First off if you are using the stored procedure technique, that returns a result set, make sure the xmldata option is commented out.

Then generate an instance for the generated schema and compare that to what you are sending in.

 

[community-content]

Hi,

 Apart from tracking only related activity, you can able to track messageid and BizTalkService(InstanceID) in the relationship table. So ReferenceType denotes "Acitivty" or "BizTalkService"…and ReferenceData the value asscoiated with it.

Apart from this, i am not able to find any more information.

 

Thanks

Senthil.

[community-content]

I’m not sure exactly what you want to listen for.  Best thing is to check the SDK and then the help guide.  The list all the WMI events.  I think is one for RL shutting down.

 

You could also look at using a monitoring tool like MOM – but that can cost a lot of extra money.

[community-content]

hi,

 How will i get the wmi event of port shutting down.

what should i write in the service.

 

thanks and regards

 

Shreyas

[community-content]

I know that MSMQ uses XmlFormatter by default, and it appends, <string> at the start and end of the message. That's why I am using the BodyStream property of the message and not the Body. BodyStream, writes the stream as it is, and there are no problems there, Both the File and queue message data are the same when they reach the pipeline component, I've checked that by writting to Eventlog from there. But for that same Queue message it gives Bad Data when trying to decrypt it.

The difference I spotted as I mentioned in my first post, is when I try to Get Size, of the queue message by using BodyPart.GetSize(out Size, out Implemented), it gives Size=0, and Implemented = false for the queue message and Size=336, and Implemented=true for the file message. As I said both have the same stream, so why there is a change of behaviour there.

Now this is what Biztalk documentation say about the Implemented out paramter of GetSize method:

Pointer to a Boolean used to return the information if the message size can be determined. true if the IBaseMessage object can determine the size; otherwise, false.

Why it is unable to determine it is beyond me, Hope I've explained myself better now, Any ideas?

Regards,

Sajid.

 

 

[community-content]

Hi,

I am currently using a custom pipeline to debatch a XML file. How can i get the records count.

<xml>
<record1>
<field>
</field>
</record1>
<record2>
<field>
</field>
</record2>
</xml>

I read some where, ths can be done by promoting some fields. But not aboe to search the post again. Any guidence is much appreciated.

Thanks in advance.

 

 

 

 

 

 

 

[community-content]

Well Siva as per my understanding you need to use a custom XSLT in your MAP.I tried it in the test environment and here are the results.

Input File:

<Detail>
   <Detail01>
       <POId> 552233 </POId>
       <PartnerId> IBM_Lenovo </PartnerId>
   <Detail02>
       <Msg> PC – Dul Core</Msg>
   </Detail02>
   <Detail02>
       <Msg> 250GB Hardrive, 2G Mem </Msg>
   </Detail02>
   </Detail01>
   <Detail01>
       <POId> 552235 </POId>
       <PartnerId> CISCO </PartnerId>
   <Detail02>
       <Msg> Network Card</Msg>
   </Detail02>
   <Detail02>
       <Msg> Via Purelator Please</Msg>
   </Detail02>
   </Detail01>
 </Detail>

Output File:

  <RootNodeOutput>

– <Detail>

  <POID>552233</POID>

  <MSG>PC – Dul Core 250GB Hardrive, 2G Mem</MSG>

  </Detail>

– <Detail>

  <POID>552235</POID>

  <MSG>Network Card Via Purelator Please</MSG>

  </Detail>

  </RootNodeOutput>

———————————————————————

XSLT Used:

<?xml version="1.0" encoding="UTF-16"?>
<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:apply-templates select="/Detail" />
  </xsl:template>
 
 <xsl:template match="/Detail">   
  <RootNodeOutput>  
  <xsl:for-each select="Detail01">
        <Detail>      
   <xsl:variable name="tempMSG">
    <xsl:for-each select="Detail02">
     <xsl:value-of select="Msg/text()" />
    </xsl:for-each>
   </xsl:variable>
          <POID>         
            <xsl:value-of select="POId/text()" />
          </POID>   
          <MSG>    
    <xsl:value-of select="$tempMSG" />    
    </MSG>
        </Detail>
      </xsl:for-each>
    </RootNodeOutput>
  </xsl:template>
</xsl:stylesheet>

Hope you find it Useful.

[community-content]

Thanks,

I shall go through it.

[community-content]

There's an impact on performance, but check out the idea of a "convoy pattern" by which you use a single orchestration instance to collect up the messages in your batch, combine them all together, and send out a single file.  Check out the whitepaper by the man himself, Stephen Thomas …. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts_2004wp/html/956fd4cb-aacc-43ee-99b6-f6137a5a2914.asp?frame=true.

[community-content]

Also replied on microsoft.public.biztalk.general

You might like to try this pipeline component from Matt Meleski:
http://objectsharp.com/blogs/matt/archive/2006/01/29/3778.aspx

Greg

[community-content]

Thank you NISHIL,

I am getting wrong answear when i use cumulative Concatenat Functoid.

I want to concatenate elment input which is looping under the another main loop.

When I use Cumulative Concatenate Functoid, I am getting same out put for all main loops. I tried to post example but this website didnt allow me to post it.

for example, I have 3 Purchase Order info in the schema. Each PO can have 0 -50 Msg in it. I want to combine msgs for the PO.

Thank you in advance

[community-content]

Hi,
Thank you for your help.
I tried Cumulative Concatenate Functoid. I am getting wrong out put. Look at my schema

|-Detail
  |-Detail01
    |-POId
    |-PatnerId   
  |-Detail02
    |-Msg

Detail can occure o – 100 times. Detail02 can occure 0- 50 times for each Detail01.
Let Say my input schema is:

<Detail>
   <Detail01>
       <POId> 552233 </POId>
       <PartnerId> IBM_Lenovo </PartnerId>
   <Detail02>
       <Msg> PC – Dul Core</Msg>
   </Detail02>
   <Detail02>
       <Msg> 250GB Hardrive, 2G Mem </Msg>
   </Detail02>
   </Detail01>
   <Detail01>
       <POId> 552235 </POId>
       <PartnerId> CISCO </PartnerId>
   <Detail02>
       <Msg> Network Card</Msg>
   </Detail02>
   <Detail02>
       <Msg> Via Purelator Please</Msg>
   </Detail02>
   </Detail01>
 </Detail>

I want to concatenate each MSG for their POIds. If I use Cumulative Concatenate Functoid, I am getting the out put :
" PC – Dul Core 250GB Hardrive, 2G Mem Network Card Via Purelator Please"

I want the out put : "PC – Dul Core 250GB Hardrive" and "2G Mem Network Card Via Purelator Please". So I can store those msg in the table related to their POId.

Any help?

Siva

[community-content]

Hi,

Thank you for your help.

I tried Cumulative Concatenate Functoid. I am getting wrong out put.

Look at my schema

|-Detail
  |-Detail01
    |-POId
    |-PatnerId   
  |-Detail02
    |-Msg

Detail can occure o – 100 times. Detail02 can occure 0- 50 times for each Detail01.

Let Say my input schema is:

<Detail>
   <Detail01>
       <POId> 552233 </POId>
       <PartnerId> IBM_Lenovo </PartnerId>
   <Detail02>
       <Msg> PC – Dul Core</Msg>
   </Detail02>
   <Detail02>
       <Msg> 250GB Hardrive, 2G Mem </Msg>
   </Detail02>
   </Detail01>
   <Detail01>
       <POId> 552235 </POId>
       <PartnerId> CISCO </PartnerId>
   <Detail02>
       <Msg> Network Card</Msg>
   </Detail02>
   <Detail02>
       <Msg> Via Purelator Please</Msg>
   </Detail02>
   </Detail01>
 </Detail>

I want to concatenate each MSG for their POIds. If I use Cumulative Concatenate Functoid, I am getting the out put :
" PC – Dul Core 250GB Hardrive, 2G Mem Network Card Via Purelator Please"

I want the out put : "PC – Dul Core 250GB Hardrive" and "2G Mem Network Card Via Purelator Please". So I can store those msg in the table related to their POId.

Any help?

Siva

[community-content]

Hello Sajid,

Your decryptor need to specify the reading of a message by using a custom formatter. The sending and reading of MSMQ messages are defaulted to XMLMessageFormatter. Try to check the queue messages and see how they differ before and after you send, and before and after you read. Although only a portion of the message body can be seen, you should be able to see the differences.

Good Luck !

 NNdM

[community-content]

Hello Shan,

Here's another way with pure BizTalk – no .NET coding required.

My assumptions:

A FlatFileSchema is defined to process the input flat files. This schema is used to define the receive pipeline flat file diassembler  (Document Schema). And, there is one send shape in your orchestration(s) where you output the XML equivalent of the flat file.

Solution:

1. Another Send shape needs to be added (to produce the same flat file data) which specifies a Send Pipeline. The Send Pipeline should have the same schema (as above) as the assembler (Document Schema). You may need to have the output filenames specifed as %SourceFileName%.

Good Luck !

NNdM 

 

 

[Author]

Posts