How To Fix SMMSS_ANALYZE010 - DB Error occured while trying to get/change collector status

SAP Error Message - Details

• Message type: E = Error

• Message class: SMMSS_ANALYZE - MSSQL Analysis and performance Tools

• Message number: 010

• Message text: DB Error occured while trying to get/change collector status

What causes this issue?

Database error while reading or changing the Collector status

System Response

Error while changing or selecting the status of the DB-Collector job

How to fix this error?

The error may be related to permission problems. The user who connected
to the database (maintained in table DBCON if your connection settings
aren't using the R/3-DEFAULT user), perhaps does not have the required
privileges (sysadmin server role) to delete the job.

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.