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)

Background

Yesterday, my ASP.net applications were migrated to Windows 2008 R2 (64bit).

All applications configurations are,

1. Developed using .NET v 2.0 & 3.5
2. Using 32bit COM/wrapper for ERP access
3. Windows Authentication

Without recompiling, applications were migrated to IIS 7.5. Actions taken on IIS for above 3 are, respectively,

1. Used “Classic .NET AppPool”
2. Set “Enable 32-Bit Applications”
   
3. Enabled Windows Authentication
    

Problem

All 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.

Solution

After 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 KB

Method 2: Disable the loopback check (less-recommended method)

The second method is to disable the loopback check by setting the DisableLoopbackCheck registry key.
To set the DisableLoopbackCheck registry key, follow these steps:

1. Set the DisableStrictNameChecking registry entry to 1. For more information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

   281308 (http://support.microsoft.com/kb/281308/ ) Connecting to SMB share on a Windows 2000-based computer or a Windows Server 2003-based computer may not work with an alias name

2. Click Start, click Run, type regedit, and then click OK.
3. In Registry Editor, locate and then click the following registry key:

   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

4. Right-click Lsa, point to New, and then click DWORD Value.
5. Type DisableLoopbackCheck, and then press ENTER.
6. Right-click DisableLoopbackCheck, and then click Modify.
7. In the Value data box, type 1, and then click OK.
8. Quit Registry Editor, and then restart your computer.

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:

1. 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 1
2. In 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, you can select them or leave      –None- to override them. (number 5)

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: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc=Microsoft.BizTalk.ExplorerOM.Resources&EvtID=IDS_ERR_FIND_SCHEMA 

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 console. I spent couple of hours ,while scratching my head, to find a solution.

Solutions like, restarting BizTalk service, Administration console, etc did not work. But I found solution (not my own) which is really works though it is not recommended.

The solution is SQL,

   1:  

   2: -- Run bellow queries against BizTalkMgmtDb database.

   3: -- You can find the related item here

   4: SELECT * FROM bt_mapspec

   5: -- Replace with correct itemid value

   6: DELETE FROM bt_mapspec WHERE itemid =165 

Reason:

One of blog post suggests, it could be the reason when the Map and references Schemas are in separate assemblies. I can agree with it, i believe , in this application the map and its source schema in two separate assemblies.

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
tails.
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

        OR

set-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 ASP.net 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 http://support.microsoft.com/kb/306149 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”