How To Fix CNV_DMC_HC060 - &1 - &2: Rec. to be processed in logging table &3 exceed threshold &4

SAP Error Message - Details

• Message type: E = Error

• Message class: CNV_DMC_HC -

• Message number: 060

• Message text: &1 - &2: Rec. to be processed in logging table &3 exceed threshold &4

What causes this issue?

The number of logging table entries found exceeds the given threshold
value.

System Response

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

How to fix this error?

In transaction LTRC, you can view the possible causes of the issue. On
the tabs <ZK>Table Overview</> and <ZK>Data Transfer Monitor</>, you can
choose the <ZK>View Errors</> pushbutton. On the tab <ZK>Application
Logs</>, you can also view the logs for the initial load and for the
replication process.
If you do not find any issues, we recommend monitoring the replication
process over a period of time. You can do this by using the expert
function <ZK>Display Replication Statistics</> (in transaction LTRC on
the tab <ZK>Expert Functions</>).
In addition, you can use the expert function <ZK>View Unprocessed
Logging Table Records</> to monitor the number of entries in the logging
table.
If there are consistently high latency values, there may be issues with
the connections to the source or target systems, or issues within the
operations executed in these systems.
If you see different latency values (maybe aligned your business hours),
it is likely that the amount of changes in the source system is higher
than what SAP Landscape Transformation Replication Server can transfer
with one job. If this is the case, options for improving latency include
filtering the data, or specifying ranges for the logging table (for more
information, see <ZK>Performance Options</> in transaction LTRS).

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CNV_DMC_HC060 - &1 - &2: Rec. to be processed in logging table &3 exceed threshold &4 ?

  The SAP error message CNV_DMC_HC060 typically relates to issues encountered during data migration processes, particularly when using the SAP Data Migration Cockpit (DMC). This specific error indicates that the number of records to be processed in a logging table has exceeded a predefined threshold.
  Cause:
  The error occurs when the number of records logged in a specific logging table exceeds the limit set by the system. This can happen due to various reasons, such as:
  
  A large volume of data being processed in a single migration run.
  Inefficient data processing or migration logic that leads to excessive logging.
  Configuration settings that define thresholds for logging tables being set too low.
  
  Solution:
  To resolve this error, you can consider the following steps:
  
  
  Increase the Threshold:
  
  Check the configuration settings for the logging tables and increase the threshold limit if possible. This can often be done in the DMC settings or through relevant configuration transactions.
  
  
  
  Batch Processing:
  
  Instead of processing all records in one go, break down the migration into smaller batches. This will help keep the number of records in the logging table below the threshold.
  
  
  
  Clean Up Logging Tables:
  
  If there are old or unnecessary records in the logging tables, consider cleaning them up to free up space and reduce the count of records.
  
  
  
  Review Migration Logic:
  
  Analyze the data migration logic to ensure it is efficient and does not generate excessive logging. Optimize the process if necessary.
  
  
  
  Monitor and Adjust:
  
  Continuously monitor the logging tables during migration processes and adjust the thresholds or batch sizes as needed based on the volume of data being processed.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that might provide additional insights or patches related to this error.
  Documentation: Review the SAP Data Migration Cockpit documentation for best practices on data migration and logging configurations.
  Support: If the issue persists, consider reaching out to SAP Support for assistance, providing them with the error details and any relevant logs.
  
  By following these steps, you should be able to address the CNV_DMC_HC060 error and continue with your data migration process effectively.