Showing posts from 2011

Enterprise Single Sign-On Service Error:0x80131700

ESSO service cannot start and giving  error message,
Windows could not start the Enterprise Single Sign-On Service service on Local Computer. Error 0x80131700: 0x80131700

This is happens after installing .net 4.0 framework. This is known known issue and there is a hotfix to install.

The URL* is, Update for Microsoft Enterprise Single Sign-On v4 (KB2252691)

* last access: 2011-10-31 11:45AM

For more details

MS SQL Server Backups & Restore: Steps explained

Yes I know, there are lots of articles and posts about this topic. But I want to show, what are things to be known to recover the database to specific point-in-time. Backup As you know there are 3 recovery models supported in MS SQL server.
Simple Automatically clear the log file. Only allows  recover to end of a backup. No log backupsFull Requires log backups No work is lost, if data (.mdf) file get damaged/lost Can recover to a specific point-in-time.Bulk-logged Requires log backups Use minimal logging for bulk operations, thereby reducing the log space Point-in-time recovery is not supported. In a mission critical environment, Full recovery model is the most recommended. In this post I’m paying attention to this model and simply explain point-in-time recovery. From your SQL server database you can take, 3 back up types.
Full Differential Transaction Log In Full recovery model, applicability of above types can be depicted in following way.

Figure 1 You can see in the Figu…


To Shrink the database log file I’ve used to,
1: 2:DUMPTRAN <DatabaseName> WITH TRUNCATE_ONLY 3:GO 4: 5:USE <DatabaseName> 6:DBCC SHRINKFILE (<DatabaseName>_log, 100); 7:GO 8:

This is not work in SQL 2008, as DUMP is discontinued. Otherwise we have to use BACKUP.

