RSS Feed
LinkedIn
Delicious
Skip to main content

Cornelius J. van Dyk's SharePoint Brain Dump

Rate this blog:
Go Search
Home
Step-by-Step Guides
Downloads
Post Archive
Capacity Planning
Architecture & Topology
Support Forums
SharePoint Team Blog
  

 Important Posts

  Complete MOSS Licensing Info
  SharePoint Speak Terminology Dictionary
  SPCAP - SharePoint Capacity Planning Tool
  Step-by-Step – A REAL world upgrade of a SharePoint Portal Server 2003 (SPS) farm to Microsoft Office SharePoint Server 2007 (MOSS)
  Best Practice - Determine if a SPUser has Admin rights to the SPWeb
  SharePoint 2010 - Good, Better, Best
Cornelius J. van Dyk's SharePoint Brain Dump > Posts > Step-by-Step – A REAL world upgrade of a SharePoint Portal Server 2003 (SPS) farm to Microsoft Office SharePoint Server 2007 (MOSS)
Step-by-Step – A REAL world upgrade of a SharePoint Portal Server 2003 (SPS) farm to Microsoft Office SharePoint Server 2007 (MOSS)

Well I've been catching up on my To Do list this morning. One of my items is this MONSTER post that I've been working on… it seems forever! Anyway, it is finally completed and scrubbed and I hope it provides some useful information for you…

This Step-by-Step guide will detail my journey through the upgrade wilderness and will hopefully help you migrate your SharePoint Portal Server 2003 medium farm to Microsoft Office SharePoint Server 2007. I have intentionally documented mistakes that I made and ran into to allow this guide to also help you trouble shoot some of the most commons issues you could expect to run into. By documenting my pain, I'm hoping to save you some pain.

At the time I struggled through this migration, there was hardly any documentation around it. Microsoft has done a good job since then of creating good documentation to assist in these processes. When deploying a server farm, be sure to read this TechNet Article first:
http://technet2.microsoft.com/Office/en-us/library/356d3a0b-fc26-455c-9afb-6d2ffdceef841033.mspx?mfr=true

When adding servers to a farm, be sure to read this TechNet article:
http://technet2.microsoft.com/Office/en-us/library/b4279ff9-2842-475a-8d7f-cc90711c47271033.mspx?mfr=true

Before we commence, it is important to note the configuration of the SPS 2003 farm. I'm going to be using a farm together with Kerberos authentication because in the REAL WORLD most configurations are that way, not the single server/NTLM configurations that most documentation and demos use and show you.

Please note that this guide is MASSIVE to say the least. It over 7000 words long and contains almost a 100 screen shots so it's going to take you a while to get through this. You may want to download it for future reference from the Downloads section. Now grab your coffee, fire up your remote desktops and let's get going. J

The farm is configured as follows:

  • SPWEB
    • Windows Server 2003 SP1.
    • SharePoint Portal Server 2003 SP1.
    • Windows SharePoint Services 2.0 SP1.
    • SharePoint Web/Search server roles.
  • SPJOB
    • Windows Server 2003 SP1.
    • SharePoint Portal Server 2003 SP1.
    • Windows SharePoint Services 2.0 SP1.
    • SharePoint Job/Index server roles.
  • SPSQL
    • Windows Server 2003 SP1.
    • SQL Server 2000 SP4.
    • SharePoint database store.

* IT IS IMPORTANT TO NOTE THAT YOU HAVE TO SIGN ONTO THE SHAREPOINT SERVERS WITH THE SERVICE ACCOUNT THAT HAS ADMIN RIGHTS THROUGHOUT THE FARM, INCLUDING THE SQL SERVER.

You may need to add the account to the local administrators group in order to logon using the account.
If we take a look at the portal BEFORE the upgrade, we see the following:

