Forum Replies Created
-
AuthorPosts
-
How to debug a Orchestration in Biztalk?
Can i attach Biztalk process & debug , now iam writing to event viewer. Please let me know
PrashanthSpark
Can anyone please let me know the solution for it.
Hi Clay,
There is a performance hit when trying to insert that many records (100,000?) to a SQL table using the SQL adapter in an orchestration.
Having said that, short of architecting your BizTalk environment (version 2006) to take advantage of mutiple hosts and host instances configuration to make it more scalable and have better performance (this is more of a long-term design and architecture issue), you can use the following two short-term approaches, in conjunction or on its own:
1) Limit the number of records fetched back from Oracle adapter (relatively easy).
2) Break up the message (fetched back from Oracle adapter) into more manageable pieces that you can feed to the SQL adapter (relatively harder).
Best of luck!
Daniel.
What exactly are you trying to do? Set up a correlation to receive a message?
If you give me a little more detail I might be able to help.
The web services is in production. It is used to get the data from the database. I have another interface that it using it correctcly. I think is some step missing configuring the web service Call. I created the port schema ussing generated items wcf custom. Any Idea?
Thx a lot !
I think this is what I need.
Stephen rules again [Y]
Sounds like you need a sequential convoy, there is an example from Stephen Thomas here: http://www.biztalkgurus.com/media/p/15517.aspx
It can happen, that more than one file arrives in the receiving port (file). There is no rule about the sequence of the received file. It don’t matter, which one is processed first. There is also need to proccess them in-time.
But it could happen, that 10+ files arrive via attachment in one mail. This hammers the server and don’t allow a serial protocoll about the things happen during the processing.
I will try to search some examples about singleton and convoy processing. May u know a sample?
thx in advance
Roland
It seems some Object is not initialized before using it. Is it possible to debug the web service? This seems to be problem in Web Service.
June 29, 2009 at 9:43 PM in reply to: How to write a custom pipeline component to add namespace #22740You don’t need to write one. I believe one already exists. Please see this link
http://seroter.wordpress.com/2007/02/11/add-namespace-to-inbound-biztalk-messages/
Sent. 🙂
Hi Neal/Stephen, I have a similar issue like you have described. Did you get a solution for your problem? Could you please share the solution?
June 29, 2009 at 8:32 AM in reply to: Grouping and creating a new record in the Destination schema while mapping. #22734You can achieve this functionality in BizTalk mapper. In the map use a Global Array to store the Last Element Value. Initialize with empty first value. Now have one scripting functoid, check if the current element value is present in the Global Array or not, if its not present then return true, also add the Element Value in the Global Array and create the record as Header else return false (add the record as detail).
Now take one logical Equalto with Parameter1=output of above Scripting Functoid Parameter2=true and map to Header Node. So it will create Header node when you will not have Element Value in the Global Array.
Map the Logical NOT of EqualTo functoid to Details Node. So in case Element value is present in the Global Array, it will createonly Detail record.
Let me know if any issues.
I would tend to extract the LockBoxNo and BatchNo from the original message without constructing the XmlDocMSG.
StringXpathBase = “string(/*[local-name()=’BOAArlineItem ‘]/*[local-name()=’dbo.BankExternalLockBox_History’][{0}]/*[local-name()='{1}’])”;
LockBoxNo = xpath(BOAArlineItemMSG, System.String.Format(StringXpathBase,”1″, “RecordLockboxnumber”));
BatchNo = xpath(BOAArlineItemMSGSystem.String.Format(StringXpathBase,”1″, “recordbatchnumber”));Your original xpath statements will not resolve because the message has a namespace. You need to use a predicate i.e.
*[local-name()=‘nodename’]
or
*[local-name()=‘nodename’ and namespace-uri=‘message–namespace’] -
AuthorPosts