This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 71%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Hi,
I am using SCONM2012 R2 version.
From recent time i am getting below error continuously:-
Performance data collection process unable to write data to the Data Warehouse :-Performance data collection process unable to write data to the Data Warehouse. Failed to store data in the Data Warehouse. The operation will be retried. Exception 'SqlException': The transaction log for database 'OperationsManagerDW' is full due to 'LOG_BACKUP'. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance name
We have also done Database grooming recently. What will be the solution for this??
Regards,
Ravi
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.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Hi Ravi,
From the error message, it seems the transaction log for database 'OperationsManagerDW' is full. Here, please go to Microsoft SQL Server Management Studio, connect to the instance where the database 'OperationsManagerDW' exists, right click the database 'OperationsManagerDW', choose Properties, check if the Autogrowth is enabled under Files.
Meanwhile, please also check the free space of the drive where logfile stored is enough.
In addition, take a full backup of these database to shrink the log files may also be help.
Hope it can help.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 55.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA3%3C/text%3E%3C/svg%3E)
@Ravi bhushan - was the given solution helped you ? Could you please update here because im also facing the same issue in our environment and we are using SCOM 2019 with UR4.