We are now ready to commence the upgrade by following these steps:

  1. If your portal is not yet upgraded to SP2:
    1. Upgrade WSS to SP2.
      1. Download the Windows SharePoint Services 2.0 Service Pack 2.
      2. Begin by double clicking the "WSS2003SP2-KB887624-FullFile-ENU.exe" file.
      3. Setup will prompt you to confirm that you wish to install the update.

      4. Click "Yes" to proceed.
      5. You will now be presented with the End User License Agreement.

      6. Click "Yes" to accept the EULA.
      7. Setup will now unpack the installation files.

      8. Once Setup is complete, you will be prompted to restart the server.

      9. Click "Yes" to restart the server.
    2. Upgrade SPS to SP2.
      1. Begin by double clicking the SPS2003SP2-kb887623-fullfile-ENU.exe file.
      2. You will be presented with the End User License Agreement. Click "Yes" to accept the EULA and proceed.

      3. Setup will now unpack the installation files and proceed with the installation.

      4. You will receive a prompt to configure error reporting. Decide which option is best for you and click the appropriate button.

      5. Setup will NOT notify you of the need to restart your server, but believe me, IT IS NEEDED! So go ahead and reboot your server one more time.

        Congratulations! You have completed your portal web server upgrade to Service Pack 2.

        REPEAT STEP 1 ON YOUR SPJOB SERVER.

        Once your job server has been upgraded to SP2, you can proceed with the MOSS installation.

  2. The prerequisite for installing MOSS is the .NET Framework 3.0. Download it here. If you need the full download versions, you can get the x86 version or the x64 version depending on your platform.
    1. Double click the "dotnetfx3setup.exe" file.
    2. Setup will unpack the installation files.

    3. Once all the files have been extracted, you will be presented with the .NET Framework 3.0 End User License Agreement.
    4. Ensure you've read the agreement and agree with its terms.
    5. Select the "I have read and ACCEPT the terms of the License Agreement" radio button.
    6. You can also check the "Send anonymous information about my setup experiences to Microsoft Corporation" check box if you wish to do so, but it is not required to continue.
    7. The "Install" button should now be enabled.
    8. Click the "Install" button.

    9. Setup will now minimize to the system tray and conduct a background installation. You can double click the icon if you wish to see more detailed installation status.

    10. Setup will proceed to download the remaining components of the installation package.

    11. After the download is complete, Setup will commence the actual installation.

    12. Once Setup completes the installation, you'll be presented with the final status screen.
    13. Click "Exit" to complete the installation.

    14. You will need to restart your system for the new framework to take effect.
    15. If you don't have any other applications open, click "Restart Now" or otherwise, click "Restart Later" and manually shut down your application and restart your system.

      REPEAT STEP 2 ON YOUR SPJOB SERVER.

  3. Now proceed with the main MOSS installation.
    1. Launch MOSS from either the CD or the folder location where the installation files was copied by double clicking the "setup.cmd" file.

    2. The file, being a DOS command file will open a black command window as it processes in the background prior to launching Setup.

    3. Once Setup launches correctly, you will be presented with the Product Key screen.
    4. Enter your 25 character product key.
    5. A green check mark should appear behind the product key indicating a valid key.
    6. Click "Continue".

    7. You will be presented with the End User License Agreement screen.
    8. Ensure you are familiar with the contents of the EULA.
    9. Click to check the "I accept the terms of this agreement" check box.
    10. Click "Continue".

    11. You are now presented with upgrade options.
    12. On the "Upgrade" tab, select the "Yes, perform a Gradual upgrade" option.

    13. Click on the "Server Type" tab or press Alt+T to activate the server type tab.

    14. By default the "Complete – Install all components…" option is selected. If it is not selected, select it now.
    15. Click on the "File Location" tab or press Alt+F to select it.

    16. Depending on your server configuration, you may have to changes these settings. In our case, we have a small OS drive C:\ and then the main data drive as D:\, so we change our application and file location as well as our index file location to the D:\ drive maintaining the same path.
    17. It is important to note that the index files generally are about 150% the size of the SQL database files they represent so if your SQL data files are 10 GB in size, then you would want to ensure that the index file location has at least 15 GB free space in order to hold all the data. This figure varies with content types for example if you're storing a bunch of binaries or video files, there generally isn't that much to index besides properties and name so your index size would be considerably smaller. Our figures are just used as a safe guidance rather than a rule.
    18. Click the "Install Now" button.
    19. Installation will begin and Setup will provide you with feedback related to installation progress.

    20. Once the installation is complete, you will be notified.

    21. IMPORTANT NOTE: UN-check the "Run the SharePoint Products and Technologies Configuration Wizard now" check box option.

      The reason we do NOT run the wizard directly after installation is because part of the upgrade wizard's prerequisites is that PRESCAN must have been run on our environment. Because PRESCAN is only dropped onto our server by Setup, it stands to reason that we cannot have run it before now.

    22. Click the "Close" button to close Setup. Don't worry, we'll get back to the Config Wizard soon enough.

      REPEAT STEP 3 ON YOUR SPJOB SERVER.

  4. We can now proceed with the MOSS configuration.
    1. Conduct a PreScan.
      1. Locate the "prescan.exe" application. The default installation location for this file is in the "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN" folder. NOTE: This is NOT the program file installation location you specified earlier. This is the location of the WSS services which is almost always installed to this folder location. In our example, we installed the program and data files to the D:\ drive, but the PreScan tool is still installed to the C:\ drive.

      2. You should also see the "preupgradescanconfig.xml" file listed with the "prescan.exe" file.
      3. Open a command window.
      4. Navigate to the source location for PreScan. The easy way to do this is to copy the Address URI from Windows Explorer, excluding the "C:\" part, and then in the command window after confirming that the prompt is on the same drive as the URI and typing "cd\", right click in the command window and select "Paste" from the popup window. Saves a LOT of typing. Alternatively you could use "cd\pro*\com*\mic*\web s*\12\bin". It might also be a good idea to add this path into your command prompt default path for the future because you're going to spend a LOT of time in this folder using the likes of STSADM.exe etc.
      5. Enter the "prescan /c preupgradescanconfig.xml /all" command.

      6. PreScan will provide progress indicators, rudimentary indicators but indicators nonetheless.
      7. If you have a customized portal solution, or anything but a blank standard portal installation for that matter, odds are you will run into this.

      8. As you can see, PreScan failed.
      9. Note the names of the files that PreScan had written.
      10. Navigate to the folder location PreScan had noted.

      11. Locate the files in question.
      12. The Summary XML file will contain an inventory of sites in the portal. This list is very useful when you're putting together a communication plan for the migration of sites as it will identify unghosted pages. Sites that contain unghosted pages will not migrate and automatically inherit the cool new features of Office SharePoint Server 2007 and Windows SharePoint Services 3.0. Instead these sites will need to be reverted back to template in order to accomplish this and this fact need to be communicated to your users. Failure to do so is a recipe for disaster and aversion to adoption of the new platform so PLEASE communicate, communicate, communicate!

      13. Opening the Log text file however is the one we're interested in as it contains the listing of sites that caused errors during PreScan.

      14. In our example, you can see that the test5 site is using a template that could not be located on the server. In most cases you will be doing this as a dry run on staging servers with production backups for data so errors like this is possible. In this case, we debug the issue by opening a browser and navigating to the site in question.

      15. As you can see, we simply got an error on the site.
      16. You can navigate to the original site as well to see what the template looks like. In our example, the original master site turned out to be a Business Scorecards Accelerator (BSA) site. We had not installed BSA on the staging server thus the error occurred during PreScan. Remedy the situation by installing the BSA into the staging server and rerunning PreScan.
      17. Another alternative is to do some cleanup throughout this process. We saw that the site called "test5" had very little on it, in fact, it is safe to say the site had never been used. Being a test site, it is probably OK for us to delete the site. You can delete the site by navigating to the parent site's Sites and Workspaces page. Remember to check with the site owner before proceeding with this course of action.

      18. Remove the site by clicking the Delete link, but ONLY if you are ABSOLUTELY sure the site is not in use anymore. Remember to contact the Site owner!
      19. When you scroll to the bottom of the log file you will notice a summary of site collections that experienced problems during PreScan.

      20. In our example, the Test5 was under the /ED site collection and as such /ED is listed as a problem.
      21. It should be obvious why the SocrecardDevelopment site collection was listed as well.
      22. Looking at the original site it's clear it's a BSA site.

      23. The log file also provides some useful summary stats derived from PreScan.

      24. As you can see, it notes the number of site collections, the number of web sites, the number of custom templates and the number of unghosted pages. These are all important to note as each will have some effect on your upgrade process. Unghosted sites will need to be reverted back to template. It is a manual process and knowing how many sites will need to be addressed helps in the planning of the upgrade.
      25. Correct all the issues at hand and rerun the PreScan tool.

      26. This time around, provided all issues were addressed, the PreScan should complete successfully.

    2. Execute the configuration tool to configure MOSS.
      1. Using the "Start/All Programs/Microsoft Office Server/SharePoint Products and Technologies Configuration" option, restart the Config Wizard.

      2. You will be presented with the Config Wizard Welcome Screen.

      3. Click the "Next" button to continue.
      4. You will receive a services reset warning dialog that warns you about the need to restart certain services such as IIS and some SharePoint services.

      5. Click the "Yes" button to confirm and proceed.
      6. You will receive a Language Pack warning message that states the need to install additional language packs at this point. If you do indeed need to install more language packs, this is the time to do so. You can download the following language packs.
        1. MOSS 2007 Language Pack for X86.
        2. MOSS 2007 Language Pack for X64.
        3. WSS 3.0 Language Pack for X86.
        4.  

      7. For more information on deploying the language packs, see the TechNet site.
      8. Leave the dialog window open and conduct your language pack installations.

      9. Once all language packs have been installed, click the "OK" button to proceed.
      10. You will be presented with the Server Farm Connection screen.

      11. VERY IMPORTANT! Select the "No, I want to create a new server farm" option NOT the "Yes, I want to connect to an existing server farm" option if this is your SPWEB server cycle. This is a very confusing option because you already have a server farm and instinctively you would want to just add to the farm as opposed to creating a new. To clarify, we're not doing anything with the old farm which is why we need to create an entirely new farm.
      12. Click the "Next" button to continue.
      13. Next you will be presented with the Database Settings page.

      14. Enter the name of your SQL Server into the "Database Server" edit box e.g. "SPSQL".
      15. By default the Config Wizard will have populated the "Database Name" edit box with "SharePoint_Config". You can change this value if you want or you can simply accept the default setting. It is recommended that your retain the "Config" moniker in the name though as it will help you identify your database later on during administration and backups.
      16. By default the Config Wizard will enter the domain service account in the "Username" edit box. This is the same account that is used as the service account for our existing farm i.e. the account that has "Security Administrator" and "Database Creator" roles on the SQL Server and it should also be the same account we're logged into the server with. Ensure that the account is entered as DOMAIN\USER. If you only enter the USER portion of the account name, it will automatically try and authenticate as a local user i.e. SERVER.DOMAIN\USER.
      17. Enter the password for the service account in the "Password" edit box.
      18. Click the "Next" button to continue.
      19. In my case, we got the following error dialog window. If you do not get an error, simply skip ahead to step xxiv:

      20. After locating the log file and opening it, we searched for the "ERR" code and found the following. I have highlighted the important parts in RED:

04/06/2007 14:13:08 1 ERR A System.Data.SqlClient.SqlException was thrown on server <WEB SERVER NAME REMOVED>, database <CONFIG DATABASE NAME REMOVED>

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Entering function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Resource id to be retrieved is ExceptionInfo for language English (United States)

04/06/2007 14:13:08 1 INF Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

04/06/2007 14:13:08 1 INF Leaving function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 ERR An exception of type System.Data.SqlClient.SqlException was thrown. Additional exception information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Microsoft.SharePoint.PostSetupConfiguration.SqlSession.OpenConnection()

at Microsoft.SharePoint.PostSetupConfiguration.SqlSession.ExecuteNonQuery(SqlCommand command)

at Microsoft.SharePoint.PostSetupConfiguration.SqlServerHelper.DatabaseExists(String database)

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)

04/06/2007 14:13:08 1 INF Entering function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Resource id to be retrieved is SqlServerOrDatabaseConnectionFailure for language English (United States)

04/06/2007 14:13:08 1 INF Resource retrieved id SqlServerOrDatabaseConnectionFailure is Failed to connect to the {0} or the {1} does not exist. Ensure the {2} exists, is a Sql server, and that you have the appropriate permissions to access the {3}. To diagnose the problem, review the extended error information located at {4}. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.

04/06/2007 14:13:08 1 INF Leaving function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 ERR Task configdb validation threw an exception

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Entering function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Resource id to be retrieved is ExceptionInfo for language English (United States)

04/06/2007 14:13:08 1 INF Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

04/06/2007 14:13:08 1 INF Leaving function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 ERR An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_4_6_2007_14_6_34_544_1523969351.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.

Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureConfigurationDatabaseConnection()

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Validate(Int32 nextExecutionOrder)

