How To Fix CNV_DMC_HC091 - Job &1 (ID: &2): Job has been running for over 24 hours

SAP Error Message - Details

• Message type: E = Error

• Message class: CNV_DMC_HC -

• Message number: 091

• Message text: Job &1 (ID: &2): Job has been running for over 24 hours

What causes this issue?

The master job or the load job has been running for over 24 hours. This
indicates a possible hanging RFC connection or database connection.

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?

For Master Job (/1LT/IUC_REP_MSTR):
1.,,Deactivate all configurations to stop the master job.
2.,,In transaction SM37, check the master job (/1LT/IUC_REP_MSTR) and
make sure it stops.
3.,,Check the connection and ensure that the connection works properly.
4.,,Active the configurations, and check the master job in SM37 to make
sure it has been restarted.
For Load Job:
1.,,Deactivate the configuration.
2.,,In transaction SM37, manually stop the job.
3.,,Check the connection and ensure that the connection works properly.
4.,,In the transaction LTRC, reset the job status by using the Reset
Load and Replication Status function on the Expert Functions tab.
5.,,Active the configuration.

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_HC091 - Job &1 (ID: &2): Job has been running for over 24 hours ?

  The SAP error message CNV_DMC_HC091 indicates that a job related to the Data Migration Cockpit (DMC) has been running for more than 24 hours. This can occur during data migration processes, especially when dealing with large datasets or complex transformations.
  Cause:
  
  Large Data Volume: The job may be processing a significant amount of data, which can lead to extended processing times.
  Performance Issues: There may be performance bottlenecks in the system, such as insufficient resources (CPU, memory, I/O), or database performance issues.
  Inefficient Data Transformation Logic: The logic used for data transformation may not be optimized, leading to longer processing times.
  Locking Issues: There may be database locks or contention issues that are causing delays in processing.
  Configuration Issues: Incorrect configuration settings in the DMC or related components may lead to inefficiencies.
  
  Solution:
  
  Monitor Job Performance: Use transaction codes like SM37 to monitor the job's status and check for any specific errors or warnings.
  Analyze Resource Usage: Check system performance metrics (CPU, memory, disk I/O) to identify any bottlenecks. Tools like ST03N can help analyze workload and performance.
  Review Data Volume: If the job is processing a large volume of data, consider breaking it into smaller batches to reduce processing time.
  Optimize Data Transformation Logic: Review and optimize the data transformation logic to ensure it is efficient. This may involve simplifying transformations or using more efficient algorithms.
  Check for Locks: Use transaction codes like SM12 to check for any locks that may be affecting the job's performance.
  Adjust Job Parameters: If applicable, adjust the job parameters to optimize performance, such as increasing the number of parallel processes.
  Consult SAP Notes: Check for any relevant SAP Notes that may address known issues or provide guidance on optimizing DMC jobs.
  Restart the Job: If the job is stuck and not making progress, consider stopping and restarting it after addressing any identified issues.
  
  Related Information:
  
  Transaction Codes: SM37 (Job Monitoring), SM12 (Lock Entries), ST03N (Workload Analysis).
  SAP Notes: Search the SAP Support Portal for notes related to DMC performance issues or specific error messages.
  Documentation: Review the official SAP documentation for the Data Migration Cockpit for best practices and optimization tips.
  
  If the issue persists after trying the above solutions, it may be necessary to engage SAP support for further assistance.