Custom Orchestration not showing in the Esb Itinerary Property Window

Ever tried to use a custom 'Orchestration' in your Itinerary for processing your business funtionality only to find out that 'Itinerary Designer' is not showing it in the 'Itinerary Service' properties??


Well, there are couple of things you need to do, before you get to that point!!!


First of all, You need to create a new entry for your 'Orchestration' in the ESB.Config file located at 'C:\Program Files\Microsoft BizTalk ESB Toolkit 2.0\Esb.config'. Open up the configuration file, look for 'itineraryServices' node. Inside this, you've got to add a new entry for an 'ItineraryService' of type Orchestration.


Here are the list of attributes for the ItineraryService node :
id : It has be a new GUID. Generate a new GUID and assign it.
name : Any name that you want to assign to your Orchestration Service. This is the same name that would be used by the 'Receive Shape' in your Orchestration to subscribe to the messages comming for the Itinerary Service.
type : This is the combination of Orchestration Name and Assembly Name. This information can be found by right clicking on the Orchestration in the BizTalk Admin Console, and click on Properties. It will show a list of properties. Under 'General' tab, you could find the Name and Assembly information. Just copy those two values seperated by a comma.
scope : Since this is an Orchestration service, it's scope should be 'Orchestration'.
state = "None".
A typical entry in the ESB.Config file will look like this :


"itineraryService id="5" name="TwoWayTransformation" type="ESB.MultipleWebServices.Orchestrations.TwoWayRouting, XactConnectArtifacts, Version=1.0.0.0, Culture=neutral, PublicKeyToken=f922625124e336c0" scope="Orchestration" stage="None"/"


Once you have this information in the ESB.Config File, it should show up in the Itinerary Service Property Window for the ServiceName property. If it doesn't show, close the Visual Studio and open it up again... It should be able to show up now...


If it still doesn't, like it did for me, then the problem lies else where...


When you configure SSO using EsbConfigurationTool.exe, are you storing it in a datastore or a file???Change it to look it up from a file.... It will show up!!!! If you have configured it to look in a datastore then any changes made to the configuration file will obviously not show up...


So, Open up the ESBConfigurationTool.exe, click on Configuration node and see what is checked over there.... File Source or SSO Configuration Source???If it is SSO Configuration Source, then click on the UnConfigure Source button in the menu, Select File Source and then click Apply Configuration....


From now on, any changes made to the Configuration File will show up!!!!

DB2 Adapter Send port Configuration:

Step1 : Create two way send port with DB2 adapter
Step2: Configure the
1. Connection String :
User ID=ediuser;Password=***************;Initial Catalog=BCDB2T;Network Transport Library=TCP;Host CCSID=37;PC Code Page=1252;Network Address=host. sic.com;Network Port=4050;Package Collection=MOLE;Default Schema=MOLE;Process Binary as Character=False;Units of Work=RUW;DBMS Platform=DB2/MVS;Defer Prepare=False;Rowset Cache Size=0;Authentication=Server;Persist Security Info=True;Connection Pooling=False;Derive Parameters=False;

2. Document Target namespace (input schema) - http://Debatching.Db2Schema.
3. Response Root Element Name : Response root(Tp_Response)
4. URI : DB2://host.lahsic.com:4050/BCDB2T/MOLE(configure Connection string automatically created this string)
Connection String configuration:
Click on Connection string button -> select new connection string radio button
Next-> set Data source flat form (DB2/MVS,DB2/AS400…)
Next->set Net work Type (TCP/IP)
Next ->Address of alias (DB2 server address eg host. sic.com)
Next -> Set Port
Next-> set the Initial catlog, Package Collection, Default schema and Database name (Database name and Initial catalog both are same)
Next ->Set Host CCID and PC Code page (default ones)
Next ->set the Security method (default –sign on), user name, password, confirm password and Authentication method (default server).
Next -> Select Connection pool, Defer prepare, derive prepare
Next -> test Connect button and packages and finish…

No template information found. See the application log in Event Viewer for more details

I am facing the following issue in my Visual Studio 2008. When I try to Create new website or new project it shows following error message.
“No template information found. See the application log in Event Viewer for more details.
To open Event Viewer, click Start, Click Control Panel, double-click Administrative Tools, and then double-click Event Viewer.”

Event log display following warning:
The global template information is out of date. Regenerate the templates by running 'devenv.exe /installvstemplates' or reinstalling the application. Note: corrective action requires Administrator privileges.

Solutions:
1. Run devenv /installvstemplates as suggested in Event Viewer.
Then Run devenv /resetsettings.
2 . If this do not help then try to run Visual Studio Repair using program & features (Install/Unstall).

To repair Visual Studio on Windows XP or earlier
1. In Control Panel, on the Add or Remove Programs page, select the product edition you want to repair and then click Change/Remove.
2. In the Setup wizard, click Next.
3. Click Repair or Reinstall.

4. Temporary fix:

FROM
“\Common7\IDE\ItemTemplates”
TO
“My Documents\Visual Studio 2005\Templates\ItemTemplates”.

Adding node in MAP by using XSLT

CODE:









400
40

BizTalk Pipeline Component problem – Component ‘…’ could not be initialized. Pipeline component ‘…’ could not be resolved (is an assembly reference mi

SOLUTION
• Rebuild pipeline component in Visual Studio
• Shutdown Visual Studio
• Deploy the component (copy to “C:\Program Files\Microsoft BizTalk Server …\Pipeline Components”)
• Restart BizTalk Host Instances
These steps solved my problem
Other possible solutions
Solution 1
• Some external assemblies are missing
• Copy the missing assemblies in the Pipeline components folder or in GAC
Solution 2
• Restart the system

Configuration in BizTalk Map

Steps:
1. Open "BTSNTSvc.exe.config" file from "drive:\Program Files\Microsoft BizTalk Server 2009 ".
2. Add configuration setting there such as -
//appsettings
add value="Data Source=.;Initial Catalog=yourDB;Integrated Security=SSPI" key="STR"
appsettings//
3. In map file, drag and drop script functoid and write following inline c# script.
public string GetConnectionString()
{
string connString=System.Configuration.ConfigurationSettings.AppSettings.Get("STR").ToString();
return connString;
}
4. While using any database related functoid, drag output of script functoid as input in database functoid. And do not forget to put it in correct parameter sequence.
Note: One more last thing, you cannot test config value in map at design time because configuration values are read BTS host at runtime.

Configuration in BizTalk Map

Steps:
1. Open "BTSNTSvc.exe.config" file from "drive:\Program Files\Microsoft BizTalk Server 2009 ".
2. Add configuration setting there such as -



3. In map file, drag and drop script functoid and write following inline c# script.
public string GetConnectionString()
{
string connString=System.Configuration.ConfigurationSettings.AppSettings.Get("STR").ToString();
return connString;
}
4. While using any database related functoid, drag output of script functoid as input in database functoid. And do not forget to put it in correct parameter sequence.
Note: One more last thing, you cannot test config value in map at design time because configuration values are read BTS host at runtime.