at Microsoft.SharePoint.PostSetupConfiguration.TasksQueue.Validate(Boolean useDefaultExecutionOrder)

04/06/2007 14:13:08 1 ERR A PostSetupConfigurationTaskException was thrown: Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_4_6_2007_14_6_34_544_1523969351.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 INF Entering function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Entering function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Resource id to be retrieved is ExceptionInfo for language English (United States)

04/06/2007 14:13:08 1 INF Resource retrieved id ExceptionInfo is An exception of type {0} was thrown. Additional exception information: {1}

04/06/2007 14:13:08 1 INF Leaving function StringResourceManager.GetResourceString

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionMessage

04/06/2007 14:13:08 1 INF Leaving function Common.BuildExceptionInformation

04/06/2007 14:13:08 1 ERR An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: Failed to connect to the database server or the database name does not exist. Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server. To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_4_6_2007_14_6_34_544_1523969351.log. Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.

Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureConfigurationDatabaseConnection()

at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Validate(Int32 nextExecutionOrder)

at Microsoft.SharePoint.PostSetupConfiguration.TasksQueue.Validate(Boolean useDefaultExecutionOrder)

at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.ValidateConfigurationData()

at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.TryValidateConfigurationData()

 

  1. At first I thought it was a SQL Named Pipes issue, but once I looked a little closer at the error, I noticed that the server name was that of the WEB server and not the SQL server. Let's take a look at the screen information used again.

  2. As you can see, I incorrectly entered the SPWEB server name instead of the SPSQL server name.
  3. Correct the error and click the "Next" button again.
  4. Next you will be presented with the Admin Web App screen. This is one of the new things to SharePoint administration that I'm very happy and excited about. In SharePoint 2003 you had to manually go and change the Central Admin web's port from the server command line using STSADM. I don't know how many of you had ever tried that, but it's painful to say the least… not because it's hard to type a command in the command window, but because the IIS web isn't similarly updated which means you had to go into IIS and change the port assignment manually in there as well. With SharePoint 2007, that problem is no more… unless you forget to do the next step.

  5. The Config Wizard will automatically assign a port for the Central Admin application, but I find it easier to specify the port number. That way it makes remote administration much easier. It also standardizes your administration of different servers if your admin port is consistent so:
    1. Check the "Specify port number" check box.
    2. The Edit box should become white and editable.
    3. Change the edit box value to a common value you want to use.
  6. The Config Wizard will default to NTLM authentication and here is where I have a real problem with MOST of the demo's and documentation out there. Most administrators worth their salt will be using Kerberos thus in the REAL WORLD you'll find Kerberos being the standard option, but most demos do NOT show that and most speakers and authors will simply select NTLM. Kerberos is the better option and with this version, also the recommended route to take. Select the "Negotiate (Kerberos)" option. NOTE: The system administrator will have had to configure Kerberos beforehand so ensure this was done prior to following these steps. For help in the Kerberos configuration process, please see this KB article: http://support.microsoft.com/kb/832769
  7. Click the "Next" button to continue.
  8. You will receive a Kerberos warning dialog window.

  9. Click the "Yes" button to continue.
  10. You will be presented with the Settings Review page.

  11. Click the "Next" button to continue.
  12. The Config Wizard will now configure MOSS on your server, create the new farm database etc. You will be presented with visual feedback related to progress.

  13. Once the Config Wizard completes its configuration of SharePoint, you will be presented with the success page.

  14. Click the "Finish" button to complete the Config Wizard.
  15. The Config Wizard will close and an IE browser pointing to the SharePoint Central Administration page will open. Because the site is not currently defined in any of IE's trusted zones, you will be prompted to logon.

  16. Due to the content on the SharePoint site, IE will popup a security warning.

  17. Click the "Add" button.
  18. You will be presented with the Add Sites dialog window.

  19. IE will automatically populate the server name in the edit box.
  20. Click the "Add" button to add the site to the Trusted Sites zone.
  21. Click the "Close" button to continue.
  22. The main Central Admin page will load.

  23. You will notice the SPJOB server listed in the Farm Topology as "Not Configured". It is now time to configure the SPJOB server.
  24. The natural instinct is to go ahead and repeat the configuration process from step 4.b.i. above on the the SPJOB server, but this time instead of creating a new server farm, connecting to an existing server farm. Unfortunately, this will not work as you would expect. I'm going to detail the steps I followed and explain the issue that I encountered for educational and informational purposes, but if you're just interested in continuing your setup, skip the following section completely.

     

    NOTE: Do NOT follow the next 12 steps! This is detailed for information only! Continue again at step xlv.

     

    1. Continuing in the tradition of repeating steps done on the SPWEB server on the SPJOB server as well (this also includes multiple SPWEB servers), I started by repeating steps 4.b.i. through 4.b.ix on the SPJOB server.
    2. When I got to the "Connect to a server farm" screen, instead of selecting "No, I want to create a new server farm", I selected the "Yes, I want to connect to an existing server farm" option because we had already created the server farm when we ran the config wizard on the SPWEB server.

    3. Click the "Next" button to continue.
    4. You will be taken to the Database Settings page.

    5. This time, the page will look a little different in that there will an additional control. The "Retrieve Database Names" button, just to the right of the "Database server" edit box. The "Retrieve Database Names" button will be disabled though. The "Database name" control is also a dropdown list instead of an edit box.
    6. Enter the name of the database server into the "Database server" edit box e.g. "SPSQL".
    7. The "Retrieve Database Names" button will now become enabled. Click it.
    8. The Config Wizard will retrieve the name of the database you used to create the original farm and populate it in the "Database name" dropdown list. If you kept the default database name during the SPWEB configuration phase, this value should now be "SharePoint_Config". If you have multiple configuration databases from multiple farms, select the correct database name that was used during the SPWEB configuration phase from the "Database name" dropdown list.
    9. The Config Wizard will also populate the "Username" edit box with the content account by default. If you want to configure a different user account for the SPJOB server you can change this value now.
    10. Enter the password for the account you're going to use into the "Password" edit box.
    11. Click the "Next" button to continue.
    12. One would expect that executing steps 4.b.xxiv. through 4.b.xlii. above on SPJOB would yield the results one requires, but it does not.

      Starting with step 4.b.xxiv. there is a major flaw in the config wizard. The problem is that it does not consider multiple servers. What I mean by that is that if you do execute steps 4.b.xxiv. through 4.b.xlii. you will end up with the Config Wizard overriding your existing Central Admin application settings. This is because it will be trying to setup Central Admin to run from the SPJOB server instead. It was previously configured to run from the SPWEB server. Recovering from this would be very tedious indeed.

      Ideally, the future versions of the Config Wizard would include one simple check box on step 4.b.xxiv. titled "Skip Central Admin configuration" which would allow you to simply skip this entirely.

      As it is, there is no such option and using the Config Wizard for all but the very first server configured is not possible. Some thought also need to be paid to the fact that the first server you configure would be the server that runs your Central Admin application. All other servers will point to it for Central Admin functions.

       

  25. To resolve this dilemma, we have to turn to the command line yet again (I told you you'd be spending a lot of time in the 12 hive! J) and to a tool called psconfig.exe. The psconfig.exe utility is obscure and not very well documented, but you can find what documentation does exist on it at the psconfig.exe TechNet page. Open a command line on the SPJOB server using Start/Run/cmd.
  26. Change directory to the 12 hive at "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin".
  27. Enter the following command:

     

    Psconfig.exe –cmd configdb –connect –server SPSQL –database SHAREPOINT_CONFIG –user DOMAIN\SPSERVICEACCOUNT –password SPPASSWORD –cmd services provision

     

    where:

  • SPSQL is the name of your SQL Server.
  • SHAREPOINT_CONFIG is the name of your configuration database.
  • DOMAIN is the name of your domain.
  • SPSERVICEACCOUNT is the name of your SharePoint service account, the same account which you are currently logged on with.
  • SPPASSWORD is the password of your SharePoint service account.
  1. You should see visual feedback such as the following:

     

     

  2. Once completed, we will be conducting all our processing from SPWEB so you can now logoff from the SPJOB server.
  3. Return to Central Admin on the SPWEB server and refresh the page to show the new changes.

     

     

  4. As you can see, the newly activated services are running on the SPJOB server. The SPJOB server needs to be configured as the Job/Index server though. Click on the server name itself.

     

     

  5. As you can see, the server will initially be configured as a second Web Front End (WFE) server. Additionally, there is also some services running on the server that we do not need at this time, such as the "Document Conversions Launcher Service" and the "Excel Calculation Services". Since we want the SPJOB server to serve as the Index server, we need to change the role assignment and disable any unwanted services. Begin by clicking the "Stop" action of the "Document Conversions Launcher Service".

     

     

  6. You will be prompted to confirm that you wish to disable the service. Click the "OK" button to continue.
  7. The page will refresh and the status of the service should show either "Stopping" or "Stopped".

     

     

  8. Next, click the "Stop" Action link for the "Excel Calculation Services". Again, you'll be prompted to confirm that you wish to disable the service on the server.

     

     

  9. Click the "OK" button to continue.
  10. Finally, we want to assign the SPJOB server as the Index server so we select the "Search Indexing" option.
  11. Now that the SPJOB server is configured, we need to navigate back to the Operations page by clicking on the "Operations" tab at the top.
  12. Scroll down to the bottom of the page to the Upgrade and Migration section.

  13. Click the "Site content upgrade status" link.
  14. You will be presented with the Site Content Upgrade Status page.

  15. There should be a list of servers listed on the left under the "URL for Previous Version" column, and in our case, the SPWEB server should be listed.
  16. To the right of the server name, there should be a "Begin upgrade" link under the "Next Action" column. Click the "Begin upgrade" link.
  17. You will be presented with the Set Target Web Application page. Pay close attention to the page. If you note a "No Indexers" indicator at this stage, you cannot proceed and must address this issue first.

     

     

  18. The problem is that indexing was not assigned to a server properly. Begin by clicking the "Operations" tab in the top menu.
  19. Now, in the "Topology and Services" section, click the "Services on server" link.
  20. By default the current i.e. SPWEB server will be listed with all its services. Click the server name to change to the SPJOB server.
  21. Ensure that the "Office SharePoint Server Search" service is running. If it is not, start the service by clicking the "Start" link under the "Actions" column.
  22. Now click the "Office SharePoint Server Search" link itself.

     

     

  23. For the SPJOB server, the "Query and Indexing" option should have "Use this server for indexing content" selected. It probably isn't set which is why there were not indexers showing up before. Select this option.
  24. Unselect the "Use this server for serving search queries" option for the SPJOB server.
  25. Enter your contact email address.
  26. Enter the user ID of the services account that will be used to process search for the entire farm in DOMAIN\USER format. This is normally the same account as the content access account.
  27. Enter the password of the services account.
  28. Scroll further down to reveal the remaining options on the screen.

     

     

  29. For the "Indexer Performance" setting, the default should be "Partly Reduced". This is a good setting to use initially and it can be changed later as you experiment with performance settings.
  30. Change the "Web Front End Crawling" setting from "Use all web front end computers for crawling" to "Use a dedicated web front end computer for crawling". The SPJOB server should be showing up in this drop down. If it is not, select it from the drop down.
  31. Click the "OK" button to continue.
  32. Repeat steps lxvii through lxxvii for the SPWEB server, but set it instead to "Use this server for serving search queries".
  33. Once completed, click "Operations" in the top nav bar again.
  34. Scroll down to the "Upgrade and Migration" section and click the "Site Content Upgrade Status" link again.
  35. On the "Site Content Upgrade Status" screen, click the "Begin upgrade" link on the right again.
  36. This time there should be no error noting "No indexer". The purpose of this page is to set the location at which the original content can be accessed until the migration is completely done. By default SharePoint will populate the "Port" edit box with a random port number. Enter a port number in the "Port" edit box that you wish to use. You could use the default generated number, but it's usually better to use a number that's easy to remember because this is the port on which your original portal content will be published e.g. in our case the original portal was available on http://spweb. By entering "8000" for the port, the original portal will be available under http://spweb:8000 in the future.

  37. The purpose of this page is to set the location at which the original content can be accessed until the migration is completely done. By default SharePoint will populate the "Port" edit box with a random port number. Enter a port number in the "Port" edit box that you wish to use. You could use the default generated number, but it's usually better to use a number that's easy to remember because this is the port on which your original portal content will be published e.g. in our case the original portal was available on http://spweb. By entering "8000" for the port, the original portal will be available under http://spweb:8000 in the future.
  38. You can enter a host header in the "Host Header" edit box if you wish to use one.
  39. Scroll down the page to get to the Application Pool settings.

  40. If you already have a pre-created application pool, you can select the "Use existing application pool" radio button, but in our case we need a new pool so select the "Create new application pool" option.
  41. In the "Application pool name" enter the name of the pool you wish to create. We're just using "MOSS" for our pool name.
  42. Decide if you wish to have the security account be a network service or a configurable account. In our case, we have a domain account created for this purpose, so we will go ahead and select the "Configurable" option.
  43. Enter the domain account name into the "User name" edit box in the format DOMAIN\USER.
  44. Enter the password that was set for this account into the "Password" edit box.
  45. Select the "Restart IIS Automatically" option.
  46. Scroll down further to Security Configuration section of the page.

  47. If you are using NTLM authentication, you can use the default setting. In our case, as in most real world cases we have configured Kerberos so under the "Authentication provider" section, select the "Negotiate (Kerberos)" option.
  48. In the "Content Databases" section, ensure that the "Automatic database name selection" is selected.
  49. In the "SSP Database Settings" section, enter the name of a database to use in the "SSP Database Name" edit box.
  50. Enter the name of the Search database to use in the "Search Database Name" edit box.
  51. Scroll down to the Index Server section.

  52. You should see the Index Server set as SPJOB.
  53. Ensure that the "Path for index file location" option is set correctly. This should default to the value you originally set when you installed MOSS. In our case, we are using our D:\ drive for storage, so the setting reflects that.
  54. Click the "OK" button to continue.
  55. Because we are using Kerberos, you will get a warning popup dialog window related to Kerberos security.

  56. Click "OK" to confirm Kerberos authentication is what we want to us.
  57. You will be presented with an Operation in Progress screen.

  58. Depending on the size of your portal, this page may take a long time to process because it is building a list of all site collections in your portal to be upgraded. Once SharePoint completes building the list of site collections to upgrade, it will present you with the Site Collection Upgrade screen.

  59. IMPORTANT NOTE: You must upgrade the root "/" site collection BEFORE you can upgrade any of the other site collections. The root site collection will upgrade all your portal areas.
  60. Select the "/" site collection check box.
  61. Scroll to the bottom of the page and on the right hand side, click the "Upgrade Sites" button.

  62. You will be presented with a pre-upgrade Stat Report page.

  63. This page will indicate the number of site collections that was selected for the upgrade as well as the amount of storage that the site collection(s) currently use.
  64. Click the "Upgrade sites" button to begin the upgrade process.
  65. You will be taken to an "Upgrade Running" status page.

  66. The page will automatically reload every minute and status information will change over time. Depending on the site of the collection, the upgrade may take some time.
  67. We now find that we have an error and our upgrade job failed. This was unexpected.

  68. There are 3 items to note on the screen:
    1. The Status – "Job failed".
    2. The location of the log/debug file which is located in the "C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Logs" folder under the name "Upgrade.log". Several other log files can be found in this folder as well.
    3. The "Resume" button that will be used to resume the upgrade job once the issues in question have been resolved.
  69. Locate and open the "Upgrade.log" file specified in the error report.
  70. Search for "[ERROR]" to locate the error that caused the failure.

  71. Note that because the log file is a debug log, the GUID of the feature that caused an error during installation is actually written on the line preceding the line with [ERROR] in it. In our case, the failure was caused by a feature that could not be deployed to the /MySite site collection. Part of the problem is that the Feature might have to be forced to install and since the migration code does not use the -force option, it could fail. That is what happened in this case. In order to forcibly install the features, we need stsadm again.
  72. Make a note of the feature GUID.
  73. Scan the entire "upgrade.log" file noting all the feature GUIDs that caused errors. There may be several.
  74. Open a command window on the SPWEB server again.
  75. Navigate to the bin folder using "cd\pro*\com*\mic*\web s*\12\bin".
  76. You should find yourself in the "C:\Program Files\Common Files\Microsoft Shared\web server extentions\12\bin" folder.
  77. Enter "stsadm -o activatefeature" to get the proper syntax to use from help.

  78. Now enter the following code for each feature/site that failed:

    stsadm –o activatefeature –id <GUID> -url <Site URL>

    1. Replace the <GUID> value with the failed feature GUID each time.
    2. Replace the <Site URL> value with the failed site address each time.
  79. In our example, the commands would be:
    1. stsadm -o activatefeature -id 22a9ef51-737b-4ff2-9346-694633fe4416 –url http://test4-spweb-01/mysite -force
    2. stsadm -o activatefeature -id 306936fd-9806-4478-80d1-7e397bfa6474 –url http://test4-spweb-01/mysite -force
    3. stsadm -o activatefeature -id 22a9ef51-737b-4ff2-9346-694633fe4416 –url http://test4-spweb-01/C5/teams -force
    4. stsadm -o activatefeature -id 306936fd-9806-4478-80d1-7e397bfa6474 –url http://test4-spweb-01/C5/teams -force

  80. Return to the Upgrade page and click the "Resume" button to resume the upgrade attempt.
  81. Upon successful completion of the migration, you should see the summary page.

     

  82. At this point in time, your SPS Portal Areas would have been migrated. Site collections are migrated in the same fashion until the entire farm has been migrated...

Kick it Fave it Digg it Reddit Del.icio.us

Comments

http://guru-raju.spaces.live.com/

Awesome Compilation!
I just wanted to point an alternative that I have used to to resolve the dilemma, in place of the following command.
"Psconfig.exe –cmd configdb –connect –server SPSQL –database SHAREPOINT_CONFIG –user DOMAIN\SPSERVICEACCOUNT –password SPPASSWORD –cmd services provision "

1. You first will have to stop Central Administration service running in the JOB server.
2. At this point you will not be able to access Central Administration from either WEB or JOB server.
3. Run the following command
stsadm.exe -o setadminport -port <port number you chose WEB server during configuration>
4. Now you should be able to access Central Administration from WEB(Front end) server.

Thanks!
at 6/26/2007 12:31 PM

http://www.cjvandyk.com/blog

It is true that this workaround would work when setting up a single job server and a single WFE server, but have you considered the process when adding more web servers, or job servers in the future i.e. when scaling out becomes neccessary.  Whenever a new server needs to be added to the farm, the PSCONFIG tool comes in very handy.

Later
C
Cornelius J. van Dyk at 6/27/2007 1:23 AM

fer@sntg.ANTISPAM.com

Cornelius-This document rocks, my co-workers and I read through hours of useless documentation and tried unsucessfully countless times to upgrade our sp intranet to 2007.  After reading this and following it word for word, it worked the first time!!!! 
at 7/17/2007 4:57 PM

http://www.cjvandyk.com/blog

fer,

I am very glad to hear that my document was able to help you.  I spent many hours on it, so it is truly gratifying to see that it helped someone save some time.

Later
C
Cornelius J. van Dyk at 7/18/2007 9:51 AM

upgrade problem

i am getting error Skipping virtual server: http://servername/. Server state = NotAdministrable. Most likely this virtual server is not extended with WSS v2.

for details

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1993079&SiteID=1&mode=1

pls guide to resolve this issue
at 8/10/2007 11:59 PM

http://www.beztec.com

Brilliant!!!  That is all that I can say.  I have been banging my head on the desk for 5 days with 11 unsuccessful attempts to upgrade.

I only had to go through your list once!

Thanks for the hard work and for sharing it.

Ray
at 8/13/2007 6:20 AM

http://www.cjvandyk.com/blog

In which step exactly are you experiencing this error?

Thanks
C
Cornelius J. van Dyk at 8/13/2007 1:01 PM

http://www.cjvandyk.com/blog

Ray,

Good feedback like this just warms my heart.  It makes the countless hours I spend on creating original content all worth it! ;-)

