When using replication, the COMPARE DATA option allows users to identify any differences between a PARENT and a CHILD environment.

When customers have large volumes of data, e.g. 10,000 Inventory Items, the COMPARE DATA function needs to do a lot of work. This workload can be processor-intensive and cause the system to overload.

DESIGN CHANGE

To resolve the above-mentioned issue, we need to introduce an "API Wait Time" to allow the server to do complex work such as comparing multiple fields of records from two systems. This will allow the API to carry on doing its other work. This design is similar to "asynchronous" data processing systems that allow the processor to "breath" while other tasks are being performed. 

After the "WAIT Time", the API will continue with the initial Complex Task.

The default value will be set to 10 minutes.

1. The change will be available in version:12.43.0702

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

1. Introduced a new parameter in the integration called "APIWaitTime"
2. Added an "API Request Datetime" to the API Request queue
3. For all long-running processes, we leave the task in ASYNCHRONOUS mode and return the API connection. We check the QPI sync status after the "APIWaitTime" introduced in 2.1 above. If the task is still running, we wait a further "APIWaitTime" minutes. We mark the task as completed when the API returns in a "Completed State"

3. Affected Areas:

1. Compare Data Process

4. The issue was caused by:

1. Improvement

5. Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): System and UAT tests completed.