Error Data Warehouse configuration synchronization process failed to write data after restore SCOM

Sébastien Lagueux 146 Reputation points
2021-06-22T18:32:38.137+00:00

Hello, I had to restore SCOm to another server, as well as the OperationManager and OperationManagerDW databases. After changing the passwords of the Run As accounts, I still have this error:

Event ID 31552
Failed to store data in the Data Warehouse.
Exception 'SqlException': Cannot resolve collation conflict for not equal to operation.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.Configuration
Instance name: Data Warehouse Synchronization Service
Instance ID: {55531A24-64FA-643B-6027-89A07538C191}
Management group: XXX

What to do? Thank you!

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,409 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Leon Laude 85,641 Reputation points
    2021-06-22T18:47:41.127+00:00

    Hi @Sébastien Lagueux ,

    What SQL Server collation are you using on the new server where you restored your SCOM database & data warehouse? It sounds like your new server has a different collation or an unsupported collation perhaps.

    https://techcommunity.microsoft.com/t5/system-center-blog/clarification-on-sql-server-collation-requirements-for-system/ba-p/346198

    ----------

    If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

    Best regards,
    Leon


  2. System Center guy 686 Reputation points
    2021-06-23T04:32:44.317+00:00

    As per error said, the issue may be come from collation different between old SQL server and new SQL server.

    Set or Change the SQL Server Collation
    https://learn.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-server-collation?view=sql-server-ver15

    Moreover, make sure that your follow

    1. How to move the Operational database
      https://learn.microsoft.com/en-us/system-center/scom/manage-move-opsdb?view=sc-om-2019

    2) How to move the Reporting data warehouse database
    https://learn.microsoft.com/en-us/system-center/scom/manage-move-omdwdb?view=sc-om-2019

    Roger

    0 comments No comments