Later
C
Cornelius J. van Dyk at 8/13/2007 1:04 PM

Simply Superb!!

This is real greal article which was complied in a great format
at 12/5/2007 10:13 PM

http://www.cjvandyk.com/blog

Why thank you very much!  ;-)

Later
C
Cornelius J. van Dyk at 12/6/2007 5:28 AM

tyrone8323@gmail.ANTISPAM.com

How long would you say it would take to complete this upgrade, using your documentation? Thanks!
at 12/10/2007 8:29 AM

http://www.cjvandyk.com/blog

That depends entirely on how much data you have in your SharePoint environment.
Just following the steps in this blog entry takes 1-2 hours on a server with little data, but as data increase, so does wait times for conversion routines to run.

I hope that helps.

Thanks
C
Cornelius J. van Dyk at 12/16/2007 4:57 AM

chris.jenkins@gnb.ANTISPAM.ca

I have an unexpected error in upgrade.log, related to a full-text search. It's claiming an incorrect parameter. Anyone seen this or know what it means?

[SPManager] [ERROR] [2/7/2008 9:02:55 AM]: Migrate [SPMigratableSiteCollection Parent=SPManager] failed.
[SPManager] [ERROR] [2/7/2008 9:02:55 AM]: Execution of a full-text operation failed. The parameter is incorrect. 
[SPManager] [ERROR] [2/7/2008 9:02:55 AM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
  
at 2/7/2008 10:55 AM

http://www.cjvandyk.com/blog

Chris,

I can't say that I have.  You might have to recreate the SSP if you're unable to find the solution.

Thanks
C
Cornelius J. van Dyk at 2/20/2008 1:34 PM

vinay@youngindiagroup.ANTISPAM.com

Can u just explain from u r example how the URL is redirecting
at 3/17/2008 4:45 AM

http://www.cjvandyk.com/blog

Hey Vinay,

Which redirect are you referring to?  Can you cite a step number or something more specific?

Thanks
C
Cornelius J. van Dyk at 4/8/2008 2:36 AM

d.demie@odi.org.ANTISPAM.uk

This thorough guide has been very helpful for us and we would like to thank you for putting it together.  After upgrading from SharePoint Portal 2003 to MOSS 2007 we are currently having a problem with the My Site.

My Sites seem to have been upgraded correctly and all my site content is accessible. But when trying to amend my profile in My Site in MOSS 2007 this error message results:

 "An unknown user profile error has occurred.  Try recreating this user profile or updating this user profile from the directory service to resolve this problem."

The edit fails.

Can anyone help with this?

Thanks

Daniel
at 4/11/2008 3:07 AM

http://www.cjvandyk.com/blog

Hey Daniel,

Have you tried deleting the profile for that user and reimporting it from AD?  That should recreate the user profile while leaving the MySite intact and might solve your problem.

Thanks
C
Cornelius J. van Dyk at 4/11/2008 8:53 AM

d.demie@odi.org.ANTISPAM.uk

Yes I have already tried deleting and importing all user profiles from AD, but no difference. I have also created another my site location in the same SSP with new web app and db but the problem persists at the my site host location.  I guess the problem is to do with the configuration of 1st SSP.  I then created a second SSP and reimported all profiles from AD into the second SSP’s My Site and the error message is gone when updating my site from the 2nd SSP.  The only problem is I don’t know how to move personal site contents between SSPs.

Does anyone know how to migrate my site personal content from one SSP’s my site host to another SSP’s my site host in a single farm?

Thanks
Daniel
at 4/11/2008 10:18 AM

http://www.cjvandyk.com/blog

Hey Daniel,

The best tool I've found for moving SharePoint site content around is the DocAve tools from AvePoint.  You can get a 30 day trial by contacting their sales people.  That should give the ability to test and see if the tool does what you need it to do.

Hope that helps.
Thanks
C
Cornelius J. van Dyk at 4/12/2008 7:06 AM

kranthi.kr@No.Spam.gmail.ANTISPAM.com

Hi Daniel

We are experiencing the similar problem after upgarding pesonal sites from 2003 to MOSS.

If we delete and import the profile from AD all the user my links, profile properties will be lost. Is there any better way of doing this.

Thanks
Kranthi.
at 5/29/2008 3:13 AM

Error in running Sharepoint Prod & Tech wizard

Hey thanks for all the info you have provided

But i just bumped up with a Configuration Failure Error!!!
Actually my Prescan was not successful, as there are over 1300 unghosted pages. So i thought i would fix those problems in post migration stage. 

The sharepoint Prod & Tech config wizard stopped in the 2nd task itself throwing the below error

"""An exception of type Microsoft.Sharepoint.PostSetupConfiguration.PostSetupConfiguration Task Exception was thrown. The preupgrade scan tool has not run sccessfully on all the content databases of the server farm."""

Then it asked me to look up the application event log file and configuration log file. Am not able to figure out from the log files.

Can any of guys can help !!!???
at 6/18/2008 9:53 AM

http://www.cjvandyk.com/blog

Mmm... I think my suggestion would be to FIX the problems FIRST and ensure that Prescan runs without error BEFORE retrying your upgrade.

Later
C
Cornelius J. van Dyk at 6/19/2008 5:26 AM

Search setting Error

Hi people,

THis is Pravin.. The upgrading information was really helpful. Thanks C .

After all upgrading and stuff.. my MOSS farm is perfectly ready.. web sites are working perfectly..Now one day, i go to central admin. Click on the SharedServices1( on the left pane). Next I click on the Search Settings(Under Search options).. It pops up an error and its UNKNOWN ERROR... What could be the problem guys??.. Since its an unknown error am not able to google it much..Is my SSP corrupted or something??? any suggestions how could i solve this UNKNOWN ERROR??? Do i need to reinstall the farm entirely??


Waiting for ur suggestions reply..

Thanks

Pravin
at 6/19/2008 3:06 PM

POst migration issue !!!

Thanks for  all the useful info you provided. My issue was almost the psot effect of migration i think,

When I go into central admin, then click on SharedServices1 on the left pane. After that, I want to get into Search settings option .. But when i click on Search settings i get Unknown Error

 No explanation of the error. Just Unknown Error.. What do you think could be the problem??. I have created one SSP and there are 4 Web apps. Is the SSP corrupted or something.


Just let me know guys.. Its kinda urgent.

 

Thanks a lot once again.

 

Chinnu
at 6/23/2008 8:42 AM

http://www.cjvandyk.com/blog

Hey Pravin,

I would start by looking at your SharePoint logs.  It is in the 12 hive under the LOGS folder.  That might give you some more information as to what kind of error it it.
The other thing you can do is look in the server's Event Log.  There might be some info about the error in there too.

You don't have to reinstall the entire farm.  The worst case for these type of issues is usually having to delete the existing SSP and then recreate a new SSP.  Of course, that could be very tedious in itself if you have a lot of Best Bets etc. defined, but at least you don't have to rebuild the farm.

Start with the logs though...

Hope that helps.

Later
C

PS:  <Rant>Sometimes when I get these nice little "UNKNOWN ERROR" messages from Microsoft, I would edit SharePoint's web.config file and turn the <CustomError> node off so that SharePoint would throw a complete ASP.NET error instead of just a stupid, useless "UNKNOWN ERROR" message!  A little pet peeve of mine...</Rant>
Cornelius J. van Dyk at 6/24/2008 6:29 AM

http://www.cjvandyk.com/blog

Hey Chinnu,

Yes, it sounds to me like your SSP might be corrupted.  See my suggestions to Pravin above.  He seems to have a similar problem.  ;-)

