- This topic has 6 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
-
okk…Thanx…but, how to configure BizTal to raise the query thru the Adapter AFTER EVERY 5 mins……you know the application once deployed shld check the database every 5 mins.
-
Thanx both …I think I have got a break to it, however, Some problem still remains.
I have made a receive node as the first node and have made a SQL Adapter configured to receive . Then I have transformed the received message to a schema and then send it using usual send port to a folder.
I have made a receive port configured to SQL Transport and have made it receive my Sql Adapter messagena danother send port configured to the particular folder.am I doing it the right way…. well, it looks right to me… 😀
However, no output is comming to the output folder.
Please confirm the same to me.
If I have forgot any aspect please guide me with it.
Thanks
Neha
-
The last post is correct, but I wanted to add some hints:
1) Write a stored proc that retrieves the records with the desired status.
The trick is that you will either need to update that status, or have another column in your table that indicates that Biztalk has already processed that row. Otherwise, every 5 minutes you will get the same rows over and over again.2) Debatching is good technique, but you can also just put a \”Select top 1\” in your select statement. It probably depends on your volume.
I have complete CD of training on SQL Adapter at website below.
Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End-User Videos-
That’s an easy one – when you add a Receive Location and set the \”TransportType\” to SQL, click the \”…\” by the property \”Address (URI)\”
then set the property \”Polling Interval\” to 5 and \”Polling Unit of Measure\” to minutes.Neal
-
Here are some ideas to focus on:
1) Does your SQL Stored Proc work in Query Analyzer? Remember that if you follow my prior instructions, every time you run it, it will update the database, so there will no output when you run it again – unless some other job has inserted new data back into the database.
2) For a quick test, you can just create a flat file send port and subscribe it to the SQL receive port. Then you can test without an orchestration. The receive port should run every x minutes, and the send port should be able to grab the output (in addition to the orchestration).
3) Check the event log (and HAT) for errors but with SQL, often the messages in the System Event Log are more specific and helpful.
Neal Walters
http://Biztalk-Training.com – Learn Biztalk Faster
http://Sharepoint-Training.com – End User Videos-
It is simple.
At the start of orchestration use sql adapter at receive shape to fetch rows in that table. Then use debatching to split it into single xml corresponding to each row in the table. Promote the status field. After splitting it into single xml Messages through Debatching just check for that status field for each splitted messages.If its value is \”Error\” call another Orchestration.
-
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.