question

MuhammedAli-5991 avatar image
0 Votes"
MuhammedAli-5991 asked ErlandSommarskog commented

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

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

mem-cm-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

What is your question? Can you clarify?

You mention "configuration manager" - is that System Center? If so, you may want to add a tag for System Center.

0 Votes 0 ·

Hi MuhammedAli-5991,

Welcome to Microsoft Q&A.
It seems you issue is more related to SCCM. I suggest you add a tag mem-cm-general to the thread to get more help.

Best Regards,
Amelia

0 Votes 0 ·
MuhammedAli-5991 avatar image
0 Votes"
MuhammedAli-5991 answered ErlandSommarskog commented

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.



· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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;


housename=database

0 Votes 0 ·

Hi,

Thank you very much for sharing! I think maybe other peoples with the same needs will benefit from it. Your solid technical skills are really impressive.

Have a nice day!

Best regards,
Simon

0 Votes 0 ·

DBCC CHECKDB(N'houseme', REPAIR_ALLOW_DATA_LOSS);

Note that this command does what it says. Basically, any pages it can't piece together it will just throw away. So with some bad luck, it leave one or more tables empty. You should definitely run DBCC CHECK_CONSTRAINTS to verify that you don't have any constraint violations.

Generally, in case of corruption, it is better to restore a backup. Have no backup? Make sure that you one next time!

...and speaking of next time. Corruption does not come out of the blue, but is always due to faulty hardware, often the I/O subsystem. So if the database is one the same disk as it was before, corruption could come back.

0 Votes 0 ·
SimonRenMSFT-3639 avatar image
0 Votes"
SimonRenMSFT-3639 answered

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.