Dave's Technophorical Times

A blog about Microsoft's Technologies!
SharePoint :: MVC :: ASP.NET :: IIS :: SQL Server :: Visual Studio :: MS Access
If you have installed IE10 and you are running Visual Studio 2010, you may get this annoying pop-up.
"Attached the Script debugger to process '[1111] iexplore.exe' on machine 'MINE' failed. A debugger is already attached."
There is a simpler fix for the JavaScript debugging issue in IE10:
  1. Close IE
  2. In elevated cmd prompt run this command:

regsvr32.exe "%ProgramFiles(x86)%\Common Files\Microsoft Shared\VS7Debug\msdbg2.dll

or %ProogramFiles% on a 32-bit OS.

Hope this helps!

Problem: In SharePoint 2010, I created a new site template from an existing site and a new site using this template. After deleting the new site and I cannot deactivate the site template to be able to remove it. Here's the exception I get:
System.ArgumentException: Value does not fall within the expected range. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Stack Trace: [ArgumentException: Value does not fall within the expected range.] Microsoft.SharePoint.SPWebCollection.get_Item(Guid id) +27763375 Microsoft.SharePoint.SPFeatureEnumeratorBase.GetCachedWeb(SPSite site, Guid webId, Guid featureId) +252 [SPFeatureIsOrphanedException: Unable to access web scoped feature (Id: 5c143ca0-e513-4fa5-93a6-a926352c982e) because it references a non-existent or broken web (Id: 196cdf6e-d4a1-4cb6-b962-591aaa3c5f43) on site 'http://win-9o8m2cks1v7'. Exception: System.ArgumentException: Value does not fall within the expected range. at Microsoft.SharePoint.SPWebCollection.get_Item(Guid id)
Solution: Go to the Site Settings page for the root web of your site collection. Under the heading Site Collection Administration, click the Recycle bin link. On the QuickLaunch menu, select End User Recycle Bin items, then select all the items that appear and click the Delete Selection link at the top of the items list. Now select Deleted From End User Recycle Bin from the QuickLaunch Menu and do the same.
Now return to the solution gallery and you should be able to deactivate and delete your solution.

How to attach multiple files to a single list item, such as a Task List. Most people know about the “Upload Multiple Documents” option in document libraries. This option isn’t there with list items.

What you can do is attach files individually. You can keep attaching as many files as you like.

  1. Click Attach File from the ribbon
  2. Select first file you want attached
  3. Repeat

The files will now be listed in the “Attachment” section of your list item properties.

If you need to debug a WCF Server, or somehow need to step into code on IIS, you will need to do the following to prevent the message  “Unable to automatically step into the server. Unable to determine a stopping location”. The message might be slightly different but generally it means you can't debug in IIS!

It turns out that Visual Studio 2010 comes with a default setting to debug ‘Just my code’.

To correct the problem, go to Tools – Options – Debugging – General and switch off the option ‘enable just my code’.  

And of course don’t forget to set debug="true" in the web.config file of the webservice. Double check your publishing Transformations too if using any, as that might be removing the debug="true" property in your web.Config file.

This will hopefully help someone else out there!

If you need to display the current Year as the default value for a Choice column in a SharePoint List/Library then you can do so by using =TEXT(Today,"YYYY") in the Default Value box, after selecting "Calculated Value".


If your Search Engine crawl is not returning any "Content" results from a Full Crawl, i.e. pdf, docx files are not being returned then you probably need to register the mssph.dll file. Note that PDF content searching will require Adobe iFilter.


regsvr32 "C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN\mssph.dll"

Try Full crawl and it should work.


By default, SQL Developer does not display the Time with the date for date columns when running a select statement.

You can change this in the Tools / Preferences dialog of SQL developer:

  1. Select Database / NLS Parameters in the tree view on the left.

  2. Then put dd/mm/yyyy hh24:mi:ss into the Date Format field.

  3. Press OK to close the dialog.


A newly created BCS error shows “There are no addresses available for this application”



  1. You have started the “Business Data Connectivity Service” from Application Management > Manage Services on Server
  2. Perform an iisreset


PowerGUI does not work when running SharePoint Scripts because by default the FOUR Config files have the Run times and reverse Order.

This is the default!


Switch them around like this and your SharePoint Scripts will now work.
You will need to open them in NotePad running as Administrator!



Hope this saves the day for someone.

The message can be ignored, or can it? http://technet.microsoft.com/en-gb/library/hh344223.aspx. It only states since if you use an account in local admin group it gives that account the right to execute malicious codes without even prompting to execute.

Add the farm account into the local administrators group. This is stated in the TechNet article:http://technet.microsoft.com/en-us/library/ee721049.aspx

"The Server Farm account, which is created during the SharePoint farm setup, must also be a member of the Administrators group on the server where the User Profile Synchronization service is deployed."

There seems to be some conflicting opinions about the correct permissions, as this will cause the SharePoint Health Analyzer to create a warning:

"Accounts used by application pools or service identities are in the local machine Administrators group. Using highly-privileged accounts as application pool or as service identities poses a security risk to the farm, and could allow malicious code to execute."

Also grant the Replicate Directory Changes [http://support.microsoft.com/kb/303972] permission for the farm account. Reboot the server to make sure that all the services using the farm account run with the new privileges.

Make this a point for site app pools:
As a SharePoint best practice, please refrain from using built-in machine administrator account for any SharePoint site app pools (services, application pools).

From the article on technet: http://technet.microsoft.com/en-us/library/cc678863(office.12).aspx (though the article is for MOSS 2007, it is still relevant)

The other application pool account must be a domain user account. This account must not be a member of the administrators group on any computer in the server farm.

The Blogger

Dave Stuart I'm a Developer with a passion for coding. I enjoy the challengers that come with the job! SharePoint is one of my expert areas along with .NET Web Development with MVC and good old MS Access VBA coding. I Blog so that I can remember how I did that way back when; PLUS all this stuff is searchable! I constantly study and run my own business, Dafran Inc. I have passed 22 Microsoft Exams since 1998 when I first jumped on the treadmill of knowledge. I hope that you enjoy this Blog as much as I enjoy updating it. All the very best from Calgary, Alberta, Canada. contact me at linkedin @ dafran.ca


<<  April 2020  >>

View posts in large calendar

Sign in