BizTalk 2006: System Error 230 – Pipe state is invalid ?

I’m not a 100% sure why this happened ? . But I’ll post this error in case any one can point out the reasons behind this one.
Here is the situation:
I was debugging my BizTalk 06 pipeline using VS 2005. And while doing so, I came across a situation where my file wasn’t being picked by [...]

Read Full Post »

BizTalk 2006: SQL Adapter – Address should be unique

While using a SQL adapter to receive data from your DB, one of the most common error that pops up is as follows:
Error:Address should be unique for Receive Location ‘Receive Location1′.
Address ‘SQL://<machineName>/<database>/’ is already present for Receive Location ‘RcvSQL’. (Microsoft.BizTalk.ExplorerOM)

This error simply states that there is another listener (SQL receive location) that is registered with [...]

Read Full Post »

BizTalk 2006: Primary Receive Location cannot be deleted

One of the common “error” dialog boxes we see while deleting a receive location. 
Error:  Primary Receive Location cannot be deleted. (Microsoft.BizTalk.ExplorerOM)

The obvious thought here is that perhaps the location is being used by another BizTalk artefact. Well, after making sure that is not the case – still the above error persists ! Solution:

 
A simple trick to delete the recieve [...]

Read Full Post »

Reset Auto Increment ID value / Insert Custom ID value

Often while testing our application, we perform several insert/update/deletes on a table. Assuming the primary key (identifier) was an AUTO increment ID field, after several test runs there is a point – where we would like to start fresh – again!. (A familiar pattern while developing/debugging J )
After deleting the table records, my next ID [...]

Read Full Post »

BizTalk 2006: BizTalkAssemblyResourceManager failed to complete

While deploying my BizTalk solution using Visual Studio 2005, the following error was produced.
 
Error DEPLOY: Failed to add resource(s). Change requests failed for some resources. BizTalkAssemblyResourceManager failed to complete end type change request. Access is denied. (Exception from HRESULT: 0×80070005 (E_ACCESSDENIED))
 
After insepecting my GAC folder, I found the folder empty. I’ve seen similar errors while [...]

Read Full Post »

Item templates in csproj

Often while creating projects in your dev enviornment, I find the use of Item templates very helpful. The idea is to create a general template that includes all your common code – e.g Header info for class, regions in terms of class structure. Every dev member in your team would use this template to create [...]

Read Full Post »

Asia Cup n Wimbledon

Hmm.. A happening day today..
1) Srilanka beats India in the final of a thrilling Asia cup (guys we are talking about cricket ). The Indians restricted Srilanka to under 280 runs (with Jaysuriya in blistering form even at 39 years of age). I was still betting on the Lankans simply because of playing [...]

Read Full Post »

BizTalk: Unable to switch the encoding

After posting about “Using a SQL Adapter to update an XML datatype column”, I ended by getting an error by the SQL Adapter when I integrated this prototype into a real world application.
 

Error:
A message sent to adapter “SQL” on send port “FileExceptions_SQL” with URI “SQL://<machineName>/<DatabaseName>/” is suspended.
 

Error details: HRESULT=”0×80040e14″ Description=”XML parsing: line 1, character 38, [...]

Read Full Post »

SQL: View locks on your database

It is generally a good practice -during dev work to view the impact that your components could have your application database. Of the many analysis that could be done in this regard ,  one such metrics is the monitoring of locks. SQL provides one such stored proc called the sp_lock. In using this, I have to filter [...]

Read Full Post »

Generate .cs files for your BizTalk Artifacts

To generate a cs file for your artifacts in BizTalk add the following to your registry
 
HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\7.1\BizTalkProject with a DWORD value named GenerateCSFiles – set the value to 1
 
Restart your IDE and that should be it ..
 

Read Full Post »