MIgration to Azure - Part 1

Hi All,
I got chance to work on Azure very recently, and the work of course was related to migration. Keeping it short I will try to explain the problems and challenges I faced in this process –


Getting Startup, reading material and understanding –

• VS 2010 gives option for creating cloud app. Two things to mention for new bee –

• Worker role and Web Role [Web role is nothing but your asp.net application]

• The Azure project has webrole.cs which is responsible for executing the application.

• Start keeping break points from application_Start [that will give clear understanding of flow]

After first Hello world and understanding the flow, now comes how migration should go , most common scenario is to have SQl Azure as well [a separate license]

Open http://windows.azure.com, click SQL Azure create your DB with help of script. There are no wizards till now.

• Once DB created, it is better to create simple application to access database programmatically. Few things here –

• To Access DB programmatically in your SQL Azure DB, click the Tab “Firewall Settings” and add Ip of your computer, so Azure will bypass that.

Also install Microsoft Firewall Client [I do not know exactly why this is needed but this happened in my case]

I am not providing any code snippet for the same as material is very easily and widely available on net.

Now it is time for real work  Post-2

SqlAzure DataSynch,Message = "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: 0x80040154 (REGDB_E_CLASSNOTREG))."

Check in the build properties of project the target should be x64 not x86.

ExcelService - RangeCoordinate

small discription about range coordinat, cause I was pretty confused while using it, so sharing my exp
RangeCoordinates rngCrd = new RangeCoordinates();


rngCrd.Row = 0;


rngCrd.Column = 0;

rngCrd.Height = 3;

rngCrd.Width = 10;
 
.Row = start Row
.Column = start column
.Height = no of rows. in this case total three rows.
.Width = no of columns, total ten columns.
 
So the above line mean, range starting from 0th row,0th column and ending at 10th column of 3rd row.
 
Happy coding

ExcelService, You donot have permission to open this file

Hi All,

I was getting this error from 3-4 days, and it was becoming frustrating, since the error is resolved I want to share my experience with all of you. The error from ULS log is-

1.       From ULS log the error is -            w3wp.exe (0x1EC0)                       0x21B4  SharePoint Server                           Logging Correlation Data               xmnv     Medium               Result=Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. ---> Microsoft.Office.Excel.Server.Host.HostFileException     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity)     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.b__2()     at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)

• In my case ClaimsToWindows was set correctly,
• file  was under trusted file location
• App Pool account was added as owner in comtentDB

So nothing was helping me. Lastly I run the configwizard, which ended up in running farm config wizard (I did farm config earlier, noting helped). I cross varified web.config and what helped is -

IIS authentication settings :) The site and sharePoint web services both should run with "Windows Authentication" and it was resolved.
Some times we miss very simple point and that hurts badly :)

Keep programmig...

Operations started by an earlier run of the Farm Configuration Wizard are still in progress

 "Operations started by an earlier run of the Farm Configuration Wizard are still in progress. You must wait for those operations to complete before running the wizard again. You can monitor the status of these operations by looking at the "Farm Configuration Wizard" timer job on the Timer Job Status page in the Monitoring section of Central Administration"

Was the error and unable to run "farm configuration wizard". after some lookups I got TimerJob Status and job named "Farm configuration wizard" which was disabled, so deleted that and I got the option to re-run it again :)
cheers