community-content

Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 9,648 total)
  • Author
    Posts
  • in reply to: Managing BizTalk Servers #24682

    Hi rocky,

     

       Please consult the following MSDN articles and link to see what would work best for your environment and infrastructure:

    http://msdn.microsoft.com/en-us/library/aa475435.aspx

    http://msdn.microsoft.com/en-us/library/aa558765%28BTS.20%29.aspx

    http://stackoverflow.com/questions/1951469/network-load-balancing-biztalk-instances

     

       Hope these resources help,

     

       Daniel.

     

    in reply to: WCF custom adapter exception #24681

    Hi,

     

      See if the following blog can help you resolve your issue:

    http://stackoverflow.com/questions/1724095/how-to-programmatically-turn-off-security-in-wcf

     

       Daniel.

     

    in reply to: Extreme mapping BizTalk Question #24679

    Hi,

     

       Have you considered using Table Looping/Table Extractor functoids to achieve your scenario? Check this following blog for an example, which I believe is close to your requirements:

    http://geekswithblogs.net/evankoch/archive/2007/08/07/114470.aspx

     

       Hope this helps,

     

       Daniel.

     

    in reply to: Trigger BizTalk from SQL-Server #24678

    Hi mster,

     

       Have you considered exposing your BizTalk orchestration as a web service or WCF service in order to consume it from SQL Server?

     

       Daniel.

    in reply to: Trigger BizTalk from SQL-Server #24677

    You can use BizTalk SQL Adapter for this purpose. If you are using BizTalk 2009 then you can use the WCF-SQL Adapter.

    Regards,

    Abhijit

    in reply to: How to do multiple procedure call from one XML file #24676

    Ok, thanks for the answer – I’ll try that.

    I’ve  got one more idea but I don’t know if it’s possible to do. I’ve got one source XML (with schema) and two output xml schemas (generated automaticly by Consume Adapter).

    – I recieve source xml and map some header values to the first output schema – I’ve inserted header row,

    – next I map the same source xml to another output schema to insert some positions. Here I can insert only first position.

    I can construct loop in orchestration, count quantity of positions in source XML but how can I construct new output message and change some values in that ? This message should be the same as the second output schema. When in message Construct shape I use Transform and next I get error : “Inner exception: Illegal attempt to update the value of part ‘part’ in XLANG/s message ‘OraPosMessage’ after the message construction was complete.”

    Is there any way to solve thie problem ?

    regards,

     

    in reply to: Extreme mapping BizTalk Question #24673

    Hi,

    Thanks on your update.

    Will try to explain on better way.

    Namely this is input file (XML)

    </Pages>
    <Page>
      <Item  Value=”ORDER DATE” CtrlID=”4″ SectionID=”1″ />
      <Item  Value=”ORDER NUMBER” CtrlID=”18″ SectionID=”15″ />
      <Item  Value=”CUSTOMER NAME” CtrlID=”66″ SectionID=”15″ />
      <Item  Value=”CUSTOMER ADRESS” CtrlID=”57″ SectionID=”15″ />
      <Item  Value=”COUNTRY” CtrlID=”59″ SectionID=”15″ />
      <Item  Value=”SHIPMENT DATE” CtrlID=”33″ SectionID=”15″/>
      <Item  Value=”AMOUNT” CtrlID=”7″  SectionID=”3″ />
      <Item  Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
      <Item  Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
      <Item  Value=”LINE NUMBER” CtrlID=”211″ SectionID=”3″ />
      <Item  Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″/>
      <Item  Value=”AMOUNT” CtrlID=”7″ SectionID=”3″ />
      <Item  Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
      <Item  Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
      <Item  Value=”LINE NUMBER” CtrlID=”211″ SectionID=”3″ />
      <Item  Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″ />
      <Item  Value=”AMOUNT” CtrlID=”7″ SectionID=”3″ />
      <Item  Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
      <Item  Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
      <Item  Value=”LINE NUMBER” CtrlID=”211″  SectionID=”3″ />
      <Item  Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″/>
    </Page>
    </Pages>

    As you saw here are 3 attributes, Value (this should be mapped in source schema) , CtrlID and SectionID (these two attributes determinate where Value must be mapped , for example if SectionID is 3 and CtrlID is 5 that means that this should go to Line amount in destination schema).

    Output (in CSV) should be something like this:

    oRDERDATE|ORDERNUMBER|CUSTOMERNUMBER|CUSTOMERADRESS|SHIPMENTDATE|COUNTRY|ORDERTYPE(STATIC VALUE)|OWNER(STATIC VALUE)   this is OrderHeader
    LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE)                              this is OrderLine
    LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE)                              this is OrderLine
    LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE)                              this is OrderLine

     

    Hope that now is more clear.

    in reply to: Functoid Issue #24672

    Hi Patrick,

    Is this already resolved? Did you already add the dll to BizTalk application?

    – JC

     

    in reply to: Extreme mapping BizTalk Question #24671

    Hello,

    Have you tried conditional looping? For the given input, can you post the output desired in XML? That might help further understand the issue.

    in reply to: Exam 70-241 and 70-235 Difference #24669

    Today I appeared for 70-241’s first attempt. Unfortunately I have not cleared it. Still I can give second free attempt. Can anyone share latest study material or practice questions (dumps) for the same? My email id is [email protected].

    Thanks in advance.

    One of the very commone things, but hard to solve because most people don’t know the answer. I have searched days for an answer and hopefully this answer is the one for you too.

    The best solution I found was to re-register the ssosql.dll on the following manner:

     

    1. start the visual studio command prompt

    2. go to the ssosql.dll C:\Program Files\Common Files\Enterprise Single Sign-On

    3. regasm ssosql.dll

     

    and probably you are finished.

    in reply to: How to do multiple procedure call from one XML file #24666

    Hi,

    you’re true, if you have got the BizTalk Adapter Pack 2.0, you could use composite operation for Oracle Database

    http://msdn.microsoft.com/en-US/library/dd788415(v=BTS.10).aspx

    The aim is to generate the schema of the SP(s), then you create a new schema Composite with a Root (called CompositeOperationRequest for exemple) and in this root you create Record element as many SP you want (in order you want they execute), finally you create a reference in this schema to include definition of the SP Schema and you type the record(s) with the type of the generated schema root.

    In your case where you want to call the same stored procedure, the steps are :

    Generate the schema of the stored procedure

    Create a new schema with a root, Import the generated schema

    Add a record in the root element, and type this record with the reference of the generated schema

    Change the property of max occurs to unbounded(*)

    Create a map to transform your XML to the XML that will call the SP with the Header and the insert positions

    Create a Send Port WCF with OracleDbBindings and specify the action to http://Microsoft.LobServices.OracleDB/2007/03/CompositeOperation

    (All these steps are described in the first link)

     

    A good thing to know is in composite operations, all the call of the procedure(s) are do in the same transactions (so rollback to)

    Have a good Sample 😉

    Regards

    in reply to: getting WCF URL value in biztalk server #24663

    Hi,

     

       Check the following blog to see how an orchestration is exposed as a WCF service and how such a service is consumed in a Windows console application:

    http://mohammedatef.wordpress.com/2009/07/08/exposing-wcf-services-from-orchestrations-using-biztalk-2009/

     

        Daniel.

     

    in reply to: Update WCF service reference #24661

    Thanks for the reply Ben

    I’ve been forced to same conclusion
    myself  🙁

    – good tip about the separate folder for the generated
    artifacts !

     

    Is it any better in BTS 2009 or 2010 ?

    in reply to: BAM Problem Again :-( #24660

    Can you share with us the solution.

Viewing 15 posts - 1,336 through 1,350 (of 9,648 total)