Hi @Dev99 00 ,
It appears that you're having performance/communication problems between your SCOM management server(s) and SCOM Data Warehouse, what changes have been done recently in your SCOM environment? Any account changes?
I suggest first of all to follow the official documentation below that goes through one of your errors:
Troubleshoot event ID 2115-related performance problems in Operations Manager
Here's also a blog post about the exact same errors you're receiving:
SCOM 2012 R2 – DATA WAREHOUSE SERVICE ACCOUNT IS NOT ALLOWED TO ACCESS DATA WAREHOUSE DATABASE
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
The following events are apearing repeatly in event Viewer on operation Manger Servers:
31557=Failed to obtain synchronization process state information from Data Warehouse database,
31552=Failed to store data in the Data Warehouse.
31551= Failed to store data in the Data Warehouse. The operation will be retried.Exception 'SqlException': Login failed for user 'omaa'.
One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectEntityHealthStateChange
Can you also check the SQL logs to see what they say?
Here's an older thread from the TechNet forum with a similar issue:
Event 31551 Failed to store data in the Data Warehouse - The domain prefix is not attached to the Windows RunAs account