community-content

Forum Replies Created

Viewing 15 posts - 4,006 through 4,020 (of 9,648 total)
  • Author
    Posts
  • in reply to: SQL Nvarchar(max) #20469

     Did you try with “Results to text” or “Results to File” option from the query menu?

    in reply to: Handling Realtime(270/271) with Biztalk 2006 R2 #20468

     Maybe try runing the consume WCF wizard.

    Neal

    in reply to: processing flat files after a trigger file is created #20465

     Russel, Thanks for your reply.

    I will try it on this way.

    Hermann

    in reply to: processing flat files after a trigger file is created #20464

    I 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.

    in reply to: Deadlocks on MsgBoxDB #20463

    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.

    in reply to: BizTalk R2 WCF-Net.Tcp Adapter Consumption Issues #20462

     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?

    in reply to: (Flexible) correlation, custom code or expression? #20461

    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?

    in reply to: processing flat files after a trigger file is created #20460

     Hello All,

    Maybe my previous question is a stupid question, but I would appreciate if someone gives me a comment about this [:)]

    Thanks
    Hermann

     

     

    in reply to: Deadlocks on MsgBoxDB #20456

    I 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

    in reply to: BizTalk R2 WCF-Net.Tcp Adapter Consumption Issues #20455

    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

    in reply to: hi all #20454

    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.

    in reply to: BizTalk R2 WCF-Net.Tcp Adapter Consumption Issues #20450

     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?

     

    In 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

    pls help.

    apreg – what is your desired output from the map (in Xml)?

Viewing 15 posts - 4,006 through 4,020 (of 9,648 total)