locked
SCCM Update - [Failed]:Upgrading ConfigMgr database. RRS feed

  • Question

  • Helou guys,

    I'm trying to update SCCM from version 1910 to version 2002, but getting an error:

    ERROR: Failed to execute SQL Server script: Changing datatype of column SubType on table MPE_RequestMessages_Discovery ERROR: SQL Server error: <> Failed to update database.

    Failed to apply update changes 0x87d20b15

    Datatype of column SubType column is tinyint, but should be int.

    Thanks for help



    • Edited by LuLaCeK Wednesday, July 1, 2020 12:43 PM
    Wednesday, July 1, 2020 11:54 AM

All replies

  • Opening a case with Microsoft support is the only recommendable path here. Altering the DB manually without guidance from CSS is asking for trouble and is itself unsupported.

    Jason | https://home.configmgrftw.com | @jasonsandys

    • Proposed as answer by Garth JonesMVP Thursday, July 2, 2020 12:32 AM
    Wednesday, July 1, 2020 3:34 PM
  • Hi,

    Agree with Jason, modifying the database yourself is not supported.
    Here is the link of CSS support:
    https://support.microsoft.com/en-us/hub/4343728/support-for-business 

    Regards,
    Allen

    Please remember to mark the replies as answers if they help.

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, July 2, 2020 3:05 AM
  • Hi,

    It seems there is no update for a couple of days. May we know the current status of the problem?
    Here's a short summary for the problem.

    Problem/Symptom:
    ===================
    When update SCCM from version 1910 to version 2002, get the error:
    ERROR: Failed to execute SQL Server script: Changing datatype of column SubType on table MPE_RequestMessages_Discovery

    Solution suggested:
    ===================
    Opening a case with Microsoft support.

    Regards,
    Allen

    "MECM" forum will be migrating to a new home on Microsoft Q&A!
    We invite you to post new questions in the "MECM" forum's new home on Microsoft Q&A!
    For more information, please refer to the sticky post.

    Tuesday, August 18, 2020 8:28 AM