Forum Replies Created
-
Posts
-
"You may want to define the parent as its own record and the child records as a subordinate loop record" is what I meant to write -wa
Anon –
You may want to define the header row as a record and the child code as a subordinate loop.
You can calculate the child codes with a counter and format the value to the appropriate format you seek.
-wa
Can you transform the Excel to XML and get better access? Seeing you gong to binary seems like a difficult road…
Another possibility is to write an extract routine in the spreadsheet with VBA and have it produce the file for Biztalk.
You can register the Spreadsheet as a Datasource and access that way…
These are just some other ideas if your initial approach is unworkable.
-wa
I am new to Biztalk and may be my question sounds naive, but I need the clarification on performance. Is there a imapct on performance for a map when the scripting functoids refers to external assemblies v/s inline C#/VB.NET? What are the best practices in industry? In what situation, which works best?
Hi,
Thank you for your help. I am getting another issue when I use looping functoid with "after block"
I am getting following error:
Out of sequence before or after elements are not permitted inside a single sync block. If there is more than one of these, every before block must be followed by an after block.
I noticed that I have more than one after blocks under the one Sync block. I read somewhere that we can have many after block with in one Sync. Then Y i am getting this error?
Should I have to add before block manually if i want multible after blocks? how to add?
I used updategram to create the SQL Adapter Schema.
Thank you in advance,
Siva
Thanks for the response. But i still need to provide support for the other client with the old schema too.
It appears you don't want to modify your orchestration at all. In that case you can create a new map that transforms the new schema into the old schema and add that map to the receive location. Messages in the new schema will be transformed to the old schema before they reach the orchestration.
Like you, I am seeing variable response times for my same orchestration to run. My test used a simple HelloWorld type of orchestration which featured a call to a custom .NET assembly which only returned a different string every time when the orch calls it.
My orch consistently took 6 to 8 seconds on the first run, and then just under 1 second on all successive calls. I tried it with two kinds of ports: a file-drop, and a web service. Both port types showed roughly the same speeds for the request-response cycle. The same pattern always occurs here: The first run is slow, and the rest of the invocations are fast. Everything is running on one basic development workstation on WinXP with no network hops.
You might check that your paging file in WinXP is smaller (preferably much smaller) than 1 GB during your tests because I have seen low memory conditions and paging to disk really bog my computer. Also might check that your antivirus is not hogging the cpu and disk resources during tests.
Seems like i'm going to the right direction. I dropped the iDisassambler Interface and implemented IComponent. it runs through debgugging without error… the only thing is that i get at the en an error whicht says Source : PipelineObjects| Message: Invalid Pointer | HRESULT 80004003
any suggestions?
Hello Richard Seroter,
Thanks for your reply, it sure makes sense.
We have tried the "between", "before" and "after" predicates.
Have been struggeling to get the right DATE-format for the values to check, but we never changed the date that we would like to check from STRING-format to DATE-format.
I will try this later on this or next week and let you know about the results.
If one orchestration references any pipeline dlls or external assamblies, and the other orchestration references them also, based on dependencies Deploy will Un-deploy both and re-deploy both.
Indeed, BizTalk 2006 ships with an out-of-the-box WSS adapter (see here for more on it .. http://www.microsoft.com/biztalk/techinfo/whitepapers/adapterwp.mspx). This adapter allows you to both poll document libraries in a SharePoint site, and push messages to document libraries (and technically "lists" as well). It's fairly easy to set up, as BizTalk uses the SharePoint web services interface. There are some security considerations that are included in the installation docs.
Note that this is SharePoint 2003, NOT MOSS 2007. You'd have to tweak the existing adapter to work with the new SharePoint version.
Also, I have tried deleting all artifacts within the admin console, all adapter handlers, then all adapters, then all host instances and hosts, but when
I tried to install the BizTalk Runtime, and it gives me the error
‘Instance of the WMMI class not found. No instance was found with the specified key. This could be a result of the instance being deleted by another BizTalk Admin session’
