SharePoint Enterprise 2013 CU ​October 2022 (​15.0.5493.1000)? SubscriptionSettings Database "Database is too old and upgrade is required"

Marc Cumos 126 Reputation points
2022-12-03T05:10:41.967+00:00

All,

Just did patched my farm with the CU
SharePoint Enterprise 2013 CU ​October 2022 (​15.0.5493.1000)
https://support.microsoft.com/en-us/topic/october-11-2022-cumulative-update-for-sharepoint-enterprise-server-2013-kb5002283-f3313d32-f6aa-4964-8f01-4423ebc8a264

During installation all went well.
No issues, no errors.

After installing binaries, I ran the PSConfig on all members in the farm. I also did windows updates, only on windows and not any products.

I then checked the status and all looked okay. I checked the Manage Databases Upgrade Status and saw this.

That the "Microsoft SharePoint Foundation Subscription Settings Database Database is too old and upgrade is required"

I then cleared the SP cache. I rebooted all machines. I also ran PSConfig again on all members. No dice.

I then checked the logs on my application server to see if it failed, or any issues.

I see the mentions of the SubscriptionSettings DB, and it looks good. See logs below. 

12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5h DEBUG Calling get SchemaVersion on Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5i DEBUG Returning SchemaVersion [15.0.4.0] for Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5h DEBUG Calling get SchemaVersion on Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5i DEBUG Returning SchemaVersion [15.0.4.0] for Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyxg DEBUG UpgradableBuildBypassInternal = 0 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyxh DEBUG UpgradableBuildBypass = 0 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession ajxmf DEBUG CanUpgrade [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] returned: True. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession ajxnh DEBUG [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] IsGrown=False IsRoot=False IsLeaf=True. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyxv DEBUG [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] NeedsUpgrade = true, BuildVersion = 15.0.5423.1000, TargetBuildVersion = 15.0.5493.1000. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession ajxmv DEBUG NeedsUpgrade [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] true because of upgrader [Microsoft.SharePoint.Upgrade.SPSubscriptionSettingsDatabaseSequence] 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession ajxmx DEBUG NeedsUpgrade [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] returned: True. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession ajxni DEBUG Upgrading [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings]. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession alooq DEBUG Entering IUpgrader.PreUpgrade() for upgrader [Microsoft.SharePoint.Upgrade.SPSubscriptionSettingsDatabaseSequence] on object [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5h DEBUG Calling get SchemaVersion on Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5i DEBUG Returning SchemaVersion [15.0.4.0] for Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajywv DEBUG Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession aloor DEBUG Exiting IUpgrader.PreUpgrade() for upgrader [Microsoft.SharePoint.Upgrade.SPSubscriptionSettingsDatabaseSequence] on object [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPUpgradeSession aloos DEBUG Entering IUpgrader.Upgrade() for upgrader [Microsoft.SharePoint.Upgrade.SPSubscriptionSettingsDatabaseSequence] on object [SPSubscriptionSettingsDatabase Name=SP_SubscriptionSettings] 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy6q DEBUG Performing database upgrade for the Subscription Settings Database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.52 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence al2ph DEBUG Executing SQL DDL Script. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.56 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence al2ph DEBUG Executing SQL DDL Script. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence al2ph DEBUG Executing SQL DDL Script. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence al2pf DEBUG Done setting the database compatibility level to 100. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5h DEBUG Calling get SchemaVersion on Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5i DEBUG Returning SchemaVersion [15.0.4.0] for Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5h DEBUG Calling get SchemaVersion on Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5i DEBUG Returning SchemaVersion [15.0.4.0] for Database SP_SubscriptionSettings, Status = Upgrading. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence alooz DEBUG Entering Upgrade Action Sequence 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence aloo2 DEBUG Exiting Upgrade Action Sequence 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.61 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy5k DEBUG Setting database AUTO_CLOSE to OFF. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.63 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy6r DEBUG Successfully completed database upgrade for the Subscription Settings Database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.63 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy6s DEBUG Refreshing stored procedures and functions for the Subscription Settings Database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.63 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzm DEBUG Parsing stored procedures and functions from [C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\Template\sql\subscriptionsettings.sql]. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.63 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzr DEBUG Found 15 stored procedures and 0 functions. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.63 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzb DEBUG Retrieving the definition for user-defined modules from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_PutPropertySet] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetPropertySet] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_DropPropertySet] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetSubscriptionPropertySet] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_SetSubscriptionMapping] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_DropSubscriptionMapping] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_SetSubscriptionPropertySet] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetPropertySetIdsByType] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetSiteSubscriptions] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetSubscriptionPropertySetId] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_GetSubscriptionMetadata] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_PutSubscriptionMetadata] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_DeleteSubscriptionMetadata] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_DefragmentIndices] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyzd DEBUG Retrieving the definition for [proc_UpdateStatistics] from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajyy6 DEBUG Retrieving stored procedure and function names from the database. 00000000-0000-0000-0000-000000000000  
12/02/2022 21:59:17.64 PSCONFIG (0x2050) 0x10A8 SharePoint Foundation Upgrade SPSubscriptionSettingsDatabaseSequence ajy6t DEBUG Successfully refreshed stored procedures and functions for the Subscription Settings Database. 00000000-0000-0000-0000-000000000000

Is this a visual bug?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,236 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,818 questions
Accepted answer
  1. Yanli Jiang - MSFT 21,611 Reputation points Microsoft Vendor
    2022-12-05T02:24:41.82+00:00

    Hi @Marc Cumos ,
    Great to know that and thanks for sharing the update here.

    By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

    [Bug in SharePoint Enterprise 2013 CU ​October 2022 (​15.0.5493.1000)? SubscriptionSettings Database "Database is too old and upgrade is required"]

    Issue Symptom:
    Just did patched my farm with the CU
    SharePoint Enterprise 2013 CU ​October 2022 (​15.0.5493.1000)
    https://support.microsoft.com/en-us/topic/october-11-2022-cumulative-update-for-sharepoint-enterprise-server-2013-kb5002283-f3313d32-f6aa-4964-8f01-4423ebc8a264

    During installation all went well.
    No issues, no errors.

    After installing binaries, I ran the PSConfig on all members in the farm. I also did windows updates, only on windows and not any products.

    I then checked the status and all looked okay. I checked the Manage Databases Upgrade Status and saw this.

    That the "Microsoft SharePoint Foundation Subscription Settings Database Database is too old and upgrade is required"

    Current status:
    Resolved. Somehow I needed to give the SP_farm account permissions in sql to the subscriptionsettings database.
    Event viewer was showing "CREATE TABLE permission denied in database 'SP_SubscriptionSettings'."

    You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information when reading this thread. Thanks for your understanding!

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest