none
The new BPA 1.2 says i need to upgrade the sharepoint databases

    Pregunta

  • After upgrading and running the new BPA.

    The BPA tels me i need to upgrade the share point databases.

    But when i execute (get-spserver $env:computername).NeedsUpgrade the answer is False

    Now i am a little puzzeled who is wright and who is wrong.

    Or do they point to two complete different things.

    Schrudcher

    sábado, 25 de febrero de 2012 15:36

Respuestas

Todas las respuestas

  • How are you logged in as?  That says "Localadmin" make sure you are logged in as a domain admin on the server.

    When is the last time you ran a psconfig?  You installed the SharePoint updates in February?

    sábado, 25 de febrero de 2012 17:46
  • Can you please run following command from an elevated sharepoint shell and post bask the o/p:

    Get-SPDatabase | % {$_.NeedsUpgrade}

    Looking forward for your reply

    sábado, 25 de febrero de 2012 18:24
  • There are 2 sorts of SharePoint upgrades:

    1. Binaries

    2. Database schemas

    You can update the binaries but not the schemas. Therefore the first graphic refers to the databases, the second refers to the binaries I would imagine.

    If you go into SharePoint Central admin and select servers in farm see what it says there and what version it is. Then go and check the health reports where it will probably say databases are running 'incompatibility mode'. This simple means they don't have latest schema.

    Bottom line? Run PSCONFIG to update everything.

    Thanks


    Thanks Robert Crane [MVP-Office365] www.ciaops.com

    domingo, 26 de febrero de 2012 2:18
  • How are you logged in as?  That says "Localadmin" make sure you are logged in as a domain admin on the server.

    When is the last time you ran a psconfig?  You installed the SharePoint updates in February?

    The Localadmin is domain admin aswell. I only used the name because Administrator is not allowed anymore.

    The last time i did run psconfig was when SP1 was released i think not totaly sure.

    No i did not install any sharepoint updates that i can remember. The last one i could find is:

         Security Update for Office SharePoint Foundation 2010 (KB2494001) Installation date: ‎21-‎09-‎2011 15:50 Installation status: Successful

    domingo, 26 de febrero de 2012 12:05
  • Can you please run following command from an elevated sharepoint shell and post bask the o/p:

    Get-SPDatabase | % {$_.NeedsUpgrade}

    Looking forward for your reply

    I did run the line and this are the results:

    domingo, 26 de febrero de 2012 12:08
  • So there you go,your 2 database's require the update and hence you are getting the message in BPA.

    You should run psconfig command.

    domingo, 26 de febrero de 2012 12:19
  • There are 2 sorts of SharePoint upgrades:

    1. Binaries

    2. Database schemas

    You can update the binaries but not the schemas. Therefore the first graphic refers to the databases, the second refers to the binaries I would imagine.

    If you go into SharePoint Central admin and select servers in farm see what it says there and what version it is. Then go and check the health reports where it will probably say databases are running 'incompatibility mode'. This simple means they don't have latest schema.

    Bottom line? Run PSCONFIG to update everything.

    Thanks


    Thanks Robert Crane [MVP-Office365] www.ciaops.com

    Is this what you mean:

    Have not done anything yet wanted to wait your reply before i do things in the wrong order.

    Have to say we do not use sharepoint and not going to use it either. So i am a noob on sharepoint. But i do not like warnings in the BPA.

    So just say what i should do next

    domingo, 26 de febrero de 2012 12:22
  • Yup, See first entry under category? Databases require upgrade or a not supported. If you don't want to see that message, edit the alert and disable it. I have a feeling that the BPA uses powershell so will show an error unless you upgrade databases.

    As I said, if you want the error to go away in the BPA run PSCONFIG like you did for SP1, since most SharePOint patches these days also require changes to database schema. So you need to run PSCONFIG after ANY SharePoint 2010 update.

    Thanks


    Thanks Robert Crane [MVP-Office365] www.ciaops.com

    domingo, 26 de febrero de 2012 12:27
  • This is what you should do next:

    1. Open an Administrative command prompt.
    2. Change directory to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
    3. Run PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

    domingo, 26 de febrero de 2012 12:27
  • This is what you should do next:

    1. Open an Administrative command prompt.
    2. Change directory to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
    3. Run PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures


    Running the command now
    domingo, 26 de febrero de 2012 12:36
  • The command did end with an error.

    This are the messages in the event viewer:


    Log Name:      Application
    Source:        SharePoint 2010 Products Configuration Wizard
    Date:          26-02-2012 13:39:45
    Event ID:      104
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      WYVERN.tca.local
    Description:
    Failed to upgrade SharePoint Products.
    An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: The upgrade command is invalid or a failure has been encountered.
    Failed to upgrade SharePoint Products.
    Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.
       at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
       at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="SharePoint 2010 Products Configuration Wizard" />
        <EventID Qualifiers="0">104</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2012-02-26T12:39:45.000000000Z" />
        <EventRecordID>416344</EventRecordID>
        <Channel>Application</Channel>
        <Computer>WYVERN.tca.local</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Failed to upgrade SharePoint Products.
    An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: The upgrade command is invalid or a failure has been encountered.
    Failed to upgrade SharePoint Products.
    Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.
       at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
       at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()</Data>
      </EventData>
    </Event>

    Log Name:      Application
    Source:        SharePoint 2010 Products Configuration Wizard
    Date:          26-02-2012 13:39:45
    Event ID:      100
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      WYVERN.tca.local
    Description:
    Configuration of SharePoint Products failed.  Configuration must be performed in order for this product to operate properly.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\PSCDiagnostics_2_26_2012_13_36_17_932_602944375.log, fix the problem, and run this configuration wizard again.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="SharePoint 2010 Products Configuration Wizard" />
        <EventID Qualifiers="0">100</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2012-02-26T12:39:45.000000000Z" />
        <EventRecordID>416345</EventRecordID>
        <Channel>Application</Channel>
        <Computer>WYVERN.tca.local</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Configuration of SharePoint Products failed.  Configuration must be performed in order for this product to operate properly.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS\PSCDiagnostics_2_26_2012_13_36_17_932_602944375.log, fix the problem, and run this configuration wizard again.</Data>
      </EventData>
    </Event>

    Have no clue what to do about it.

    domingo, 26 de febrero de 2012 12:50
  • Can you get upgrade.log and PSCDiagnostics_2_26_2012_13_36_17_932_602944375.log [latest one] from


    c:\program files\common files\microsoft shared\web server extensions\14\logs


    to the public interface of your sky drive and post the link here?
    • Editado Jkazama domingo, 26 de febrero de 2012 18:34
    domingo, 26 de febrero de 2012 18:32
  • Have managed to get 1 SPDatabase oke now but have 1 left to upgrade.

    Its the WSS_Search_{servername} database.

    Have tried the PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures

    Did gave the same error.

    http://remote.npschouten.com/PSCDiagnostics_2_26_2012_20_7_31_854_1541656070.log.txt

    http://remote.npschouten.com/Upgrade-20120226-200916-884.log.txt

    http://remote.npschouten.com/Upgrade-20120226-200916-884-error.log.txt

    This are the log files created by PSConfig.

    do get this error in the event viewer now. Did not get it before.

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Foundation Search
    Date:          26-02-2012 20:25:34
    Event ID:      14
    Task Category: Gatherer
    Level:         Warning
    Keywords:     
    User:          TCA\spsearch
    Computer:      WYVERN.tca.local
    Description:
    The start address sts4s://remote.npschouten.com:987/contentdbid={aa81b4df-ee8b-427f-8b5f-662413d877c4} cannot be crawled.

    Context: Application 'Search_index_file_on_the_search_server', Catalog 'Search'

    Details:
     An unrecognized HTTP response was received when attempting to crawl this item. Verify whether the item can be accessed using your browser.   (0x80041204)
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation Search" Guid="{1C415899-58B3-4BFC-9236-105E7FD38719}" />
        <EventID>14</EventID>
        <Version>14</Version>
        <Level>3</Level>
        <Task>174</Task>
        <Opcode>0</Opcode>
        <Keywords>0x2000000000000000</Keywords>
        <TimeCreated SystemTime="2012-02-26T19:25:34.153966300Z" />
        <EventRecordID>417037</EventRecordID>
        <Correlation />
        <Execution ProcessID="7480" ThreadID="11632" />
        <Channel>Application</Channel>
        <Computer>WYVERN.tca.local</Computer>
        <Security UserID="S-1-5-21-114361916-2918527010-649005940-1162" />
      </System>
      <EventData>
        <Data Name="string0">sts4s://remote.npschouten.com:987/contentdbid={aa81b4df-ee8b-427f-8b5f-662413d877c4}</Data>
        <Data Name="string1">

    Context: Application 'Search_index_file_on_the_search_server', Catalog 'Search'

    Details:
     An unrecognized HTTP response was received when attempting to crawl this item. Verify whether the item can be accessed using your browser.   (0x80041204)</Data>
      </EventData>
    </Event>


    • Editado Schrudcher domingo, 26 de febrero de 2012 19:32
    domingo, 26 de febrero de 2012 19:29
  • Try to upgrade fram credentials:

    http://support.microsoft.com/kb/981487

    reboot,rename upgrade.log and run psconfig again.

    Also run following from admin sharepoint shell and post back the o/p:

    Repair-SPManagedAccountDeployment

    • Editado Jkazama martes, 28 de febrero de 2012 12:45
    martes, 28 de febrero de 2012 12:40
  • Hello!

    After installing cumulative update package KB2597014 I faced with same problem, I tried to run "PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures" this operation end on task number 5 with error.

    miércoles, 29 de febrero de 2012 10:42
  • Hi Jkazama

    Did upgrade farm credentials as put out in http://support.microsoft.com/kb/981487

    Did a cold reboot.

    After that i did run Repair-SPManagedAccountDeployment did not give any answer i just did get the prompt back.

    Then i started psconfig wizard but that failed again.

    to get things working again i need to start the following services by hand:

    World Wide Web Publishing Service

    Remote Desktop Gatway

    SharePoint 2010 Timer

    SharePoint 2010 VSS Writer

    In the event viewer i get this error

    Log Name:      Application
    Source:        Microsoft-SharePoint Products-SharePoint Foundation
    Date:          29-02-2012 13:33:29
    Event ID:      6398
    Task Category: Timer
    Level:         Critical
    Keywords:     
    User:          TCA\spfarm
    Computer:      WYVERN.tca.local
    Description:
    The Execute method of job definition Microsoft.SharePoint.Administration.SPUpgradeJobDefinition (ID e00144be-5f13-4b54-9939-d813cc0aba26) threw an exception. More information is included below.

    An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20120229-132424-376 was updated by TCA\spfarm, in the OWSTIMER (9820) process, on machine WYVERN.  View the tracing log for more information about the conflict.
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="Microsoft-SharePoint Products-SharePoint Foundation" Guid="{6FB7E0CD-52E7-47DD-997A-241563931FC2}" />
        <EventID>6398</EventID>
        <Version>14</Version>
        <Level>1</Level>
        <Task>12</Task>
        <Opcode>0</Opcode>
        <Keywords>0x4000000000000000</Keywords>
        <TimeCreated SystemTime="2012-02-29T12:33:29.046162900Z" />
        <EventRecordID>420423</EventRecordID>
        <Correlation ActivityID="{A3251361-369C-4CFF-823C-C78C5977D616}" />
        <Execution ProcessID="9820" ThreadID="12524" />
        <Channel>Application</Channel>
        <Computer>WYVERN.tca.local</Computer>
        <Security UserID="S-1-5-21-114361916-2918527010-649005940-1158" />
      </System>
      <EventData>
        <Data Name="string0">Microsoft.SharePoint.Administration.SPUpgradeJobDefinition</Data>
        <Data Name="string1">e00144be-5f13-4b54-9939-d813cc0aba26</Data>
        <Data Name="string2">An update conflict has occurred, and you must re-try this action. The object SPUpgradeSession Name=Upgrade-20120229-132424-376 was updated by TCA\spfarm, in the OWSTIMER (9820) process, on machine WYVERN.  View the tracing log for more information about the conflict.</Data>
      </EventData>
    </Event>

    Is it posible to remove sharepoint and the reinstall is, i now have the feeling that there are to much things changed of which i do not know if they are good or bad.

    miércoles, 29 de febrero de 2012 12:39
  • You can try and follow the repair guide:

    http://technet.microsoft.com/en-us/library/gg680310.aspx

    jueves, 01 de marzo de 2012 3:59
  • Not sure how i did it but it's fixed.

    All databases give needsupgrade  False 

    The last time i did run SPConfig i disabled the User Account Control.

    lunes, 05 de marzo de 2012 6:52
  • great :)

    now do you see that error/warning in BPA ?

    lunes, 05 de marzo de 2012 9:31
  • nope the warning is gone ;)

    but

    I stil have this massage :(

    So not sure if the whole problem is gone.

    miércoles, 07 de marzo de 2012 20:17
  • Can you reboot the server and check again?Also do check for any event for timer service after reboot...


    jueves, 08 de marzo de 2012 12:11