ConfigMgr 2012 SP1 CU3 Site Database Update Error

Fix ConfigMgr SCCM Site Database Update Error. You must be aware of the latest release SCCM 2012 SP1 cumulative update 3, by now. The CU3 was released on 20th Sep.

More information and download link here. In this post, I will explain an issue faced during CU3 installation.

I tried to install ConfigMgr (SCCM) 2012 SP1 CU3 in a lab environment created by somebody else. The wizard took “more” time to complete. It finished with a warning at the “Update Site Database” step.

FIX ConfigMgr SCCM Site Database Update Error

The log file “cm12-sp1cu3-kb2882125-x64-enu.log” was helpful to get the following errors. Where can you find this log-in SCCM (ConfigMgr) 2012 site server? OK, try “C:\Windows\Temp”. FIX ConfigMgr SCCM Site Database Update Error.

Patch My PC

The EXECUTE permission was denied on the object ‘fnIsPrimary’,database ‘CM_LAB’, schema ”dbo’

Task status detail added: A SqlException occurred, Line Number: 44Error: 229 Message: The EXECUTE permission was denied on the object ‘fnIsPrimary’, database ‘CM_LAB’, schema ‘dbo’

Task ‘Perform Database Update’ completed. state is ‘warning’ LastStatus: A SqlException occurred, 44Error: 229 Message: The EXECUTE permission was denied on the object ‘fnIsPrimary’, database ‘CM_LAB’, schema ‘dbo’

setup exit status 3001 (task State: warning)

Yes, from the errors themselves, we can determine that this is something to do with SQL permissions. So I checked whether my account has all the permissions needed for SQL DB update. FIX ConfigMgr SCCM Site Database Update Error.

SysAdmin server role was missing, and I added that server role to my account. Now, how to update the SCCM / ConfigMgr DB manually? ConfigMgr SCCM Site Database Update Error.

Ok, how to update CU3 again? Reapply CU3 for the Site database update, which failed earlier? No! You can update the site database manually with the update.sql file.

This file is located following location “Program Files\Microsoft Configuration Manager\hotfix\KB2882125\update.sql”. ConfigMgr SCCM Site Database Update Error?

Adaptiva

When you’re trying to run a update.sql file from a remote SQL server, you may get the following error as the dll files are missing from the SQL server. In that case, you need to edit the SQL file to point the ddl file’s UNC path (on the primary server).

Msg 6502, Level 16, State 7, Line 2

CREATE ASSEMBLY failed because it could not read from the physical file ‘[[SMS_ROOT]]\bin\x64\MessageHandlerService.dll’: 50(failed to retrieve text for this error. Reason: 15105).

Msg 6528, Level 16, State 1, Procedure fnCompressData, Line 10

Assembly ‘MessageHandlerService’ was not found in the SQL catalog of database ‘CM_LAB’.

Msg 6528, Level 16, State 1, Procedure fnConvertBase64StringToBinary, Line 10

Assembly ‘MessageHandlerService’ was not found in the SQL catalog of database ‘CM_LAB’

Free SCCM Training Part 1 | 17 Hours Of Latest Technical Content | ConfigMgr Lab HTMD Blog (anoopcnair.com)

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…

12 thoughts on “ConfigMgr 2012 SP1 CU3 Site Database Update Error”

  1. Most of update.sql ran, but I got the CREATE ASSEMBLY error. The SCCM database is on a remote server, so I did as you recommended and changed the SMS_ROOT path to a UNC path in update.sql, but received the following Access Denied message in the script results:


    Msg 6501, Level 16, State 7, Line 2
    CREATE ASSEMBLY failed because it could not open the physical file “\\xxxxmsrv\c$\Program Files\Microsoft Configuration Manager\bin\X64\messagehandlerservice.dll”: 5(Access is denied.).
    Msg 6528, Level 16, State 1, Procedure fnCompressData, Line 10
    Assembly ‘MessageHandlerService’ was not found in the SQL catalog of database ‘CM_XXX’.

    I’m able to log on to the sql server using the same credentials under which update.sql script was run, and I’m able to manually access the file via UNC. Any ideas?

    Reply
  2. Yes, I did. The solution was to copy mwssagehandlerservice.dll to c:\temp on the remote sql server and modify update.sql to look local versus looking remove via unc. Thanks for all your posts anoop. You’ve saved me a lot of time. Appreciate your contributions to the community!

    Reply
  3. I don’t have access right to SQL database and have to ask the SQL administrator run the update.sql for me after modifying the path for messagehandlerservice.dll. I got emailed that the script has been successfully run but how do I check if the site databases actually updated?

    Reply
  4. Hi All,

    environment: SCCM 2012R2 / SQL 2008R2
    Just follow all the steps to apply CU4 but when it comes to updating SQL i’m getting following errors: Could someone please advise re solving the problem?

    Msg 2812, Level 16, State 62, Line 1
    Could not find stored procedure ‘k’.
    Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 41
    Invalid column name ‘TransportType’.
    Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 46
    Invalid column name ‘TransportType’.
    Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 49
    Invalid column name ‘TransportType’.

    (0 row(s) affected)
    Msg 208, Level 16, State 6, Procedure v_ContentDistributionReport_G, Line 2
    Invalid object name ‘v_ContentDistributionReport_G’.

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (2 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (2 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (2 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (1 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    (0 row(s) affected)

    Reply
    • So what was the end result of the SCCM 2012 R2 CU4 update ? Is it failed or partially successful? Have you tried the SQL script which is available as .SQL file in the source of CU4?

      Regards
      Anoop

      Reply
      • my post above seems to be the end result so far. did run the mgm console and everything looks OK.
        my only concern are the ‘errors’
        Msg 2812, Level 16, State 62, Line 1
        Could not find stored procedure ‘k’.
        Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 41
        Invalid column name ‘TransportType’.
        Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 46
        Invalid column name ‘TransportType’.
        Msg 207, Level 16, State 1, Procedure spAddRecoveryTrackingRecord, Line 49
        Invalid column name ‘TransportType’.

        thanks

      • Sorry, I don’t have much details about the stored procedure “spAddRecoveryTrackingRecord” and column name “TransportType”. Two options left as per my knowledge. 1) if you think the DB upgrade didn’t go well then you can try running the SQL files which is available in CU4 source to update the DB. 2) call CSS for more help as editing DB manually is not a supported scenario.

        Regards
        Anoop

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.