Forum Replies Created
-
AuthorPosts
-
One last thing, while playing around with this I tried your solution directly and still get an implicit conversion error with the
MsgXmlLogMessage = MsgSalesOrderRcvd; // Initialize the XmlDocument message
statement in an expression shape immediately after the receive. I tried it both a message and with a variable ot type System.Xml.Document. Just out of curiosity, ow did you get that to work?
hi i’m very interested in this also…how to extract message each from the multi part messages and zip them up together….would appreciate if anyone would share this
December 12, 2008 at 6:57 AM in reply to: Any good way to schedule a receive port to pick up files Monthly? Thanks! #21370You can write a windows service or wmi script and put the scheduling info on a SQL table and enable the receive location using BTS Catalog Explorer.
Thank you for the details! Yes, I’m experimenting with something like that now although it’s not very elegant. I’m now receiving XLANGS errors that the message doesn’t match the xpath it’s looking for, but I think I can work that one out. Ultimately, I’d like this orchestration to be something easily implemented in the other orchestrations directly. However, I’m running into a lot of little incompatibilities such as the message type issue we just covered. I appreciate your patience! Thank you for the help!
To my knowledge, BTS 2006 R2 needs WSS 2.0 so that the configuration later can be done more smoothly. After which, you need to extend a virtual server in the Sharepoint site. With that, then your BTS can be installed and configured….
As for your MOSS, you need to install the BizTalk Window Sharepoint Service Adapter to your MOSS server also. If not, your WSS adapter will not be able to work. To install, you need to run the BizTalk installer CD but when you reach the Feature choosing part, you choose only Additional Component->Window Sharepoint Service Adapter and uncheck everything else.
December 12, 2008 at 6:13 AM in reply to: Any good way to schedule a receive port to pick up files Monthly? Thanks! #21367thought that in the receive location configuration has the polling interval which can determine the interval for you to get the files…
Hi I know how to restart a host instance and had tried and test before [:)]
But I had a question. Can I keep all the previous version in the Biztalk so that in case of any crashes, I can revert back to the previous version
hi…i’m new in BTS…but i think i saw something with the multi part message that might solve your problem….
Extracting from the website http://msdn.microsoft.com/en-us/library/aa546739.aspx
-
From your project, add a reference to Microsoft.XLANGs.BaseTypes.
-
Create a variable (for example xlangPart) of type Microsoft.XLANGs.BaseTypes.XLANGMessage.
-
Call xlangPart.AddPart(…) using the appropriate arguments from an Expression shape.
After doing some researches, I realised that i could create a customised send pipeline which i can include the namespace e.g. <?mso …..>….href=”http://www.url.com/form.xsn”</?mso> in the ProcessInstructions and set the ProcessInstructionsOption = 1
That works!
December 12, 2008 at 3:49 AM in reply to: InfoPath Auto-Generated Schema Element become Record #21363I realised that after i generate the schema from the XML file using the BizTalk Schema Generator, if a particular XML tag has no data, the data type of that tag in the schema would be xs:anyType which makes that tag a record. To resolve that, make a default value in the tag and the tag would be in xs:string and this will make that tag an attribute [:)]
Make sure you click on the “Click to show quoted text” in my earlier thead, because there is more there, I don’t know why it did that.
Hi, sure I’ll try to explain better. I’ll just use our example and then you could perhaps convert that to your situation. First to answer your questions:“I’m assuming you mean you generated it in BizTalk through the “Add Generated Items” option” – Yes. And yes SQLService.XSD can use attributes just as well 🙂 so now on I’ll talk about attributes not elements to keep things simple.
OK, my situation: I have a Receive shape at the top that activates this orchestration(In this case it is the ProcessSalesOrdersOrchestration). The very first thing that I do after the Receive shape is an Expression shape with this code:
MsgXmlLogMessage = MsgSalesOrderRcvd; // Initialize the XmlDocument message
Now I have two messages in the Orchestration: MsgXmlLogMessage(type System.Xml.XmlDocument) and typed MsgSalesOrderRcvd.
Now I need to create a typed message from schema CreateLogEntry(your case SQLService) called MsgRcvLogRequest. To do that I have a Construct shape and inside it I have a Transform and an Assignment shape. In the Transform shape I have a map from schema SalesOrder to schema CreateLogEntry where I copy the OrderId, Date, etc to some of my columns in the Log table(in this map I for example map the OrderId to the attribute XmlMessage so that I initialize that attribute before the assignment shape). Then in the Assignment shape I copy the message MsgXmlLogMessage into this attribute XmlMessage like this:
MsgRcvLogRequest.parameters.CreateLogEntry.XmlMessage = MsgXmlLogMessage.OuterXml; // I promoted the property XmlMessage
Now I have three messages the original SalesOrder, the typed CreateLogEntry with some attributes like OrderId, Date, Origin, etc and also a attribute called XmlMessage which contains a copy of the SalesOrder xml message and the untyped XmlDocument MsgXmlLogMessage. To do this we needed the untyped XmlDocument message just to copy the data for us through this fine OuterXml property 🙂
OK, now I have explained better I hope.
I just read your post over again and saw a few things:
“Also, if the incoming message in your example is typed
(MsgSalesOrderRcvd), then the expression editor throws an error when
it’s assigned to a different type message (MsgXmlLogMessage)” – I assign the other way around, I assign the typed MsgSalesOrderRcvd into the untyped MsgXmlLogMessage: MsgXmlLogMessage = MsgSalesOrderRcvd;“but if I’m receiving an untyped message (of type System.Xml.Document
already because multiple other orchestrations need to send various
messages of different formats to this one for logging in the DB) then I
don’t have the option of selecting it as a source for the map” – I see this as an problem. In order to assign the promoted property through Assignment shape we need to initialize the original message with a transform shape. Perhaps you could create a very general schema with nothing but the type <any> element and then create a map from that schema to your SQLService schema and just put some hard coded value into your XmlMessage attribute (and other attributes you need) and then right after assign the correct Xml document to the XmlMessage attribute… ?? Maybe some xpath could help you here I no very little about xpath so sorry about that.I’ll monitor this thead until you get this to work because I know we are close 🙂
December 11, 2008 at 10:42 AM in reply to: The Messaging Engine encountered an error while suspending one or more messages – PRODUCTION #21356Baldur,
Messages are not that big, they are about 30 KB each and we get around 1000 message at the same time from SAP. As I mentioned we are using standard edition 32 bit Windows Server 2003 so were limited to use only 4 gig RAM. We have about 7 hosts (instances) running on this server.
Another thing is, we did not get any errors yesterday night. We got the errors 3 days in a row.
BaldurKn,
Thanks for the quick response. A couple of questions for you:
When you say you ‘generated a schema from this procedure’, I’m assuming you mean you generated it in BizTalk through the “Add Generated Items” option. when I generate the SQLService.xsd, it creates the parameter as an attribute, not an element. Is this correct for your solution as well?
It appears from your description that the incoming message is MsgSalesOrderRcvd and the blank XMLDocument message is MsgXmlLogMessage. But I’m unclear as to what you’re mapping in the transform shape you refered to. I would think you wanted to map the incoming message to the msg of type CreateLogEntry (created from the stored procedure), but if I’m receiving an untyped message (of type System.Xml.Document already because multiple other orchestrations need to send various messages of different formats to this one for logging in the DB) then I don’t have the option of selecting it as a source for the map. Also, if the incoming message in your example is typed (MsgSalesOrderRcvd), then the expression editor throws an error when it’s assigned to a different type message (MsgXmlLogMessage). I think I may be misunderstanding you on this part because it’s not working when I try it. I tried to create a new message manually in a message assignment so I could map something in the transform shape, but it comes out with an xpath failure when I submit a message.
Any further details you can give?
Thanks again!December 11, 2008 at 6:13 AM in reply to: The Messaging Engine encountered an error while suspending one or more messages – PRODUCTION #21354Humm… Are the files large ? Could it be that BizTalk is splitting up the files ?
-
-
AuthorPosts