Share via

SQL Server Error in SCCM

Rafael Aguilar 496 Reputation points
2021-02-04T20:25:34.557+00:00

Good Afternoon Team.

In my client I have a lot of SQL server alerts, I don't know why this is happening and I don't know where to start.

Can you help me please?

Thank you.

64075-image.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,867 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Guoxiong 8,126 Reputation points
    2021-02-04T21:00:14.57+00:00

    Check "spOfficeReadinessCalculationTask" and see if it tries to truncate the table "EntityReadiness" which is replicated for the replication? If yes, you are not able to truncate it.

    0 comments
  2. AllenLiu-MSFT 41,136 Reputation points Microsoft Vendor
    2021-02-05T05:43:26.407+00:00

    @Rafael Aguilar
    Thank you for posting in Microsoft Q&A forum.
    It's recommended to open a support case for this issue, because it could be related to change the database.
    If we change the database manually, it may affect our ability to get support from Microsoft in the future.

    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
  3. Rafael Aguilar 496 Reputation points
    2021-02-05T17:57:43.04+00:00

    Check "spOfficeReadinessCalculationTask" and see if it tries to truncate the table "EntityReadiness" which is replicated for the replication? If yes, you are not able to truncate it.

    Could you tell me how to do that and excuse me.

    0 comments