community-content

Forum Replies Created

Viewing 15 posts - 4,456 through 4,470 (of 9,648 total)
  • Author
    Posts
  • That very well could be an SSO issue.  Are you getting any SSO errors in the event log?  Intermittent SSO issues could cause the inconsistent results you are seeing.   Maybe try reproducing the error on another BizTalk install to see if it is something with your code or if it is related to the server where it is running.

    in reply to: DBLookup functiod #19825

    This case sounds like it would be a good job for the DBLookup functoid.  Anyway, here is how you could use the SQL adapter to do the lookups:

    1. Run Add Adapter Metadata wizard to generate a schema based on your SQL statement or stored proc.  The schema will include 2 root nodes: request and response.  This is a specially formatted schema that the SQL adapter knows how to interpret.
    2. Add a request/response port to your orchestration.  You will use the request side of this port to send the parameters, probably the item id, to the database.  You will receive the results from the response side.
    3. Before sending the request to the database you need to map your data into the SQL schema you generated.
    4. After receiving the response you probably want to map the data from the SQL schema back into your internal schema.

    If the query is based on one item, then you need to run the query from a loop within your orchestration, passing in the item id. 

     Sriram,

    In response to your questions:

    – To implement synchronous communications with BizTalk, you might want to consider using something other than MSMQ because MSMQ does not inherently support synchronous communication.  WCF handles sync communications much more naturally than MSMQ.  In BizTalk, one of the best ways to implement request/response communications is to publish a request/response WCF service.  You can do this with MSMQ, but you would have to write some custom app to front MSMQ, such as a web or WCF service.

    – Yes, you could write a C# Windows service to poll the queue on the BizTalk server.  The benefit to this would be that you get durable communication (the apps can send messages to each other without caring if the other one is up).  Well guess what, when BizTalk sends messages, it doesn’t really need MSMQ for durable communication.  BizTalk itself is a message queue, so you could expose a WCF service from your app for BizTalk to submit messages into.  If your app is down, then BizTalk can retry submitting the message until your app comes back up.

    Hope this helps!

    in reply to: Dynamically create send location folder #19823

     You are best off checking if the folder exists, via some .Net code,  before you try to write the file.  Otherwise, you will end up with warnings(and eventually a failure) indicating that the folder does not exist.  Now there are ways through Delivery Notification to catch these type of failures then create the folder after it has errored out, but it is just easier to do this work before hand.

    If by chance you are using FTP, check this link: http://kentweare.blogspot.com/2008/04/ftpwebrequest-class-creating-remote.html

    in reply to: Problem with passthrough of an empty file #19822

     Some of the 3rd party adapters(TopXML) will create a warning event in the event viewer for these types of situations.  I have noticed the same behaviour that you are seeing with the microsoft adapters.

    Greg’s idea sounds like something worth investigating.

    That error message makes me suspect the BizTalk installation is corrupt.  Have you tried repairing the installation?  It could also very well be an MSDTC issue.  Have you carefully checked the DTC settings on the BizTalk and SQL server, and made sure they are as specified in the BizTalk docs?

    in reply to: Getting WSE (2 or 3?) installed on BT2006/R2? #19820

     There are some incompatibilities between WSE2 and WCF, however WSE3 and WCF are wire compatible. I beleive this has to do with the state of the WS* protocols when WSE2 was built.

    The SOAPAction property is called WCF.Action on the WCF adapter

    in reply to: Converting Published Orch BT2004/ASMX to BT2006/R2 WCF #19819

     This should be possible, you need to use the BasicHttp binding or a custom binding. The Url will change to a .svc file

    I have successfully called ASMX web services using the WCF adapter nad have an InfoPath 2003 form calling a WCF published web service

    in reply to: Getting WSE (2 or 3?) installed on BT2006/R2? #19818

     Here’s some of my research:

    BizTalk Doc: ms-help://MS.BTS.2006/BTS06CoreDocs/html/3db44fd1-1f17-4d7b-a0f3-9ac0bbf7f2ec.htm

    Say WSE is deprecated in this release and will be removed in a future release (that implies that it’s still there somewhere).

    BizTalk Doc: ms-help://MS.BTS.2006/BTS06CoreDocs/html/18ca8535-3386-4018-8b5b-d32bdb9ebf70.htm

    says WCF supports WS-Security 1.1 and 1.1 – so I’m guess that means I can use the WCF ports and talk to a vendor who is running an old .asmx running WSE 2?

    Also – I should have read these posts firsts – they may answer all my questions:

    http://www.biztalkgurus.com/forums/p/5760/10754.aspx#10754

    http://santoshbenjamin.wordpress.com/2007/10/27/wse-23-biztalk-and-vs-2005-web-app-projects/

    http://www.pluralsight.com/blogs/matt/archive/2006/05/17/24124.aspx

    http://www.modhul.com/2007/07/28/wse-adapter-setup/  (includes several downloads and prereqs, i.e install WSE before the WSE adapter).

    After reading these, I’m more confused than ever.  I guess my frist and foremost question is can I create my orchestration to use WCF adapter, and still talk to the vendor which is using WS-Security (probably WSE 1 or 2?).

    Neal

     

     

    Another idea – nothing for sure.  Have you tried running DTCPing and DTCTester (free downloads from Microsoft) first?  This will assure that the Distributed Transaction Coordinator is set up and working properly.  If it’s not – you can get strange errors during install.  I’ve almost made it a habit to run these two utilities before attempting a BizTalk install/config.

    Neal

     Yes each version of SQL have an especific name, the instance I want to use is the servidor03\sql_nd02 (SQL 2005) and we have another instance on the same server named servidor03\SQL_DESV (SQL 2000), and ofcourse I’m specifying the right name in the configuration.

     

    I have no idea what can be happening!

    in reply to: Looping problem with mapper #19814

    On the plus side choosing XSLT instead of the mapper, I should acknowledge that there are several things that the Biztalk Mapper does not do easily. So from a capability standpoint, you can do certain things far more easily with the straight XSLT, as we see in this thread’s example.  In my solution to preserving the graphical mapping, I would have had to cache keys and use external scripting – esentially using a lot of tricks. Greg’s XSLT solution is a far more elegant in directly solving the problem without tricks to get around limitations.

    The latest issue of BizTalk HotRot has a detailed article on the Smart use of straight XSLT.  There are a number of considerations to factor into the decision, such as performance, large file support, etc.  I highly recommend to anyone interested in this thread to read the article.

    Article by Scott Colestock on P28 of the current issue:  http://cid-b6c859f7a5f75e63.skydrive.live.com/self.aspx/Public/Q2FY08_biztalk.pdf

    Biztalk hotrod main site:  http://biztalkhotrod.com/default.aspx

     

    Does each version of SQL have an instance name?  Are you specifying the instance name in BizTalk?

    Neal

    in reply to: Biztalk – Website – Login #19810

     thanks greg.forsythe,

            I will try the adapter and see if that serves the purpose of logging into a website and getting data.

    I’ll post my results once i have tested it here

     

    -Jerry

    in reply to: Login to a website to get data #19809

     Thanks ruselw.

          We have no control over the website :-(. but we have the direct url and the credentials

    What would the custom adapter be doing to facilitate this logging ? you mean a custom HTTPAdapter ?

    If a Service within network was to be used to push files to Biztalk …. how would this Service get data from the website ? as this website is external and we have no control over it and hence they will not push/ftp the file to us.

    -Jerry

     

Viewing 15 posts - 4,456 through 4,470 (of 9,648 total)