Later
C
Cornelius J. van Dyk at 6/24/2008 6:40 AM

site actions tab not visible???

Hi guys,

thanks for you suggestions, I had a post migration issue, where i tried to migrate the root site collection first. After migrating , i clicked on the new URL(of this root site) to see how the site looks and to my surprise, there was no SITE ACTIONS tab on the right top corner. I want to reset the site definition and for that i need to go to site settings option which is not possible in this case. Actually i dint clear the unghosted pages before migrating. So do you think this problem is related to unghosted SPS pages which is overlapping the SITE ACTIONS tab in the MOSS version. or  Is there any stsadm command for the reset the site definition.??????

 Please help me..

Thanks in advance
Vijay
at 7/1/2008 3:55 PM

SSP still bugging

Hi C,

As you suggested i turned the <CustomError> mode off and so the sharpeoint completely threw the following error

The resource object with key 'S2LeftNav_Administration' was not found. 
at System.Web.Compilation.ResourceExpressionBuilder.ParseExpression(String expression, Type propertyType, ExpressionBuilderContext context)

at System.Web.UI.BoundPropertyEntry.ParseExpression(ExpressionBuilderContext context)

at System.Web.UI.ControlBuilder.FillUpBoundPropertyEntry(BoundPropertyEntry entry, String name)

