[community-content]

Actually :
[code:1:a7cd7e0c6a]incomingMsg(FILE.ReceivedFileName);[/code:1:a7cd7e0c6a]
return a string lke this :
[code:1:a7cd7e0c6a]c:\\data\\file[/code:1:a7cd7e0c6a]
and not only like I thought :
[code:1:a7cd7e0c6a]file[/code:1:a7cd7e0c6a]
[size=9:a7cd7e0c6a]Sorry to disturb the forum…[/size:a7cd7e0c6a]

[community-content]

Hi.

In the Biztalk 2006 help files, it only tells you how to restore biztalk
databases onto a 2nd server using log shipping. What do you do, if like me, you do not have this luxury and you’re having to run the whole thing on the one server without it being fault tolerant, this doesn’t appear to even get a mention in the help files.

Thanks

[community-content]

i need to process the incoming xml file. Several components of the xml file are referenced by the href elements, so they must be downloaded too. Then, after i have all the components i must put them into the database. What is the best scenario for this? Custom pipeline which desserialize the xml into in-memory class then downloading all the components?

Thanks.

[community-content]

Hi,

Just after the receive shape, I’m using an [i:b73c94e9a3]Expression[/i:b73c94e9a3] shape in my orchestration and here I need the incoming file name like this :
[code:1:b73c94e9a3]fileName = incomingMsg(FILE.ReceivedFileName);[/code:1:b73c94e9a3]
Then, I would like to use a [i:b73c94e9a3]Decide[/i:b73c94e9a3] shape to test if this file already exists in the BizTalk Server directory (\”c:\\data\\\” + [color=red:b73c94e9a3]filename[/color:b73c94e9a3]).
[code:1:b73c94e9a3]System.IO.File.Exists(@\"c:\\data\\\"+fileName)[/code:1:b73c94e9a3]
I have the following error :

[i:b73c94e9a3][b:b73c94e9a3]The given path’s format is not supported[/b:b73c94e9a3][/i:b73c94e9a3]

So the test always returns false even if the file already exists.
However, I can use the filename in the [i:b73c94e9a3]Message Assignement[/i:b73c94e9a3] shape because the output file named just like [color=red:b73c94e9a3]filename[/color:b73c94e9a3] :
[code:1:b73c94e9a3]outputMsg(FILE.ReceivedFileName) = fileName;[/code:1:b73c94e9a3]
[i:b73c94e9a3]Ex. Incoming file = coura38.fic – Output file = coura38.fic
If the file coura38.fic already exists in \”c:\\data\\\” the orchestration terminated.
[/i:b73c94e9a3]
It would be great if someone could tell me why this doesn’t work…

[community-content]

What do you mean by evaluate?

Ok, here is what you need to do at a high level:

– Break up your document into a header record, detail records, and trailer records
– Route your Header to two Orchestrations
– Route success messages to one Orchestration and Error message to the other using Convoys
– Route your Trail records to each Orchestration
– End the convoy and send out the resulting file

How exactly to accomplish this depends on what evaluate means and if you have a tag identifier on your flat file.

[community-content]

If anyone else runs into this problem, here is the solution, pretty easy to implement.

There is a sample in \”The Bloggers Guide To BizTalk V 1.8\”
http://www.gotdotnet.com/workspaces/workspace.aspx?id=0dfb4f4e-d241-4bc8-8418-2c385d8e3eaa

It’s under BizTalk Development > Maps > Mapping 2 Schemas with a 1:1
relationship in the BizTalk 2004 Mapper

Thanks,
–Steven

[community-content]

Hi,
We’re going to retire the database server for BTS 2004, and move the databases to a new server.

Does anybody have a suggestion on how to go about performing this task? Are there any issues that may arise once moved to the new server? Have anybody had any experience doing this? How did you go about it?

ThanX!

[community-content]

What’s the best way to write a schema for a flatfile with a positional header and a delimited body. One schema, two schemas? I know it’s a newbie question, but I really need to figure this out. It all has to do with parsing these infernal human readable reports that we must have information out of. I could just cludge it, but I’d really rather not and actually parse the files correctly. Any ideas/suggestions would be great.

Thanks,

Jon

[community-content]

Teddy,

I’m not aware of any documents touching this subject specifically; it depends quite a bit on your environment and what kind of load and traffic you’re expected.

Here are some good things to think about I’ve learned:

1- In many cases, it’s worth using separate hosts for separate projects – at least for orchestrations. it simplifies deployment a bit as well as sharing development machines.

2- In many cases, particularly when receiving a lot of documents, you’ll want to split the receive handlers into a host separate from the one doing the orchestration processing. You can also separate sending if that’s an issue. This gives you the benefit of easily configuring your biztalk group so that receiving and orchestration processing get separated in different physical servers

3- if you have many receive locations and/or orchestrations, particularly if you use the MSMQ[T] and SOAP adapters, split them into separate hosts. Otherwise, you can run out of threads in the biztalk thread pools for processing (even if you follow the KB articles on this to increase the limit).

4- If you have receive/send operations that handle very large files (particularly with transformations), you might want to split them into a separate host as well, as that will reduce memory pressure and give it a little bit more room to help reduce Out Of Memory errors when receiving many messages concurrently (there are things in BTS06 that can help with this as well).

[community-content]

Make sure your installing the following, from what I know its the only combination that actually works:

SAP Connector for .NET 1.0.3 (RunTime only)
SAP v2.0 Adapter for BizTalk 2004
SAP v2.0 Adapter for BizTalk CTP SP1 (which does work with BTS2006)

-Bryan

[community-content]

Has anyone run into this and resolved it? I installed the following on a vanilla install of BizTalk 2006:

SAP Connector for .NET 1.0.3
SAP v2.0 Adapter for BizTalk 2004
SAP v2.0 Adapter for BizTalk CTP SP1 (which does work with BTS2006)

And I am getting the following error when attempting to create schema per the wizard. I’ve re-installed everything with no luck. I’ve also attempted this on 3 different boxes with the same results.

Exception Details: \”Retrieving the COM class factory for component with CLSID {1EB415A4-242C-4E28-9E9C-33367784F01E} failed due to the following error: 8007007e.\”

Thanks.

Bryan Corazza
-Avanade

[community-content]

Greg,

As always thanks for your information, it led me in the right direction and I got what was needed complete.

Thanks,
–Steven

[community-content]

As a starting place, have a look at this article [url]http://web6.codeproject.com/useritems/BT2006Deployment.asp[/url] which explains a little about BTSInstaller and the creation of MSInstaller files for the movement of projects/solutions.

Or article : [url]http://www.topxml.com/BizTalk-2006/re-21587_How-To-Package-and-Deploy-BizTalk-2006-Applications.aspx[/url]

[community-content]

And there was much rejoicing!

I have deployed my assemblies to the \”biztalkdev\” machine. set up my folders with the right permissions and voila, the xml file is put into the recieve port folder, is subsequently removed and a transformed xml file is deposited into the send port folder. Nice.

One thing of interest was the permissions. Although I had set full control on the permissions, you need to go into the advanced options of the security tab within properties and set some special permissions, namely \”List Folder / Read Data\” and \”Delete SubFolder and Files\”. I was not aware of this. The following URL has the details if anyone is interested:

http://geekswithblogs.net/tshaaban/archive/2004/09/12/11037.aspx

Thanks Neal and Greg for all your help and patience on this issue, it was much appreciated.

Cheers
John

[community-content]

I reckon I need to compile on my machine and deploy to \”biztalkdev\”. It seems i’ve been deploying to my machine when BizTalk is running on the \”biztalkdev\”. Within my admin console properties I have \”biztalkdev\” as my \”Enterprise Single sign-on server name\”. I must only have the development install on my machine.

Just so you know, I didn’t install it.

In order to run biztalk apps on my machine I’m going to have to do a complete install, add the Engine components I believe.

If not I just deploy my assemblies to the \”biztalkdev\” machine. Yes?

Like i’ve said in previous posts, there has been nothing wrong with the folder names in the port setups. BizTalk has been running, but on the \”biztalkdev\” machine, not locally. And I’ve only been deploying my assemblies locally. I’ve been viewing the Event logs locally which explains why there’s nothing there.

Cheers

[Author]

Posts