[CMDB Remediation] De-Duplication Task OR any remediation related pages hangs when we click on "Remediate" buttonIssue <!-- div.margin { padding: 10px 40px 40px 30px; } table.tocTable { border: 1px solid; border-color: #e0e0e0; background-color: #fff; } .title { color: #d1232b; font-weight: normal; font-size: 28px; } h1 { color: #d1232b; font-weight: normal; font-size: 21px; margin-bottom: 5px; border-bottom-width: 2px; border-bottom-style: solid; border-bottom-color: #cccccc; } h2 { color: #646464; font-weight: bold; font-size: 18px; } h3 { color: #000000; font-weight: bold; font-size: 16px; } h4 { color: #666666; font-weight: bold; font-size: 15px; } h5 { color: #000000; font-weight: bold; font-size: 13px; } h6 { color: #000000; font-weight: bold; font-size:14px; } ul, ol { margin-left: 0; list-style-position: outside; } --> Symptoms When opening the Remediation Page it gets stuck in the Pop-Up page. Release All releases.. Environment Any Environment. Cause When we click the UI Action "Remediate" it calls a UI Page "cmdb_run_remediations" and this will call another backend page "$run_remediations". Mostly the slowness caused while we are loading the page $run_remediations. When we load this page it is querying table sys_schema_change in the background and this query is slowing the process.Possible slowness of this is addressed in PRB1255465. More details are given in the KB0696762 that have all the details. Resolution Please add the following index to speed things up: Table: sys_schema_change Fields: started, finished, duration Additional Information Remediate a de-duplication task