at System.Web.UI.ControlBuilder.AddBoundProperty(String filter, String name, String expressionPrefix, String expression, ExpressionBuilder expressionBuilder, Object parsedExpressionData, Boolean generated, String fieldName, String formatString, Boolean twoWayBound)

at System.Web.UI.ControlBuilder.PreprocessAttribute(String filter, String attribname, String attribvalue, Boolean mainDirectiveMode)

at System.Web.UI.ControlBuilder.PreprocessAttributes(ParsedAttributeCollection attribs)

at System.Web.UI.ControlBuilder.Init(TemplateParser parser, ControlBuilder parentBuilder, Type type, String tagName, String id, IDictionary attribs)

at System.Web.UI.ControlBuilder.CreateChildBuilder(String filter, String tagName, IDictionary attribs, TemplateParser parser, ControlBuilder parentBuilder, String id, Int32 line, VirtualPath virtualPath, Type& childType, Boolean defaultProperty)

at System.Web.UI.TemplateParser.ProcessBeginTag(Match match, String inputText)

at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding)

Does anything strikes to you??? any suggestions for this??

thanks
Pravin
at 7/2/2008 9:36 AM

http://www.cjvandyk.com/blog

Hey Vijay,

I think the problem is probably related to anonymous authentication being turned on for your site.  When you're not authenticated, the tab doesn't show up and if the page was unghosted, then the Signin link probably won't be visible either.
Try just adding "/_layouts/settings.aspx" to your browser URL so your URL would change from say "http://server/Pages/Default.aspx" to "http://server/_layouts/settings.aspx".
This gets you to the main Settings page for the site and it is a secured page which means SharePoint should challenge you for login credentials.  Once you're logged in, the tab will either show up or in the very least, you'll be on the Settings page and be able to go from there.

Hope that helps.

Later
C
Cornelius J. van Dyk at 7/6/2008 1:26 AM

http://www.cjvandyk.com/blog

Hey Pravin,

The only thing that really jumps out at me is this part:

'S2LeftNav_Administration'

It seems to me that it could be an error for a component in the master page that might have been removed.  If you have custom branding applied to your site, I would suggest reverting it back to the stock master pages and branding and then seeing if you still get the error.
SharePoint is very sensitive to components being deleted from the master page.  That's why our best practice is to create an invisible ASP.NET panel and simply shove what we don't want, into that panel.  That way, it's still on the page which makes SharePoint happy, but it's not visible anymore which accumplishes our goal.

Later
C
Cornelius J. van Dyk at 7/6/2008 1:37 AM

custom branding??

Hi C,

Your suggestion was really helpful.. But since am just a beginner in sharepoint, could you just let me know whats CUSTOM BRANDING??? and where can I find the custom branding in master page and revert back to stock master pages??

thanks in advance

Pravin
at 7/8/2008 9:14 AM

Post MIgration issue

Hello Cornelius,

I followed your exact steps for graual migration from the start. In the post migration stage, I started with upgrading the root site initially and they after that, i upgraded 50 sites at a time to make sure it works perfectly. So as i was doing this.. at one stage the Status showed JOB FAILED and i looked up into the upgrade log file. the error is as follows


[SPManager] [ERROR] [6/23/2008 1:17:37 PM]: Migrate [SPWebApplication Name=Default Web Server_Pair Parent=SPWebService] failed.
[SPManager] [ERROR] [6/23/2008 1:17:37 PM]: Incorrect syntax near '\'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
[SPManager] [ERROR] [6/23/2008 1:17:37 PM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command)
   at Microsoft.SharePoint.Portal.Upgrade.SharedDatabaseOld.RestoreFromBackupFileList()
   at Microsoft.SharePoint.Portal.Upgrade.GenericWebApplicationMigrator.MigrateDatabase(Guid databaseServerId, Guid databaseId, String databaseInstanceName, String databaseName, String newDatabaseName, Boolean isSharedDatabase)
   at Microsoft.SharePoint.Portal.Upgrade.GenericWebApplicationMigrator.MigrateSharedResourceProvider(String newProfileDatabaseName, String newSearchDatabaseName, String indexServerName, String indexLocation)
   at Microsoft.SharePoint.Portal.Upgrade.WebApplicationMigrator.Migrate()
   at Microsoft.SharePoint.Upgrade.SPManager.Migrate(Object o, Boolean bRecurse)
 It looks like syntax error.. If so, where should i go and change???

And the second error was as follows,

