Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option. : spRethrowError

Muhammed Ali 96 Reputation points
2021-08-11T10:14:45.587+00:00

Configuration manager dosent load any updates in console.
Wsync log show this error :SQL Server]Error severity levels greater than 18 can only be specified by members of the sysadmin role, using the WITH LOG option. : spRethrowError

Microsoft Configuration Manager
{count} votes

Accepted answer
  1. Muhammed Ali 96 Reputation points
    2021-08-19T00:30:52.71+00:00

    I apologize for the delay

    SCCM database was corrupted and which was causing this error in wsyncmgr.log

    re-install the software update point role didn't solve the issue.


    On SQL server event logs reported below error

    Table error: Object ID 0, index ID "-1," partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:277003) contains an incorrect page ID in its page header. The PageId in the page header


    turned off the SCCM server (which was not necessary )

    on SQL server run the below command to check for errors

    DBCC CHECKDB

    Error


    Msg 8939, Level 16, State 98, Line 1
    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3667181342891245568 (type Unknown), page (7791:-1694668604). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -12.


    to fix the errors, used the below command.


    USE [master];
    GO

    ALTER DATABASE houseme SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    DBCC CHECKDB(N'houseme', REPAIR_ALLOW_DATA_LOSS);
    ALTER DATABASE houseme SET MULTI_USER;

    the issue was resolved, took a backup of SQL DB and SUSDB

    this is the first time I am posting, please don't mint the format.


2 additional answers

Sort by: Most helpful
  1. Simon Ren-MSFT 34,021 Reputation points Microsoft Vendor
    2021-08-17T09:16:19.767+00:00

    Hi,

    Thanks for posting in Microsoft Q&A forum.

    1,Is the software update point healthy in your environment? Please help check the SMS_WSUS_SYNC_MANAGER component in the Component Status node. Also review the wcm.log, wsusctrl.log and wsyncmgr.log to see if there is any further information.

    2,If possible, please remove and re-install the software update point. Then configure and initiate SUP synchronization. Please refer to:
    Complete Guide to Install SCCM Software Update Point Role
    Note: The non-Microsoft link is just for your reference.

    Best regards,
    Simon


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.