community-content

Forum Replies Created

Viewing 15 posts - 3,136 through 3,150 (of 9,648 total)
  • Author
    Posts
  • in reply to: Flat File Issue #21846

    Create a flat file schema that does not group by parent node, then in a map perform the grouping using custom XSLT. This can help you get started: http://blogs.msdn.com/chrisromp/archive/2008/07/31/muenchian-grouping-and-sorting-in-biztalk-maps.aspx

    in reply to: Does BizTalk suppress recurring errors #21845

    There is no built in suppression of errors. Are you sure the orchestration and its host instance are still started?

    in reply to: Correlation Issue #21844

    If there is a field that will have the same value both on Request and Response you can promote this field to the same promoted property on the property schema, and then correlate on that.

    in reply to: How to get 24hr time format in mapper using functoids #21839

    send the  exact input format and the expected output format

    Also specify the types of the the source and the destination field

    in reply to: X12 997 Acknowledgement #21835

    How should I re-name file using %SourceFileName%? It is giving me error like

    An error occurred in the File System connector. Check the details.Placeholder [#]

     

    Tejas 

    in reply to: Handling Timeout in HTTP Adaptor #21834

    Thanks Siva,

                           I also tried with making Transmitted=”true” and Handling apro. But That was not working for me, So I Also Catched using Web.Service.Protocals.SoapExcpetion Eception, and Exception Block is catching that error During Timeouts, And when I looked into the error Message it was showing 

    General System Exception: An error occurred while processing the message, refer to the details section for more information Message ID: {ECE32919-1340-4FAE-B251-D22846219A9D} Instance ID: {0587A4F9-FC75-4E33-A440-5B84672153EC} Error Description: The remote server returned an error: (500) Internal Server Error.

    Is that what you are gettig for timeouts?

     

    Thanks,

    BABA

     

    Hi  Thiago

                I have a msg which contains three records and I have to create xml’s or load xml for these 3 records each of one xml and then I need to insert into a SQL table column, I need to do this How do I do? According to my knowledge I have to do in expression shape so is this correct, if so how do I do it?

    I need to insert data into SQL without using SQL adapter, what I am thinking is I need to write a .net component and call those methods in the expression shape, is this correct?  and can I use one expression shape for inserting 3 different values into 3 different tables?

     

    Thanks

    in reply to: Does BizTalk suppress recurring errors #21831

    Forgot to add that there are no more suspended instances in BizTalk too

     

    – Farooq

    Can you please share more information? What kind of data do you want to insert? Will the data be available in a message being picked up by BizTalk? Do you need BizTalk for the solution?

    Solutions to this could range frmo creating a dll in c# that performs the inserts and call it from a custom pipeline component or from an orchestration, to creating your own adapter.

    The SQL Adapter is usually recommended though.

    in reply to: Handling Timeout in HTTP Adaptor #21825

    Hi Baba,

    I guess following could handle thie issue. However I remeber I read somewhere that below may not hlep for timeout. Just try.

    Set the Delivery Notification = Tranmisted in 2 way port in ur orchestration.

    Put the send and receive shapes under the Scope shape. Create a exception hanlder. Set Exception Type = Microsoft.XLANGs.Base.Types.DeliveryFailureExcpetion and give a name for the exception. IN side the exception box, do whatever you want when the exception happen.

    I also create another exception hanler. Type is Web.Service.Protocals.SoapExcpetion. And handle whatever i want inside.

    Siva

     

    This component is called in Expression shape rite, so I need to debatch xml’s from a message and then insert these xml into a column of the table, my question is when debatching several xml’s from a message do I need to use one expression shape to debatch one xml or is it possible to use only one expression shape for debatching several xml’s from a msg?  and after that I need to insert these xml’s into their respective columns of the table and can I do this insertion in one expression shape like inserting different xml’s into different tables.

     

    Thanks 

    Hi,

    create a .NET component which inserts to SQL, than call this component from an orchestration.

    Laszlo

     

     

    in reply to: Biztalk 2006R2 Orchestration for Email Forwarding #21821

    Hi,

    First of all, the reason of the problem is, that your orchestration is waiting for another type of message than your Receive Port sends. You must consider that XMLReceive pipeline always tries to detect the type of message with searching for an appropriate deployed schema.

    The reason of your SendPort seems to be working  (I suppose) that your SP subscribes to everything that comes from your RP, without regarding types of messages.

    So, resolutions:

    1. If you would like to use types/schemas, than you should create a custom receive pipeline, which creates that type of message your orchestration waits for. You can use MIME/SMIME decoder pipeline component in your custom pipeline.

    2. If you would not like using types/schemas, than use PasshThru pipeline in your RP, and set your receive shape to wait for System.Xml.XmlDocument type of message.

    Laszlo

     

    in reply to: Biztalk 2006R2 Orchestration for Email Forwarding #21819

    actually this is a simple orchestration for testing purpose.

    if this works fine then next step is email processing and attachments extraction.

     

    in reply to: .CSV output to send in email using biztalk 2006 #21818

     

    Hi,

    You need to create a custom pipeline component that will change the MIME.Filename context property of the body part (or whatever part is the one being attached) and add this component to your send pipeline.

     

    Regards,

    Thiago

Viewing 15 posts - 3,136 through 3,150 (of 9,648 total)