[SPSiteCollectionCopier] [ERROR] [7/7/2008 10:41:46 AM]: Failed copying site SPSite Url=http://cdb-spodev.ibm.com/sites/devpa.
[SPSiteCollectionCopier] [ERROR] [7/7/2008 10:41:46 AM]: Could not allocate space for object 'dbc.AllDocVersions'.'AllDocVersions_PK' in database 'cdb1_site_Pair' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
[SPSiteCollectionCopier] [ERROR] [7/7/2008 10:41:46 AM]:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.SPBaseSiteCollectionCopier.Copy()


What do you think can be done?? ANy suggesstions???

help C...


Regards,
Vijay
at 7/9/2008 1:17 PM

http://www.cjvandyk.com/blog

Hey Pravin,

When you open the master page in SharePoint Designer, if it was customized, you will notice an icon of a blue "i" in front of the master page file.
If you right click on the .master file, the third option on the popup menu should be "Reset to Site Definition" which should revert the master page to the original site definition version.

WARNING!!!  DO NOT DO THIS IN PRODUCTION UNTIL YOU'VE TRIED IT IN TEST FIRST!!!

Hope that helps.
C
Cornelius J. van Dyk at 7/10/2008 11:12 AM

http://www.cjvandyk.com/blog

Hi Vijay,

This is a problem that gradual migrations tend to run into often.  If you look at the second part of that error you posted, it tells you what the problem is:

[SPSiteCollectionCopier] [ERROR] [7/7/2008 10:41:46 AM]: Could not allocate space for object 'dbc.AllDocVersions'.'AllDocVersions_PK' in database 'cdb1_site_Pair' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Your SQL Server ran out of disk space.  Chances are that your LOG file is huge at this point and it consumes all the space allocated.

You can either:

1.  Add more space to your SQL Server

or

2.  Change your content database on the SQL Server to "Simple" logging.

The simple logging setting should help prevent the massive log file.

Hope that helps.

Later
C
Cornelius J. van Dyk at 7/10/2008 11:18 AM

Post MIgration issue

Thanks C for the suggestion you gave for the upgrage log file i posted. But wat about the 1st part of the error. The one which says ""Incorrect syntax near '\'.
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.""

where should I go and correct this error.??? I dunno which page to open in Visual studio and change the syntax :-(


Looking forward from you

THanks C

Vijay
at 7/10/2008 3:16 PM

MOSS bug???

Hi C

When I use a SharePoint 2007(while creating links, or while clicking on the calender) I seem to get a periodic error that says: "Unhandled exception at 0x7c812a5b in IEXPLORE.EXE: 0xC06D007F: Procedure not found."
At this point, am forced to close IE6 and restart it again.

Its just am facing the probelm in my machine. I tested it on another user's computer and did not get an error.

Do you think its something to do with MOSS, or is there any bug with IE6??

Thanks
Hasan
at 7/10/2008 3:22 PM

http://www.cjvandyk.com/blog

Hey Vijay,

I would be careful about correcting multiple errors at the same time.  Just correct the database storage error and then retry.  You might find that the other error also goes away.

Thanks
C
Cornelius J. van Dyk at 7/11/2008 11:19 AM

http://www.cjvandyk.com/blog

Hey Hasan,

If it works from ANOTHER computer (which you said it does) then SharePoint is NOT the problem.  The problem appears to be on your local computer.  You might want to try reinstalling IE6 to see if that fixes the error.

Thanks
C
Cornelius J. van Dyk at 7/11/2008 11:20 AM

huang_5810@hotmail.ANTISPAM.com

Hello Cornelius,
I followed your exact steps for graual migration from the start. In the post migration stage, I started with upgrading the root site initially and they after that, i upgraded 2 sites at a time to make sure it works perfectly. So as i was doing this.. at one stage the Status showed JOB FAILED and i looked up into the upgrade log file. the error is as follows

[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]: Failed copying site SPSite Url=http://sps2003/sites/document.
[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.SPBaseSiteCollectionCopier.Copy()
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]: Migrate [SPMigratableSiteCollection Parent=SPManager] failed.
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]: This SqlTransaction has completed; it is no longer usable.
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName)
   at Microsoft.SharePoint.Utilities.TransactionalSqlSession.Rollback()
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.SPBaseSiteCollectionCopier.Copy()
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.Migrate()
   at Microsoft.SharePoint.Upgrade.SPManager.Migrate(Object o, Boolean bRecurse)
Anybody help me , Thank you
at 7/13/2008 2:45 AM

huang_5810@hotmail.ANTISPAM.com

Hello Cornelius,
I followed your exact steps for graual migration from the start. In the post migration stage, I started with upgrading the root site initially and they after that, i upgraded 2 sites at a time to make sure it works perfectly. So as i was doing this.. at one stage the Status showed JOB FAILED and i looked up into the upgrade log file. the error is as follows

[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]: Failed copying site SPSite Url=http://sps2003/sites/document.
[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[SPSiteCollectionCopier] [ERROR] [7/11/2008 12:29:29 AM]:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.SPBaseSiteCollectionCopier.Copy()
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]: Migrate [SPMigratableSiteCollection Parent=SPManager] failed.
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]: This SqlTransaction has completed; it is no longer usable.
[SPManager] [ERROR] [7/11/2008 12:54:57 AM]:    at System.Data.SqlClient.SqlTransaction.ZombieCheck()
   at System.Data.SqlClient.SqlTransaction.Rollback(String transactionName)
   at Microsoft.SharePoint.Utilities.TransactionalSqlSession.Rollback()
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.SPBaseSiteCollectionCopier.Copy()
   at Microsoft.SharePoint.Upgrade.SPSiteCollectionMigrator.Migrate()
   at Microsoft.SharePoint.Upgrade.SPManager.Migrate(Object o, Boolean bRecurse)
Anybody help me , Thank you
at 7/13/2008 5:00 AM

http://www.cjvandyk.com/blog

Hey Huang,

Looking at the log, it appears as if your app may have timed out.  You might want to try increasing your IIS app timeout setting and try again.

Hope that helps.

Later
C
Cornelius J. van Dyk at 7/14/2008 4:11 AM

stevenljjohnson@hotmail.ANTISPAM.com

CJ

Bang on document! The world is a slightly less confused place for the graft you've put into this, and especially the fixing techniques for when the migration inevitably fails in places. I am humbled by your honesty and willingness to share your experiences in such a detailed fashion. Long may you reign as king of the shared point.
at 7/29/2008 2:00 PM

http://www.cjvandyk.com/blog

Hi Steven,

I am truly humbled by your comment.  I've had many a good feedback on this particular post.  It is the one I'm most proud of and I intend to do the same thing when the next version of SharePoint comes out.  ;-)  Hopefully that story will be more straight forward!

Anyway, thanks so much for leaving your thoughts on my blog.

Later
C
Cornelius J. van Dyk at 7/30/2008 6:53 PM

farhanfaizpk@yahoo.ANTISPAM.com

CJ,

We are running upgrade using gradual approach. We have upgrade sites before from the list but when we selected a site with 328MB size and click on Upgrade Site button. We are stuck with the page with following information:

Status: Job pending
Mode: Side-By-Side
Elapsed Time:  
Starting object: SPMigratableSiteCollection Parent=SPManager
Current object:  
Current action:  
Step within the action:
Total steps in this action:
Server:

Page is refreshing itself again and again with no progress. Any suggestions?
at 8/7/2008 8:27 AM

Central admin Site missing

First of all well said Steven, C needs to be appreciated for the terrific job he has done in this blog.

well C, coming to my small issue, I had carried out ur migration steps and it worked pretty fine.. Now i dint touch my server(where i had carried migration) for 3 weeks. SO yesterday I came back to check it out and to my surprise I found that the central admin page is gone. It says: Page cannot be found" its a HTTP 404 not found error. So because of this, all the migrated sites do not open as well. Am sure that, my company's DBA team has not touched the DBs. SO where is it?? I can try repairing the MOSS through Sharepoint Prod and Tech Config wizard. But am just hesitating because, the repair might affect the migrated sites(will it affect??).  I saw the website list in IIS. I don see the websites or web apps I created (or i don really remember the web app names to be 100% sure of). So what do you suggest now?? do i need to restart the migration process from scratch?

Thanks
chinnu
at 8/8/2008 10:09 AM

http://www.cjvandyk.com/blog

Hey Farhan,

Have you checked the logs.
1.  Event Logs
2.  SharePoint Logs located in <12 Hive>\LOGS

