Wednesday, October 27, 2010

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

Tuesday, October 26, 2010

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

Thursday, October 21, 2010

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 :)