Biztalk : PartUpdateDisallowedException Exception

When you are going to update any message in Construct shape which is already constructed, then you will receive this type of error. Like you are receiving msg1 and just after this receive shape, you are going to construct this message once more. In this type of situation, you will receive this type of error.

Solution:
To resolve this error,create a new message in orchestration view of same type. And use this new message in new message in construct shape. Same problem can occur when you are sending message to .net assembly too. So make sure when you want to update any message, it must be new.

Biztalk : tracking database doesn’t have any records about the selected service instance yet

I was getting this error while running my biztalk application. After searching on search engine, I have not received any response. Then I tried to see the host instances are working properly or not. And there I found the actual solution. That my application reunning in a host instance(test) was not running. I start that orchestraion and test my application. Its working fine now. Check your Host Instances working properly in which you have configured your BizTalk application. It will resolve your error.

Regards,
Vijay Modi

MySql: Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

To resolve this error, please go into the following location:
C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\Data

and delete “ib_logfile0″ and “ib_logfile1″.

Then go to Services and start your MySql. It will resolve the error and start you MySql.
Why: According to my search: Open the my.ini file and check the InnoDB variables’s size. When above file exides the mentioned size it will prompt this(“Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.”) error.

Regards,

Vijay Modi

How to Use C# code in vb project. ?

Today, I was facing a problem to how to use C# code in vb WebProject. I got the solution from the following URL:
http://timheuer.com/blog/archive/2007/02/28/14002.aspx

Regards,
Vijay Modi

Barcode Specifications

I created an application to generate barcode based on the user inputed data. I have written an application for generating barcode based on “Code 128″. I generated that Borcode based on the following specification.
http://www.spatula.net:8000/proc/barcode/code128.src
You can find all barcode specifications on the following link:
http://www.spatula.net:8000/proc/barcode/index.src

Thanks & Regards,
Vijay Modi

Validation on User Registration

Mostly we are giving functionality for registration on the website and use the website. And using our registration page, user can register him/her and set the UserName and password whatever he/she want. Here we are inserting some validations on client side and server side for checking the data entered by user is valid or not. However one more validation we require on Server side. This is regarding the UserName. We are providing functionality like user can create any UserName. We are checking on server side that the UserName enetered by User is exist or not. And if userName not exist we are creating that User with the UserName that he/she set on registration page.

However we should set one more validation on this registration page for UserName that the user cannot create UserName with the website domain name. Like if site domain name is “www.testing.com”, then user cannot create UserName, which contains the Domain Name in his UserName. Means user cannot register with UserNmae like ‘testing’, ‘testing123′, ‘123testing123′, ‘123testing’, ect…
This is very important as once user register with these name, he can sent mail to other person using that same ID from the website. So we should add validation on server side that the User cannot register with the UserName which contains domain name.

We should also add validation for some common names too. Like we should add validation on server side that the user cannot register with some common names like “hr”, “info”, “information”, “contacts”. So we should also add these list in our Server Side validation. So that user cannot register with these types of UserName.

Let me know your input for the same.

Thanks & Regards,
Vijay Modi

Find table from Column Name in an MSSQL Database

From the following query you can find all the tables contains the ‘FirstName’ column.

SELECT
table_name=sysobjects.name,
column_name=syscolumns.name
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
WHERE sysobjects.xtype=’U’ AND syscolumns.name like ‘FirstName’
ORDER BY sysobjects.name,syscolumns.colid

Regards,
Vijay Modi

Barcode Specifications

I created an application to generate barcode based on the user inputed data. I have written an application for generating barcode based on “Code 128″. I generated that Borcode based on the following specification.
http://www.spatula.net:8000/proc/barcode/code128.src
You can find all barcode specifications on the following link:
http://www.spatula.net:8000/proc/barcode/index.src

Thanks & Regards,
Vijay Modi

BizTalk: Pass an XLANG message or an XLANG message part to a .Net method call as a parameter in Orchestration. / Call .Net assembly to update the XLan

Today, I go through a solution to send XLangMessage to .net assembly from an Orchestration and update it. After update I need it in my Orchestration. For this I have created a project which I think it can help others.

I have created an Orchestration project named “CallNetAssemblyBySendingXLangMessageAndUpdate”. I have added the following simple schema in this project named “Book.xsd”.

Then I have created added an orchestration named “CallAssemblyXLangMessage.odx” in project. In this orchestration I am receiving the Book.xsd type message in receive shape. After this I have added the message assignment shape in the transform shape to update the values of message received of Book.xsd type. In this Construct shape I am creating a new message of Book.xsd type. In this message assignment shape I am calling the .net assembly in which I am updating the message.

I am sending the message in .Net assembly method as XLANGMessage parameter. Before going further I want to explain how I am accepting the message and updating it and return it.

For this I have added a new Class Library Project named “UpdateXLangMessage” in the Solution.

You need to create the Book class of Book.xsd created in Orchestration project by using XSD.exe util. You can create this class by using the following command at Visual Studio Command Prompt:

xsd.exe /c Book.xsd

This will create a Book.cs class. Add this project in class library project UpdateXLangMessage.

Now to receive XLangMessage and update it I have added the following class in this project.

========================================================

using System;
using Microsoft.XLANGs.BaseTypes;
namespace UpdateXLangMessage
{
public class UpdateMessage
{
public static Book UpdateBookMessage(XLANGMessage xlngMsg)
{
//Serialize message into Book Object
Book objBook = (Book)xlngMsg[0].RetrieveAs(typeof(Book));
try
{
//Update Book Object
objBook.Author = "Vijay Modi"
objBook.BookID = "00001"
objBook.BookName = "Biztalk 2006 R2"
objBook.Price = "Free"
objBook.Publisher = "Testing Publisher"
}
catch (XLANGsException xlngEx)
{
throw xlngEx;
}
catch (Exception ex)
{
throw ex;
}
//return book object
return objBook;
}
}
}

=========================================================

Build this class. Assign a Strong Name key to this project and add it in GAC using following command in Visual Studio Command Prompt.

gacutil /i UpdateXLangMessage.dll

Now we are going back to our Orchestration project. In Orchestration project add the reference of the .Net class library project.

Now in our Orchestration’s message assignment shape write the following expression:

//msgBookNew is the new message created of Book.xsd schema type

//msgBook is the message received in receive shape

msgBookNew = UpdateXLangMessage.UpdateMessage.UpdateBookMessage(msgBook);

Add the send shape just below the Transform shape in the orchestration. Assign the msgBookNew message in this send shape. The orchestration will look like as below:

Now deploy your orchestration project and test it. Some important reference I have found on the net are as below:

Reference:
http://support.microsoft.com/kb/917841
http://msdn.microsoft.com/en-us/library/aa995576.aspx

You can write your comments here:)

Regards,
Vijay Modi

Biztalk WSE Web Services Publishing Wizard Unable to load the assembly "…..\BTSTest.dll" [System.IO.FileNotFoundException] File or assembly name......

Error: Biztalk WSE Web Services Publishing Wizard Unable to load the assembly "…..\BTSTest.dll" [System.IO.FileNotFoundException] File or assembly name Microsoft.XMLANGs.BaseTypes, or one of its dependencies, was not found.

Solution:

To resolve this error you need to install the BtsAdpaterForWSE20-SP1 and need to add the ASPNet Users in BizTalk Isolated Host user group.

You can use the Start -> Administrator Tools-> Computer Mangement -> Local Users & Groups -> Group -> Double click on BizTalk Isolated Host Users and add the ASPNet user.