The job is hung up for some reason.  Also, since it's a SQL Server job, you should check the event logs on the SQL Server as well for clues as to why the job is hung up.

Hope that steers you in the right direction.

Thanks
C
Cornelius J. van Dyk at 8/12/2008 3:34 AM

http://www.cjvandyk.com/blog

Hey Chinnu,

I would ask the same as for Farhan... did you check the logs?

1.  Event log
2.  SharePoint logs located in <12 Hive>\LOGS

Also, did your migrated sites work at one point?
I ask this because there's a possible problem if the SPS site template was modified and customized and then you attempt to upgrade it.

When you get the 404 error, what is the exact URL in the address bar?

Thanks
C
Cornelius J. van Dyk at 8/12/2008 3:44 AM

RE:Central admin Site missing

Hi C,
Am not getting much help from the logs. Its really a huge log.I have noted down few main errors in the log which is as follows but there are many errors.
If you want I can copy paste the full log in my next comment


Critical >>> The Execute method of job definition Microsoft.Office.Server.Administration.ConfigurationCheckerJob (ID 3fb87c4f-676a-45d9-a764-8ebad3221634) threw an exception. More information is included below.  Operation is not valid due to the current state of the object.


Unexpected >>> Exception stack trace: at Microsoft.SharePoint.Administration.SPContentDatabase.ValidateDatabaseSchemaCompatibility()     at Microsoft.SharePoint.SPSite.PreinitializeServer(SPRequest request)     at Microsoft.SharePoint.SPWeb.InitializeSPRequest()     at Microsoft.SharePoint.SPWeb.EnsureSPRequest()     at Microsoft.SharePoint.SPWeb.get_Request()     at Microsoft.SharePoint.SPListCollection.EnsureListsData(Guid webId, String strListName)     at Microsoft.SharePoint.SPListCollection.EnsureListsData(String strListName)     at Microsoft.SharePoint.SPListCollection.Undirty()     at Microsoft.SharePoint.SPBaseCollection.System.Collections.IEnumerable.GetEnumerator()     at Microsoft.SharePoint.Administration.SPAdministrationWebApplication.get_AdministrativeTasks()     at Microsoft.SharePoint....


Unexpected >>> ...Administration.SPAdministrationWebApplication.SwitchAdministrativeTasksView(String baseViewId)     at Microsoft.Office.Server.Administration.ConfigurationCheckerJob.Execute(Guid targetInstanceId)     at Microsoft.SharePoint.Administration.SPTimerJobInvoke.Invoke(TimerJobExecuteData& data, Int32& result)

Does this help??
at 8/14/2008 2:56 PM

RE :Central admin Site missing

And yes, the Migrated sites worked perfectly when I did the gradual migration initially. But I dint touch the server for 3 weeks.So after that when i opened the site after a period of 3 weeks, it was gone..
You said, ""if the SPS site template was modified and customized and then you attempt to upgrade it."".. How do i know if the SPS template was modified or not?

In ideal case the central admin url is : http://nvm0800dev:5000/default.aspx 

After 404 error, the current central admin URL :
http://nap0800dev:5000/


Let me know CJ.

Thanks
Chinnu
at 8/14/2008 3:24 PM

outage situation in SPS 2003

Hi C,
While i was working with the migration, my manager called me and asked me to check the Front end servers in the SPS farm because some of the client users were facing the OUTAGE SITUATION... Well do you know what this word "outage situation" means since i havent come across this word in Sharepoint.. and how we suppose to check this is in SPS 2003.  we have 5 front end servers in our company. Now where am suppose to start and how to resolve this OUTAGE situation?? this is nothing to do with migration.. but am wondering if its related to sharepoint or windows server 2003..? but i hope you would help, since this blog is very much active and am a regular visitor in this blog...

Am open for comments from anyone visiting the blog.
Thanks in advance.

Chinnu
at 8/19/2008 10:39 AM

After migration..UNable to edit documents

Hi C,

After the migration, in MOSS 2007 i moved all the docs in doc library. I received a problem from a client who says:

""Even though I am administrator or contributor for the sharepoint project sites, whenever I try to edit a document, it opens in Read Only mode, so then I have to save it elsewhere and upload it into the sharepoint folder. Lots more work when I should be able to edit it directly."""

So I double checked the permission. SHe has full admin rights. I received the same problem in SPS as well before migration. PLease comment on what could be wrong in both the scenarios ( SPS and MOSS).. Thanks Dude..

Cheers,
chinnu
at 9/19/2008 1:12 PM

golden_dr@hotmail.ANTISPAM.com

CJ,

Great instructions!  We ran through the ins and were able to get our lab environment to the point of the root being upgraded.  All team and personal sites are still hosted on sps 2003.  The challange we have is in the redirect.  MOSS does not know how to redirect to the old sps environment?  We have tried rolling back several times and going through the migration again.  Eash time the same resault?

Is there a manual way to set the redirect?

Thanks,
at 10/17/2008 9:40 AM

http://www.cjvandyk.com/blog

Hey golden_dr,

You have to open the root site with SharePoint Designer and then edit the default.aspx file to change the redirect to go to /Pages/default.aspx.

Hope that helps.

Thanks
C
Cornelius J. van Dyk at 11/10/2008 6:24 PM

http://www.aarat.com

Hello,

We currently have sharepoint server 2003 that we use for our intranet..

Now we have purchased new server and we want to migrate sharepoint 2003 data to sharepoint 2007. what should we do.. everything is installed on one machine..

one server and one farm
at 8/11/2009 5:52 AM

marutibe@gmail.ANTISPAM.com

Best i had seen
at 12/4/2009 5:16 AM

pavan_madireddy@semanticspace.ANTISPAM.com

Hi All,
 
The above whole document holds good for Customsite definitions also? I mean if our SPS 2003 site has customsite definitions defined in \60\Templates\1033\SPSKN2 (our custom folder), Do we need to create a new set of customization with MOss 2007 (dll's and controls) and copy them.

How does migration hadles these CustomSite definitions?

If our targeted envinorment will have only MOSS 2007 installed (no side by side installation of SPS 2003 and MOSS 2007).

I am eager to here any response to this..

Regards
Pavan.
at 1/16/2010 10:23 PM

gh_sri@yahoo.ANTISPAM.com

really you are a fucking master man!!!!!!!!!!!!! keep it up. i became a big fan of you after reading this explanation.
at 3/4/2010 10:41 AM

http://www.cjvandyk.com/blog

To everyone this post helped.  I'm grateful that the many hours I spent on producing the post, was able to save you time and frustration.  The knowledge that it helps someone somewhere, makes it all worth it for me.

Later
C
Cornelius J. van Dyk at 3/6/2010 9:33 AM

sharma.amreesh@gmail.ANTISPAM.com

Fantastic job done by Cornelius J. van Dyk. though i have not tried the upgradation till now but very soon i have some upgradation task in hand and i will try this post's help. Thanks for sharing your worderful experience and kepp doing the good job further to minimise the Administrator's job easier..

Regards

Amreesh Sharma
SharePoint Administrator
at 4/29/2010 2:27 AM

http://www.cjvandyk.com/blog

Hey Amreesh,

Thank you so much for your kind comments.  This is why I do this. ;-)

Later
C
Cornelius J. van Dyk at 4/30/2010 6:54 AM

sharma.amreesh@gmail.ANTISPAM.com

Hi CJ,
Please write some posts on troubleshooting for Sharepoint performance and user profile and search if possible. it will highly appreciated.

Thanks
Amreesh
at 5/5/2010 12:35 AM

http://www.cjvandyk.com/blog

Hey Amreesh,

Thank you so much for your requests.  I'll keep the topics in mind going forward as I work on new blog articles.
Here's one I did recently related to performance:

http://www.cjvandyk.com/blog/Lists/Posts/ViewPost.aspx?ID=250

Later
C
Cornelius J. van Dyk at 5/5/2010 2:34 PM

ravi_864u@yahoo.ANTISPAM.com

Thanks for the information,I was struck with the issue,after migrating from 2003 to 2007 sharepoint sites are not opening.Can any one help me out in this please
at 7/14/2010 11:40 AM

Add Comment

PLEASE NOTE
Comments are moderated so posting your comment here, will NOT make it visible right away.  Once I've reviewed your comment, I will publish it for all to see.  This is unfortunately needed in order to deal with all the crapware and spambots that post to my blog on a regular basis.

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Your Email or Blog URL *


Body *


Attachments