community-content

Forum Replies Created

Viewing 15 posts - 901 through 915 (of 9,648 total)
  • Author
    Posts
  • in reply to: Error in Oracle Adapter #25294

    Hi,

     

       The TNS alias is the same as the ODBC data source name set up on that server. Check the following blog on more information on how to troubleshoot LOB Oracle adapters (look for the entry titled “Using LOB Oracle adapters with BizTalk Server 2006 R2” and dated September 11):

    http://bibhakar.spaces.live.com/blog/

     

       Daniel.

     

    in reply to: Error in Oracle Adapter #25293

    I’ have configured the conecction binding with servicename and servername. Have I to configure the connection bing with the TNS alias? How can I know the TNS alias in that case?

    in reply to: Starts Orchestration like scheduled? #25292

    Hi Daniel.

    Thanks a lot! Yes, you’re right – it is very nice to have/keep all this thnig together in one place.

    best regards

    Wolfgang

    in reply to: Starts Orchestration like scheduled? #25291

    Hi Wolfgang,

     

       Yes, you could use a job in the windows scheduler to place the file in the folder at given times, but you would have to keep track of that separately, and personally, I prefer to keep things running in BizTalk within the boundaries of BizTalk platform as opposed to under the control of the OS.

     

       Daniel.

     

    in reply to: Error in Oracle Adapter #25290

    Hi,

     

       Did you check the receive location (where you are using the Oracle Adapter) for its connection binding? That’s where you would find the TNS alias…

     

       Daniel.

     

    Did you checked in BTS Administrator the Apllication and that all Objects (Schemas, Orchetsrations, Pipelines, Maps etc.) are there?

    Did you configured the Application with the orhestration?

    in reply to: Exception with two-way receive port direct binding #25286

    That worked for me too!

    Thanx man!

     

    I promoted code using Export MSI and then imported. moved the dll to gac.

    I think problem is with the default batching orchestrations??

    in reply to: Starts Orchestration like scheduled? #25284

    Hello Daniel.

    Looks pretty nice so far – thanks for the link, i will check this out.

    Another way could be to use the windows scheduler to put a file into an folder where the receive pipeline is watching for it, is this right?

    Thanks again

    Wolfgang

    in reply to: Starts Orchestration like scheduled? #25283

    Hi Wolfgang,

     

       Have you taken a look at the Scheduled Task Adapter on Codeplex? Here’s a link to that:

    http://biztalkscheduledtask.codeplex.com/

     

       I believe it also works on BizTalk 2009 platform.

     

       Daniel.

     

    in reply to: Data Mapping – fill a field more than once a time #25281

    Hello Greg.

    Thanks for your reply.

    Yes, you’re right. Both Party elements are the same and I want the element as often as I like.

    I have an element called “Party”. This “Party” element has two Attributes, one is called “ID” and one is called “Role”. Now I want to fill these attributes from different source fields in the same map.

    Source field  ————————–> Destination field

    <ID> ————————————> <Party Role=’MR’ ID=’912345′>

    <Number> —————————-> <Party Role=’UD’ ID=’9′>

    At the end I have in the Output-XML several Elements called “Party” with different attribute values.

     

    The destination schema looks like:

    <xs:element minOccurs=0 maxOccurs=unbounded Name=”Party”>

    <xs:attribute name=”ID” type=”xs:string” use=”required”>

    <xs:attribute name=”Role” type=”xs:string” use=”required”>

     

    And the Output as an XML File should looks like this:

    …

    <Party Role=’MR’ ID=’912345′>

    <Party Role=’UD’ ID=’9′>

    <Party Role=’…’ ID=’…’>

    <Party Role=’…’ ID=’…’>

    …

    My question is, how can I handle it in the map? Should I just “draw a line” from the source element to the destination element and everything will be handled by the schema? Or do I have to use special functoids? I don’t no at the moment.

    Thank you very much in advance.

    Wolfgang

    //Edit: I forgot to say the source file has only single records!

    in reply to: Promoted Properties with Canonical Schemas #25280

    A BizTalk map only operates on the message data, not the message context.

    However, if you perform the map in the receive port then the only the message data is modified, while the message context remains intact. ( with the exception that properties are promoted from the output message based on it schema and these properties may overwrite existing properties)

    If you perform the map in an orchestration you create a new message, with a blank context, so you must copy these properties yourself e.g.
    In an message assignment shape in the construct message shape after the transform:
    OutputMessage(Mynamespace.MyProperty) = InputMessage(Mynamespace.MyProperty);

    or to copy all properties:
    OutputMessage(*) = InputMessage(*);

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

    Depends on what you mean by “can BizTalk process PDF files”

    BizTalk is capable of moving any file from one location to another. You can use pass-thru pipelines  and generic message types in orchestrations to move any binary data.
    However, if you wish to use data inside a file then you need to be able to parse that file into Xml.

    Can you explain a bit more about your process?

    in reply to: Dynamic Xml generation in Disassembler Pipeline #25278

    With a record containing fixed length fields it is impossible to determine the length of the next field without explicity declaring the new field in a schema.
    The only way to dynamically parse an indeterminant number of fixed length fields based purely on the data is to include the field length in the message.  Unfortunately the FF disassembler does not handle this scenario, but you could write a pre-parser that converts these fixed length fields into a delimited record.
    Alternatively if you use a delimited structure, you can create a record with an unbounded number of fields. The FF disassembler will continue parsing fields until the end of the record.

    in reply to: Data Mapping – fill a field more than once a time #25277

    You can use the value mapping functoid, which takes a boolean and a data input. If the boolean is true then the data input is output, otherwise nothing is output.
    Are both Party element above the same, or do you have two different Party elements

    It would be useful if you could explain the source message and how you determine which role to use.

Viewing 15 posts - 901 through 915 (of 9,648 total)