SQL Server 2012 Service Pack install fail

Problem description

Installing SQL Server 2012 Service Pack 3 update, and ran into the following problem:

The install package extracts setup files, flashes a command window, and disappears.  Nothing appears to be installed.  I tried running the package in elevated administrator mode and with the /action=Patch switch – no luck. SQL Server setup log Summary.txt contained no entries at all.

Windows Application event log showed some warnings such as the screenshot below:

NETerror

(.NET Runtime version 2.0.50727.5485 – Error ‘Invalid syntax on line 166’)

Solution

This problem was fixed by running the following command:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\caspol.exe    

-machine   -reset

If you’re using 64-bit framework, run the following command:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727\caspol.exe  

-machine -reset

 

No system reboot was required in my case.

Some thoughts about OneNote…

I am an avid OneNote user.  I’ve been using Microsoft OneNote for several years, and it’s a must-have application for me.  It helps me stay organized amid the chaos of competing priorities, fast-moving projects, and a busy family.   In the meantime Microsoft has been making serious investments into OneNote, making it available across several mobile platforms and integrating it with OneDrive and SharePoint Online.  The OneNote user experience is now quite smooth between mobile and desktop, and the value proposition for OneNote has never been greater.

At the same time, when I look around I see that many individuals and organizations have access to OneNote (it comes preinstalled with several flavors of Microsoft Office and the mobile app is free).   However, they’re not using it to capture notes or organize their information.  They’re not using a competing product, either.  For most people, pen & paper is still the preferred method for taking notes.  Information arriving electronically is captured in email or in folders or documents which makes it difficult to find information and keep it updated.  For many people, things that they know or want to keep are spread across multiple sources and repositories, and it takes a lot of mental effort to find and retrieve information.  Old habits die hard, I suppose…

Our mission here at ITKM Systems is to help our clients capture and organize their informal knowledge assets.  OneNote provides a great platform for accomplishing this goal.  Over the next few months, you will see some new content on this blog related to how to leverage OneNote for best results and achieve maximum productivity. We will be spending more time with OneNote, figuring out the best layouts, the best templates and the best ways to capture, organize, and retrieve your knowledge.

SharePoint Powershell Move-SPSite error: Invalid object name

Attempting to move a SharePoint site using Powershell cmdlet Move-SPSite and getting the following error:

Invalid object name ‘WSS_Content.dbo.AllSites’.

This error occurs because the database schema between the source database and the target database is different.  In my case, the source database was hosted on SQL Server 2008 R2, and the destination database was on SQL Server 2012 SP3.  I solved the problem as follows:

  1. Create a new content database on the source SQL Server.
  2. Use Move-SPSite cmdlet to move your SharePoint site into the new DB.
  3. Using SQL Server Management Studio, back up the new content DB to a file and copy it to the destination SQL Server.
  4. Restore the database on the destination SQL Server.Move-SPSite

Malaysia Airlines flight MH17 tribute

Ok, so this is not going to be a SharePoint or technology-related post..   Two days ago, a Malaysian Airlines flight Mh17 was shot down over eastern Ukraine by pro-Russian rebels.  This strikes close to home for me because I was born in Kyiv, Ukraine, and emigrated to the U.S. in 1991.  I’ve been following the news of the crash (and prior to that, the proxy war that Russian has been waging in eastern Ukraine).    I put together a video tribute to the victims of this awful tragedy – see links below.   As one U.S. intelligence official put it, “Let’s hope that this leads Vladimir Putin to a moment of sanity.”   Our prayers are with the victims and their families..

 

Malaysia Airlines MH17 Tribute

Vimeo (All locations):    https://vimeo.com/101144961

YouTube (Only viewable outside of the U.S.):    https://www.youtube.com/watch?v=sITF8mje0aI

 

 

 

Samurai Jack teaches SharePoint troubleshooting

Check out my little animated YoutTube video on SharePoint troubleshooting:

(Using animated clips from the old Cartoon Network show “Samurai Jack”)

Fixing SharePoint 2010 Configuration Wizard error: WEBCONFIG.ACCSRV.XML, does not have element “configuration/configSections/sectionGroup[@name=’SharePoint’]” or it is invalid

While installing SharePoint 2010 Server Service Pack 2 update (and December 2013 CU), I ran into the following error while executing SharePoint Configuration Wizard:

Exception: System.IO.InvalidDataException: The web configuration file, C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\config\WEBCONFIG.ACCSRV.XML, does not have element “configuration/configSections/sectionGroup[@name=’SharePoint’]” or it is invalid.

My troubleshooting steps:

1. Some online posts suggested removing all comments from the affected web applications. I tried it, but it did not work.

2. Ran psconfig from the command line: psconfig -cmd upgrade -inplace b2b -wait -force

3. Three new errors showed up in the logs:

Error # 1: An exception of type Microsoft.SharePoint.Administration.SPUpdatedConcurrencyException was thrown. Additional exception information: An update conflict has occurred, and you must re-try this action.

Error # 2: Exception: Microsoft.SharePoint.Upgrade.SPUpgradeException: Action 4.0.21.0 of Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence failed. —> System.NullReferenceException: Object reference not set to an instance of an object.

Error # 3: Exception: Action 4.0.21.0 of Microsoft.SharePoint.Upgrade.SPIisWebSiteWssSequence

failed.

4. Error # 1 above was resolved by following the steps from this post: http://www.saintchad.org/sharepoint-psconfig-and-the-dreaded-concurrency-error. Executed this command: stsadm –o setproperty –propertyname command-line-upgrade-running –propertyvalue no

5. Re-ran psconfig command from step 2 above. This time, a new error showed up:

Application Resource Web Config for this IIS site (524709402) could not be found at (path)\wwwroot\wpresources\web.config.

6. It looks like the web.config file for this site is corrupt and needs to be re-created.

7. First, back up the IIS directory in question (including the web.config file).

8. Next, remove the IIS site using Central Admin: Central Admin > Web Application Management > Click on the web application > In the ribbon, click on the “Delete” button drop-down and select “Remove SharePoint from IIS website”. Select the appropriate site in the next dialog and make sure to select “Delete IIS websites”.

9. Re-extend the web application and re-create the IIS site. In CA Web Application management, click on the web application, then click on “Extend” button in the ribbon and fill out the appropriate fields. Click OK.

10. Make sure that the IIS site is accessible and working as expected.

11. Re-run the SharePoint Configuration Wizard (using GUI or command line psconfig).


RSS Information Week Headlines

  • An error has occurred; the feed is probably down. Try again later.

RSS SharePoint Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS InfoPath Team Blog

  • An error has occurred; the feed is probably down. Try again later.

RSS Susan Hanley’s KM Blog

  • An error has occurred; the feed is probably down. Try again later.

Blog Stats

  • 336,167 hits