To shrink the log file in SQL 2008,
Back up the database in “SIMPLE” recovery mode. then run above line no 6.
Refer this ( for discontinued functionalities in SQL 2008.

WPF Application Crashes in Windows XP (System.IO.FileFormatException)

BackgroundWindows XP users are keep complaining me about  crashes of WPF application as soon I released it.  I was wandered, why all Windows 7 users don’t have that. My team mate did couple of enhancements plus adding new application’s window icon. The error message they receive is (crashing message !),ProblemSince everything working perfectly on Windows 7, something wrong with XP to what we did lastly. That is replacing the icon. But I have no proof for that, but  got a clue from the following screen.Hm…., I change the icon to a very classic one and try it. WOW, it is working fine in XP. Now I want to find out what is the different between this icon and the my icon. I found that my icon containing additional two image types (256x256, 32bit,PNG), which you can be seen from the Visual Studio Icon editor.SolutionI removed these two image types from the icon file using Visual Studio Icon Editor, added to the application and  it’s work fine.To justify the situation, I found this (accessed…

WS02 Con 2011- Colombo

During last week, I have attended to WS02 conference. The company, WS02, known as SOA company but I would like to call them Platform Enabler. They have done really good work in open source. I’m quite interesting in their ESB product which using by EBay.   They have implemented open source version of Cloud platform called WSO2 StratosLive is really simple and easy to use.  As a Sri Lankan I’m truly proud of this company. If I’m not wrong, WSO2 started somewhere around 2005-2006, but they made a good journey so far. Best of luck for your future.

IIS 7.5: 401 Unauthorized Access Error (Keep prompting Username/password)

BackgroundYesterday, my applications were migrated to Windows 2008 R2 (64bit). All applications configurations are,Developed using .NET v 2.0 & 3.5 Using 32bit COM/wrapper for ERP access Windows AuthenticationWithout recompiling, applications were migrated to IIS 7.5. Actions taken on IIS for above 3 are, respectively, Used “Classic .NET AppPool”Set “Enable 32-Bit Applications
Enabled Windows Authentication
ProblemAll are accessed by our local intranet users. 95% of the workstations using Windows 7. Rest the XP users complaining me they cannot use the applications, in which keep asking the User Name/password. Though they have entered their domain user name and password it did not accept. SolutionAfter one & half day attempt, I solved this issue. Solution can be found in KB 896861. Folks, if you face the same problem, go head with Method 2 in the KB.Excerpt from the KBMethod 2: Disable the loopback check (less-recommended method) The second method is to disable the lo…

BizTalk 2010 EDI : Parties/Party Migration

Parities cannot be directly migrated from order version to BizTalk 2010. Because,  Trading Partner Management (TPM) has been re-engineered in BizTalk 2010. You have to use BizTalk Server Party Migration Tool. Party Creation in 2010 is more logical & practical than 2006 R2. New changes are:We have to create a party (Trading Partner) along with a business profile. Business Profile is analogue to the business divisions in an organization where can have multiple. Each business profiles define parameters for B2B messaging like identifiers, Encoding formats, Protocol  settings.

Figure 1In order to do B2B messaging, we have to define agreement(s) between trading partners. This is very easy to use and understand. 

Figure 2

As of Figure 2, once you select the second party (number 3 in the picture)  two more tabs on the dialog (number 6) where you defines the interchange and transaction set settings based on the protocol selected. 

If you have created protocol settings when creating party, y…

BizTalk 2010 Error: Schema referenced by Map ‘<map name>’ has been deleted.

When my BizTalk 2006 R2 applications going to be migrated to BizTalk 2010, I did test run on my test server( BizTalk 2010 on Windows 2008R2 64bit). Then I choose one of simple live-running application to test with, and I got following error in BizTalk administration console.
TITLE: BizTalk Server Administration
Schema referenced by Map 'Map name goes here' has been deleted. The
local, cached version of the BizTalk Server group configuration is out of date.
You must refresh the BizTalk Server group configuration before making further
changes. (Microsoft.BizTalk.Administration.SnapIn)
For help, click:

This is yet another message from BizTalk with no help at all.  I could not be able to refresh whole BizTalk Group\Applications Node in the BizTalk Administration con…

PowerShell Error: the execution of scripts is disabled on this system

When you run powershell scripts (.pl1), in Windows PowerShell console you may received following error. File C:\Projects\Microsoft.Practices.ESB\Source\Samples\Management
Portal\Install\Scripts\Management_Install.ps1 cannot
be loaded because the
execution of scripts is disabled on this system. Please see "get-help
about_signing"for more de
At line:1 char:25
.\Management_Install.ps1 <;;;<<< 1
CategoryInfo :
NotSpecified: (:) [], PSSecurityException
FullyQualifiedErrorId : RuntimeException

To fix this, run following command, in the console

set-executionpolicy unrestricted
On 64bit version of Windows 2008R2, also make sure to set this command for 64bit  PowertShell, which can be found in C:\Windows\SysWOW64\WindowsPowerShell\v1.0 
After you done, it is recommended to revert the setting by using

set-executionpolicy restricted ORset-executionpolicy default

DB2/iSeries .net Driver Post Installation Issue

I have installed DB2/iSeries .net driver on my 32bit(Windows 2003 R2) and 64bit(Windows 2008) production servers, which are having .net ver 3.5 SP1 and ver 4.0 respectively. This is caused to stopped running applications. You will received above error or “Service Unavailable” error message.The reason is, as screen shot showing read/read-execution permission of IIS service account to read machine.config has gone.Set permission for IIS_WPG user as follows,

Visual Studio 2010: Displaying Assembly in “Add Reference” Dialog Box

When you add .net assemblies to the GAC, it is not true they will show in “Add reference” dialog in Visual Studio IDE. I found link which describe the steps that we want to follow.But, it is not working for VS2010. To work with need to set following Reg Key path.HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319\AssemblyFoldersEx\MyAssembly\(Default)= “Assembly Folder path”

Connecting DB2/iSeries From .net Application

I need to connect to a DB2 from a .net application. But it’s  in iSeries system. I did not know what is the way do it. I read lot of articles/blog posts and really helped me. But in this post, I thought to consolidate them for fast reference. There are two .net data providers for DB2.IBM.Data.DB2.iSeries IBM.Data.DB2Both provider follows same rules/guidelines of common components. For an example, both have Connection, Command, DataAdapter, DataReader. But there are differences and limitations.IBM.Data.DB2.iSeriesUsing this provider you can only access to iSeries system. You have to install iSeries Client Access to development machine and/or server. It is quite a bit setup file ( > 3GB with 64Bit version), but we required (refer the bellow screen shots).NET Data Provider Header,Library and Documentation. Figure 1There are limitations/unsupported features [IBM Redbooks 2005 ,Page 38]  in this provider, bellow lists 3 out of 11. User-defined types (UDTs): Although some featu…

Visual Studio Add-Ins not showing in the “Tool” menu

For my developments, I am using VS 2005, VS 2008 and VS 2010 side  by side. I have developed couple of Add-ins (XML Add-Ins) for my own use to ease the development, one can be found in this blog.Last week I installed DB2 connection tool kit( for testing purposes) which installed a VS Add-in (COM Add-in) too. I removed that product from my system, it also removing the Add-ins. My other Add-ins also gone from the “Tool” menu (This happened only to VS 2005 & 2008). But in Add-In Manger I can see them,What I did?I found lots of tips from the Net. All are talking about Registry Entries and devenv command.running devenv /setup


<MyAddIn Name> value

value 2 to 1 failed.
devenv.exe /resetaddin [Namespace].Class
worked. This wont delete any Add-ins from the disk. You have to re-load them from the Add-ins Manger.


Visual Studio Forums

Creating MS SharePoint meeting workspace from MS Outlook 2010

Microsoft SharePoint is tremendous collaboration tool for an organization.  As a software engineer I’m using SharePoint to manage my team, their activities, event customers requirements. In SharePoint, we can manage meeting workspace where we can store relevant documents, agenda, decisions etc. All attendees can share them, hence it is easy to use for later references. Here is the simple steps to create meeting workspace from Outlook 2010.Adding “Meeting Workspace” icon to the Quick Access tool bar of Meeting window. Go to “Calendar” File-> Option & follow the numbered
Setup the meeting request as usually. Click on “Meeting Workspace” icon Now you can see a panel named “Meeting Workspace” on the right hand side of Meeting request window. There,
Select a Location.
Select a type of Meeting workspace. Eg. Basic Meeting Workspace, Blank Meeting Workspace etc. Click on “Link” button and it will embed to meeting workspace link to the email body.
By Default, all invited a…

Movex Class Builder v2.0

I released Movex Class Builder v 2.0 after 2+ yrs from its initial release. New Features:It is showing connected IP and Port. You can change the setting and re-connect the same time. No need to close-and-reopen the Class Builder.

Checking API Layout.
This enable us to check consistency in C# class API layout and current Movex API layout.

By clicking on this option, it will search currently connected API is in opened project, it does show the summary dialog box.

Figure: C# Class and M3 API layout is exactly matched.

Figure: Having conflicts in the code