community-content

Forum Replies Created

Viewing 15 posts - 3,691 through 3,705 (of 9,648 total)
  • Author
    Posts
  • in reply to: DB Table of Receive Location Properties #20902

    The ESB Guidance might be helpful too (http://www.codeplex.com/esb).  It includes a BizTalk Operations Service that let’s you access BizTalk management data such as receive location info.

    in reply to: DB Table of Receive Location Properties #20901

     Hi,

    You can write a small program to get Receive Location properties through WMI MSBTS_ReceiveLocation or Microsoft.BizTalk.ExplorerOM

     

     

    Example:

    Using WMI MSBTS_ReceiveLocation :

    ReceiveLocationQuery= “SELECT * FROM MSBTS_ReceiveLocation”

     //Create the WMI search object.

     

     

     

     

    Using Microsoft.BizTalk.ExplorerOM

    Create the root object and set the connection string
                    BtsCatalogExplorer catalog = new BtsCatalogExplorer();
                    catalog.ConnectionString = ConfigurationManager.ConnectionStrings
                        [Constants.BIZTALK_MGTDATABASE_CONNECTION].ConnectionString;
                    string receiveLocationName = string.Empty;
                    foreach (ReceiveLocation receiveLoc in
                                    catalog.ReceivePorts[inboundReceivePort].ReceiveLocations)
                    {
                        if (inboundAddress == receiveLoc.Address)

                        {
                            receiveLocationName = receiveLoc.Name;

                            break;
                        }
                    }

     

     

    //Create the WMI search object.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    ManagementObjectSearcher Searcher = new ManagementObjectSearcher

    ();

     

     

    // create the scope node so we can set the WMI root node correctly.

     

     

    ManagementScope scope = new ManagementScope(Constants

    .MGT_SCOPE);

    Searcher.Scope = scope;

     

     

    // Build a Query to enumerate the MSBTS_ReceiveLocation instances if an argument

     

     

    // is supplied use it to select only the matching RL.

     

     

    SelectQuery query = new SelectQuery

    ();

    query.QueryString = ReceiveLocationQuery;

     

     

    // Set the query for the searcher.

    Searcher.Query = query;

     

     

    // Execute the query and determine if any results were obtained.

     

     

    ManagementObjectCollection

    queryCol = Searcher.Get();

     

     

    //Get the Recive Location Name from InboundTransportURL property

     

     

    foreach (ManagementBaseObject envVar in

    queryCol)

    {

     

     

    PropertyDataCollection

    envVarProperties = envVar.Properties;

     

     

     

    foreach (PropertyData envVarProperty in

    envVarProperties)

    {

     

     

    if ((envVarProperty.Name.Equals(Constants

    .INBOUND_TRANSPORT_URL)) &&

    (inboundAddress.Equals(envVarProperty.Value)))

    {

     

     

    //Set the reciveLocationName from the InboundTransportURL property

    receiveLocationName = envVar[

     

    “Name”

    ].ToString();

     

     

    break

    ;

     

    in reply to: AS2 Orchestration #20899

     

    I am also working for the same solution. Can you please share the solution (sample code with send port/ recive port and custom pipeline.)

    in reply to: AS2 Orchestration #20898

    I am also working for the same solution. Can you please share the solution (sample code with send port/ recive port and custom pipeline.)

    in reply to: Need help with ‘tricky’ map output. #20896

    Thanks for tip on debugging this, I ended up taking this and built the custom xslt to do what I needed…this is my first stab at it so it may not be the prettiest thing out there, but it now does exactly what I needed!

    in reply to: Xpath in Biztalk #20894

    I’d second Russell’s comments re. XPath, however if you are new to BizTalk, it may be better to go down the Distinguished Field route as that is certainly easier than hand-cranking XPath in an Expression shape.

    also bear in mind that if you write custom XPath and update your schemas so that XPath is no longer valid, the compiler won’t pick it up and you will only notice the problem once you get to deployment/test.

    A couple of links to get you started with XPath inside of Expression Shapes:

    Rgds, Nick.

    Charles Young has a good overview of Biztalk 2009 over at http://blog.solidsoft.com/blogs/charles_young_mvp_biztalk/default.aspx

    Nick.

    in reply to: Xpath in Biztalk #20892

    Inside an orchestration, XPath is pretty much the only way you can get to a field in an XmlDocument.  Even if you use distinguished fields, BizTalk is using XPath on the back end.  XPath should be fine.

    in reply to: Biztalk Version numbers #20891

    I have BizTalk 2006 R2 installed, and it is version 3.6.1404. I suspect yours is R1. Does your install have WCF adapters?

    BizTalk R3 (or 2009) will not be a big change from R2.  The R3 release is mostly just to add compatibility for SQL Server 2008, Windows Server 2008, & Visual Studio 2008.  If you understand R2, you will understand R3.  Also, any code you write for R2 should be easily portable to R3.  I would recommend to go with R3 whenever it is released because the lack of VS 2008 compatibility in R2 is extremely annoying!

    in reply to: BizTalk 2006 R2 Failure on ENTSSO Configuration #20889

    Is SSO configured the same on the BizTalk Servers and the SQL Servers?  The configuration should be identical on both.  Is MSDTC configured as a clustered resource on the SQL cluster?  It should be.

    in reply to: Need help with ‘tricky’ map output. #20888

    Strange.  The best way to debug that would be to debug the XSLT.  Here’s how: 

    1. Right click the map in solution explorer and click validate map.

    2. That will generate the output XSLT to a file and it will display a link to the file in the output window.

    3.  Open the file in the XML editor (Copy & paste the file path from the ouput window into “Open -> File”).

    4.  When the file opens, you should see a new “XML” menu option on the top toolbar.

    5.  You should see some for-each loops in the XSLT that control the looping.  My guess is that these are a bit off.

    6.  Add a breakpoint at the top of the XSLT.

    6.  Click XML -> Debug XSLT.  It will ask you to select an input file, and after that you can step through just like you were in C#.

    By the way, you might try removing the looping functoid.  Without the looping functoid, the mapper will take a guess at how the looping should work.  I have found that in many cases it is right.

    in reply to: Need help with ‘tricky’ map output. #20883

    [quote user="ruselw"]What is the output you are getting?[/quote]

    Thank you for the response…In one scenario, just testing one field, the loop is out of control but I get my attrib name and value populated:

    <jdeRequest pwd=”JDEINTEG” role=”*ALL” type=”callmethod” user=”JDEINTEG” environment=”XX811″ sessionidle=”3600″>
     <callMethod app=”XmlInterop” name=”POIntegration”>
      <params>
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”szCommunity_HBMCUS”>3503900000</param>
       <param name=”” />
       <param name=”” />

    Out of curiousity, I add in another field from the source, and I receive this:

    <jdeRequest pwd=”JDEINTEG” role=”*ALL” type=”callmethod” user=”JDEINTEG” environment=”XX811″ sessionidle=”3600″>
     <callMethod app=”XmlInterop” name=”POIntegration”>
      <params>
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=”” />
       <param name=””>3503900000</param>
       <param name=”” />
       <param name=”” />
       <param name=”” />
     …
       <param name=”” />
       <param name=”” />
       <param name=”szLotNumber_HBLOT”>3050</param>
       <param name=”” />
     …

    So in one path, I get my “szCommunity_HBMCUS” name and value.
    Another path, I miss the name, hit the value, and my second field “szLotNumber_HBLOT” name and values are correct.

    Both scenarios however, give me all of these blank nodes, I am using the Looping, Equal, Value Mapping and String functoids.

    I’m sure I’m missing the obvious..

    Thanks again!

    in reply to: Need help with ‘tricky’ map output. #20881

    What is the output you are getting?

    in reply to: Biztalk Server Crash Scenarios #20880

    I think this is what you are looking for:  http://msdn.microsoft.com/en-us/library/aa562140.aspx.  BizTalk comes with SQL Server Agent jobs to back up the BizTalk environment, and other jobs to restore the environment in the event of a failure.  One of the most common causes of crashes and performance problems is when people don’t read the documentation and don’t schedule the database maintenance jobs (they’re not scheduled by default).  It’s good that you’re asking these things in advance so you don’t follow in their footsteps!

Viewing 15 posts - 3,691 through 3,705 (of 9,648 total)