Forum Replies Created
-
AuthorPosts
-
June 1, 2008 at 5:14 AM in reply to: The send port configuration corresponding to the message was not found #19826
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.
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:
- 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.
- 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.
- Before sending the request to the database you need to map your data into the SQL schema you generated.
- 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.
May 31, 2008 at 3:11 PM in reply to: Message sending / receiving from Biztalk Server – Basic understanding needs verification #19824Sriram,
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!
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
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.
May 31, 2008 at 6:05 AM in reply to: Biztalk group configuration with sql 2005 on diferent server #19821That 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?
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
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
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
May 30, 2008 at 12:48 PM in reply to: Biztalk group configuration with sql 2005 on diferent server #19816Another 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
May 30, 2008 at 11:55 AM in reply to: Biztalk group configuration with sql 2005 on diferent server #19815Yes 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!
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
May 30, 2008 at 9:49 AM in reply to: Biztalk group configuration with sql 2005 on diferent server #19813Does each version of SQL have an instance name? Are you specifying the instance name in BizTalk?
Neal
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
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
-
AuthorPosts