Forum Replies Created
-
AuthorPosts
-
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
There is no built in suppression of errors. Are you sure the orchestration and its host instance are still started?
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.
send the exact input format and the expected output format
Also specify the types of the the source and the destination field
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
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
March 5, 2009 at 6:04 AM in reply to: How to insert data into SQL Server without using SQL Adapter #21833Hi 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
Forgot to add that there are no more suspended instances in BizTalk too
– Farooq
March 4, 2009 at 1:17 PM in reply to: How to insert data into SQL Server without using SQL Adapter #21826Can 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.
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
March 4, 2009 at 8:28 AM in reply to: How to insert data into SQL Server without using SQL Adapter #21824This 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
March 4, 2009 at 7:55 AM in reply to: How to insert data into SQL Server without using SQL Adapter #21822Hi,
create a .NET component which inserts to SQL, than call this component from an orchestration.
Laszlo
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
actually this is a simple orchestration for testing purpose.
if this works fine then next step is email processing and attachments extraction.
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
-
AuthorPosts