Sync Framework error at SyncOrchestrator.Synchronize()

You may hit the following error when you SyncOrchestrator.Synchronize() method

Retrieving the COM class factory for component with CLSID {EC413D66-6221-4EBB-AC55-4900FB321011} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0×80040154 (REGDB_E_CLASSNOTREG)).

This is because you are running on 64bit Windows but your assembly is in 32bit mode. To change to, just switch to Configuration Manager and add x64 platform to your solution platform.

ScreenClip

ScreenClip[1]

Troubleshooting SQLDependency

SQLDependency API in SQL Server allows application to get notified via Service Broker when there are changes happened on selected table(s ). You can find out more from this MSDN article.

But working from home today, I realize SQLDependency never fires the notification back to my application. I found out how to troubleshot this from a forum threat here.

So I queried my database using this command select * from sys.transmission_queue and I got the follow result

An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user ‘IPS\patrick’, error code 0x54b.

I suspect Service Broker requires access to the Domain Controller, so I try to login to my VPN and try again… and boolah!! It works!!

A friendly reminder from Microsoft Online Services

I used my company’s MSDN subscription to sign up for Windows Azure’s MSDN offer. Basically I was allocated 750 hours of extra small compute for the first 6 months of my sign up. Even now that the offer is over, and I am paying the full price whenever I use Azure, Microsoft Online Service (which manages the billing) still send me a reminder of my so called exceed usage. Smile Below is a screen clip taken from my email client.

azureover

What all this means is if you accidentally exceeded your usage, you have better delete your instance if it is only used for testing. Do not shutdown the instance below it will still incur charges.

How to try out Windows Azure at minimal cost?

There are a couple of way for you to try out Windows Azure with almost ZERO cost. Microsoft gives out offers and trial account with certain resources allocation. Below are your options

1. Windows Azure 90 day trial (http://www.microsoft.com/windowsazure/free-trial/)

You will be allocation the following monthly resources for up to 30 months

Compute: 750 hours of a Small Compute Instance
Storage: 20GB with 50k Storage transactions
Data Transfers: 20GB out / Unlimited inbound data transfer
Relational Database: 1G Web Edition SQL Azure database
Access Control: 100,000 transactions
Service Bus: 2 connections
AppFabric Caching: 128MB cache**

2. If you have MSDN subscription, it comes with allocation of Windows Azure resources based on your subscription model with savings of up to USD3,500. Check out this website for more information http://www.microsoft.com/windowsazure/msdn-benefits/

3. When you sign up for Windows Azure training at any Microsoft certified training centres, you will be given free Windows Azure access for a certain number of days.

4. 30 day Windows Azure pass (http://windowsazurepass.com/) is the special promo where you get access to Windows Azure for 1 month without even using your credit card (refer below). However, you have have exceeded your allocations, your application will ceased to function as there is no way Microsoft can charge you. This is a special pass where is it only available at certain Microsoft’s events or occasions. The promo code can only be used once and it is tied to your Windows Live (aka Hotmail) ID.

Options 1 to 2 requires your card info so you will be billed when you exceeded your allocations. So you have to be cautioned especially on the bandwidth usages.