community-content

Forum Replies Created

Viewing 15 posts - 931 through 945 (of 9,648 total)
  • Author
    Posts
  • in reply to: Operation of Biztalk 2000 on Windows 2008 Server #25254

    Hi,

     

       From my knowledge, BizTalk 2000 is NOT supported in Windows 2008. If you are upgrading your server OS to Windows 2008, I would strongly recommend upgrading your BizTalk software to version 2009.

     

    I realize this is quite a bit later, but I have come across this issue quite a few times and just wrote an article on it>

    http://blog.proschconsulting.com/2010/06/biztalk-contained-a-null-value-at-the-end-of-the-construct-block-fix/

    If you ever get this again, I hope this helps.

     

    Hi.

     

    A little bit more information would be great.

    So it looks like a normal copy job for me.

    But you can handle it with BTS. You just have to build a receive port and a receive location. In the receive location you told BTS on what kind of file it should work. Than build a receive pipeline for a flat file disassembler and just an send port to transfer the file to another location. If you will have a data mapping between the received and send data, you have to build a map and put this map into the send port.

    I hope this helps so far.

    best regards

    Wolfgang

    in reply to: Routing Failure #25250

    Hi Sean,

     

       Are you doing any exception handling in your orchestration when sending a request and receiving a response from the SOAP web service? I have a similar BizTalk project in production, that has a Scope shape (with properties Synchronized set to “False” and Transaction Type set to “None”) encapsulating the Logical Send and Receive shapes, and multiple Catch Exception shapes to handle four different Exception Object Types (Time Out, Soap, XLangs, System). To create a Catch Exception shape, highlight the Scope shape, right-click and choose the first option (New Exception Handler). I then use MS Enterprise Library Logging Application to output any errors to a log file, but you could do something different, like sending an email notification…

       If you haven’t done so already, you should look into implementing exception handling in your orchestration to trap any errors returned from calling the web service.

     

       Cheers,

     

        Daniel.

     

    in reply to: Promoted Properties with Canonical Schemas #25249

    Hi,

     

       To accomplish what you want, you should promote the field in your Canonical schema if you know which field will receive a value that will allow you to route the message based on the promoted property, just make sure that the field is unique and not reoccurring; then execute the map in your Receive Port. Please see the following blog for more information (in particular the third post):

     

    http://blog.eliasen.dk/default,month,2007-09.aspx

     

       Daniel.

     

    in reply to: Mapping Questions #25248

    Hi Daniel.

    Thanks again. I checked it aus, but it didn’t worked for me.

    So I found another way to do this. I did it with the 3 functoids as well. But I used the “String Right” functoid in this case and it worked very well.

    At the end it looks like this in one row: <source field> – – – “String Find” – – – “Substraction” – – – “String Right” – – – <destination field>

    Now I get the number or the text I want.

    The parameters I used are:

    String Find: 1. “Source Field” 2. “-“

    Substraction: 1. “Output String Find” 2. “1”

    String Right: 1. “Source Field” 2. “Output Substraction”

    Thanks again for your help and for the tip how to use the String functoids.

    Wolfgang  

    in reply to: Processing pdf and Updating Database… #25247

    Hi Abhishek,

     

       Regarding processing PDF files through BizTalk, see my post in the following BizTalkGurus forum thread:

    http://www.biztalkgurus.com/forums/p/5012/9439.aspx

     

       To update data in a SQL table, I would suggest using WCF SQL Adapter to accomplish that.

     

       Daniel.

     

    in reply to: Mapping Questions #25245

    Hi Daniel.

    Thanks a lot for your great help!

    I will check this out and let you know.

    One more question regarding the combination of the functoids. When the source field will be empty (it comes out of a database and shouldn’t be empty but I don’t know, because this field coud be managed manually) will this be a problem for that combination or will the destination field be filled blank?

    Thanks again for your help.

    best regards 

    Wolfgang

    in reply to: GS1 XML implementation #25242

    Finally have done it.

    I had to modify quite a few schemas to make it work. And now the Invoice.xml instance document is validated against the StandardBusinessDocumentHeader.xsd schema.

    What a pain! The GS1 people weren’t helpful either. What’s the point to produce the standard that is so hard to implement and so much stuff needs to be modified.

    in reply to: MLLP Adapter receive only first HL7 message #25241

    I had this same problem. I changes the “persistent connection” property to FALSE and it all worked fine. The problem is that the vendor is not closing the connection after sending the message.

    Thanks,

    Shaik Dawood

    in reply to: Mapping Questions #25240

    Hi Wolfgang,

     

       To answer your first question, put the value zero (0) in the Min Occurs property of your field in the destination schema, to avoid the warnings.

     

       As of your second question, use a combination of String Find, Size and String Extract functoids to achieve what you want, something like the following diagram:

     

     (String Find) >>>>>>>>                |

               ^                                              |

               ^                                              |

               ^                                              |

    (Source field) >>>>>>>>> (String Extract) >>>>>>>>> (Destination field)

                V                                            |

                V                                            |

                V                                            |

            (Size) >>>>>>>>>>>>           |

                            

        In the String Find functoid, specify the first parameter as the link from your Source field, and the second parameter as the string that you do the search on (which is the dash character).

        In the String Extract functoid, specify the first parameter as the link from your Source field, the second parameter as the link from the String Find functoid, and the third parameter as the link from the Size functoid.

     

        Hope this helps,

     

        Daniel.

     

    OK. Thanks for the help. Appreciate it.

    Hi,

     

       Since you are using BizTalk 2009, is there any reason why you don’t want to use WCF SQL adapter to fetch data from a database? Some other alternatives would be:

     

    1. Wrap your database call in a .NET assembly and call that assembly from a BizTalk orchestration.

    2. Wrap your database call in a Web Service (SOAP or WCF) and call that service from a BizTalk orchestration.

     

    Thank you guys

    I went with the for xml query option and it seems working fine. 

    Thanks,

    Yusuf.

    Thanks

    I don’t want to use WCF SQL adapter.

    Please tell me other solution.

     

Viewing 15 posts - 931 through 945 (of 9,648 total)