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.