Assemblies in GAC not showed in Add Reference dialog

Situation:

I created a GeneralBiztalkHelper Dll, I placed it in the GAC and want to use the assembly later in other projects.

When I wanted to add it to the new project via Add Reference,  I didn't saw the assembly listed.

 

Solution:

The list of assemblies used in the Ad Reference  dialog isn't populated from the GAC but from the following directory

%WindowsDirectory%\Microsoft.Net\Framework\%Version%\

File transport does not have read/write privileges for receive location

Situation:When creating a File Locations, linked to a share directory, i always received the following 2 errors:
The errors are telling that the "File transport does not have read/write privileges for receive location..."

The Host Instance User has modify permissions on the shared folder.


and



Solution
You need to
Delete Subfolders and Files attribute is not set when the Modify property is set, you need to add the FILE_DELETE_CHILD "Delete Subfolders and Files" Attribute

Error: ...The failure may be cuased by the fact that under the default settings SQL Server does not allow remote connections

Situation:
While deploying my BizTalk Project i received the following error



Solution:
- Open the Properties of the project,
- Under Configuration properties, select Deployment
- Check if the server is correct

Replace " (double quotes) from Field Elements with Xslt

Situation:
I receive a CSV file, all string values are surrounded by " (double quotes).
This is normal for a CSV file, to use with Excel. But when I need the values of these fields in my Xml to send to SharePoint, you can understand that I don't want to have those double quotes in the fields.

Problem:
I didn't find in my map a functiod to Replace those double quotes

Solution:
I created a map with a Custom Xlst, and used the function Translate for each field



I added this map to the receive port. Once the Xml file arrives in my Orchestration,the double quotes are gone.

Flat File Disassember Error: Unexpected end of stream while looking for

Situation:
I receive a flat file, going thru a receive pipeline with a Flat File Disassembler Component. And I received the following error:

Error:
There was a failure executing the receive pipeline: "OmnioApplication.Pipelines.ReceiveFlatOmnioFile_IncomingRequest, OmnioApplication, Version=1.2.0.0, Culture=neutral, PublicKeyToken=99f7db139ef9cf70" Source: "Flat file disassembler" Receive Port: "OmnioFlatPort" URI: "D:\TestArea\Omnio\Input\IncomingRequest\*.txt" Reason: Unexpected end of stream while looking for:
Positional data (length is 24)
'\r\n'
The current definition being parsed is RequestRevenue. The stream offset where the error occured is 72. The line number where the error occured is 2. The column where the error occured is 33.

Solution:
While checking the Flat File I saw that the last line was an empty line. This means that after the last record, a carriage return was added.

So I went to the XSD of the flat file in Visual Studio and selected the Root Element
Within the properties I changed Child order to PostFix and it worked.

Documentate BizTalk Applications

This will be a short blog message, to documentate your BizTalk Applications download UK SDC BizTalk 2006 Documenter

UK SDC BizTalk 2006 Documenter
Creates compiled help files for a given BTS 2006 installation. This tool can be run on an ad-hoc basis using the UI or from the command line as a post build/deploy task to create a compiled help file describing a BTS 2006 installation. It will compile: BTS Host configuration, Send/Receive port configuration, Orchestration diagrams, Schema and Map content, Pipeline process flow, Adapter configuration, Rule engine vocabularies and policies, More… and publish them as compiled help files. Optionally you can embed custom HTML content and custom descriptions for all BTS artifacts to produce a more customized look and feel to the CHM output.

Download link: http://code.msdn.microsoft.com/BTS2006Scripts/Release/ProjectReleases.aspx?ReleaseId=237

Determine the Version of BizTalk Installed

Situation:
Check the version on Test, Validation and Production Server.

Solution:
Open regedit and got to
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\BizTalk Server\3.0\

You will find the information you need and compare with the other systems.