Forum Replies Created
-
AuthorPosts
-
Did you try with “Results to text” or “Results to File” option from the query menu?
Maybe try runing the consume WCF wizard.
Neal
August 21, 2008 at 6:10 AM in reply to: processing flat files after a trigger file is created #20465Russel, Thanks for your reply.
I will try it on this way.
Hermann
August 21, 2008 at 5:35 AM in reply to: processing flat files after a trigger file is created #20464I would look at creating a batching orchestration that uses a sequential convoy pattern. The batching orch can receive the files in a loop. The loop should contain a listen shape with two receives: one receive for the data files and one receive for the trigger file. You can differentiate between the files using file masks on the receive location. Receiving the trigger file should break out of the loop and continue processing. It would be nice if you could somehow delay BizTalk from consuming the data files until the trigger file arrives. BizTalk doesn’t work that way though, so you need to use a batching orch. Otherwise, BizTalk will see the data files as unexpected and will throw an exception.
Have you all enabled the Backup BizTalk Server and DTA Purge and Archive jobs in SQL Server Agent? Without these jobs enabled, your message box and tracking databases will grow unchecked and you will have performance issues and deadlocks.
Try this. What is the message type of the response message that you are sending to the client? Create a file send port and add the following filter: BTS.MessageType = “http://<response message namespace>#<root node name>. Now run the process again. Did the file send port pick up the response message to the client? Did it contain any data?
BizTalk only allows you to use “equals” comparisons for correlation. What you can do is write a custom pipeline component to add another context property to one of the messages. For the ObservationTime message, you can calculate the read time (ObservationTime – 3) and add the ReadTime property onto that message. Then just correlate on ReadTime. will that work?
August 21, 2008 at 4:34 AM in reply to: processing flat files after a trigger file is created #20460Hello All,
Maybe my previous question is a stupid question, but I would appreciate if someone gives me a comment about this [:)]
Thanks
HermannI have the same problem can u tell me the solution
The following stored procedure call failed: ” { call adm_SendPort_get_subscription_details( ?)}”. SQL Server returned error string: “Transaction (Process ID 144) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.”.
Its very urgent , actually what i m doing i have a method to create send port and i call this method in an orchestration but when i put 4 or more than 4 input 4 instances are generated and they all try to create send port and dead lock occur.
please help me to solve this problem
I excuse about that Error Message which posted in my previous post.
That Error message came because i was in degug mode quite for a long
while. so it was timeout error thats why that error occurs in run Query mode.
Kindly Ignore my previous Post.Let me explain further. When i execute the process without debugging. The process first entered in Orchestration–> Entered in Expression Box (seen in Event viewer by (Diagnositc Command)) –> Entered in Construct Message (seen in Event viewer by (Diagnositc Command)) but i don’t received my actual send message(Response Message) in my client code but rather i received NULL message. I didn’t found any errors in Event Viewer but only found the Tracing Messages e.g. (“Entered in Expression Box”) and (“Entered in Construct Message”) which displayed succesffuly in Event VIewer.
Then I use debugged method by HAT technique which you told me to do.
After Running a Query I successfully get the Response Message. but i don’t understand why i don’t receive that message in my client.
Is this any thing Wrong in my client code??? or In my Receive Location Setting?? I suspects, i m missing some settings in Receive Location .. may be in In/Out Bound WCF Message Part.
Your help is highly appreciated.
Thanks
Regards
Razi
I do this by using a Transform Shape in an orchestration and selecting the 2 source schemas and allowing BizTalk to generate the map file for you. You end up with an envelop schema that contains both source schemas.
What do you mean when you say you received 2 messages in 1? If you just run the process without debugging, are there any resulting suspended messages?
August 20, 2008 at 4:33 AM in reply to: BizTalk Functoid Mapping Help – How do I handle this senario? #20449In some cases, neither Apple or Orange will not show up in the source. For the cases when the Apple shows up in the source XML and the Orange doesn’t, I want the output XML to display.
<FruitA>1</FruitA>
<FruitB>0</FruitB>
If both are found in the source XML, it would be
<FruitA>1</FruitA>
<FruitB>1</FruitB>
etc
August 20, 2008 at 4:06 AM in reply to: HTTP Error 405 – The HTTP verb used to access this page is not allowed. #20448pls help.
August 20, 2008 at 1:48 AM in reply to: BizTalk Functoid Mapping Help – How do I handle this senario? #20447apreg – what is your desired output from the map (in Xml)?
-
AuthorPosts