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
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
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.
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
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.
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
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
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.
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.
17 people are following this question.