question

kumaravelu-1265 avatar image
0 Votes"
kumaravelu-1265 asked Crystal-MSFT commented

SCOM 2019 Alert - Microsoft Audit Collection Services Collector Database Operation Failure

Hi Team,

We keep receiving the below mentioned warning alert in SCOM 2019.

Microsoft Audit Collection Services Collector Database Operation Failure
An error occurred while performing a database operation. The error code was 0x00000005

How can I fix it ?
Thanks in advance

Regards,
Kumar B

msc-operations-manager-general
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@kumaravelu-1265, For this Alert, it seems the database operation on ACS database is failed. Here, we suggest to check Operations manager event log to see if we can find more information.

0 Votes 0 ·

@kumaravelu-1265, Hope things are going well. I am writing to see if there's any update on our issue. If yes, feel free to let us know.

0 Votes 0 ·

Hi Crystal,

we see the below message in the event logs

Event ID 4620
Description: Database partition closed: Guid: 541a3396_5e08_411d_b04b_055596455fea Status: 0x00000005
We have two management groups one is for SCOM 2012 and the other one is for SCOM 2019
both the groups are different servers and all the agents reporting to both SCOM are multihomed.

Regards,
Kumar

0 Votes 0 ·
RogerXue-3369 avatar image
0 Votes"
RogerXue-3369 answered kumaravelu-1265 edited

As per Crystal-MSFT suggest, you should review operations manager event log for additional information on troubleshoot. Moreover, you may also refer to "ACS Database alert: An error occurred while performing a database operation. The error code was 0x00000005.".
https://social.technet.microsoft.com/Forums/lync/en-US/4e514e8c-f9d7-4add-8ea3-89f0a44c5fed/acs-database-alert-an-error-occurred-while-performing-a-database-operation-the-error-code-was?forum=operationsmanagergeneral
roger

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Roger,

We see the below error message

Event ID 4620
Description: Database partition closed: Guid: 541a3396_5e08_411d_b04b_055596455fea Status: 0x00000005

We have two management groups one is for SCOM 2012 and the other one is for SCOM 2019
both the groups are different servers and all the agents reporting to both SCOM are multihomed.

Regards,
Kumar

0 Votes 0 ·
Crystal-MSFT avatar image
0 Votes"
Crystal-MSFT answered Crystal-MSFT commented

@kumaravelu-1265, For this event, it may be caused by too much data in DTPARTITION Table. Here, please run SQL query "select * from dtpartition" to see how many rows are with status 1. If we have any that are left in a status = 1, then try to run the commands in the following link to changethe status to 2.
https://kevinholman.com/2008/03/07/scom-audit-collection-acs-internals/
Note: non-Microsoft link, just for the reference.

Hope it can help.


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.


· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Crystal,

We ran the following query to see partition details and Status.

select * from dtpartition order by partitionstarttime
But we see all the partitions status as "2"and one with "0" value only.

So what we can check further.

Regards,
Ravi shankar

0 Votes 0 ·

Hi Crystal,

Any other suggestions.

Regards,
Ravi shankar

0 Votes 0 ·

@kumaravelu-1265, Thanks for the reply. For our issue, we can check if there's any related error in Operations Manager event log. Meanwhile, could you let us know if there's any change before the error occur.

In addition, we can try to restart the SQL server and SCOM server to see if the result will be different.

0 Votes 0 ·
Show more comments