That was the only error and it got solved after recreating the corresponding view.

Thanks a lot GAIL for your post and article.

HI,

I recieved this error when update stats failed and i picked this error no from the logs.

It says

update stats failed -2147218798

Just wanted to confirm the column in tran_lock

is it request_owner_guid or request_owner_lockspace_id or lock_owner_address for that unique identifier column

It is specified as NOTHING in sys.databases.