Support Article
IS-IH Migration script runs for long and does not complete
SA-69131
Summary
Interaction Services (IS)-Interaction History (IH) Migration script is running for a long time.
The below query runs for more than two hours without completion. The script is run to migrate 5 million records.
UPDATE IS_FACT_RESPONSE_ROOT SET IS_FACT_RESPONSE_ROOT.ROOT_ID = (
SELECT CASE WHEN PARENT_ID IS NULL THEN FACT_RESPONSE_ID ELSE PARENT_ID END
FROM IS_FACT_RESPONSE
WHERE IS_FACT_RESPONSE_ROOT.ROOT_ID=IS_FACT_RESPONSE.FACT_RESPONSE_ID
) ;
The requirement is to remove the upgrade query from the script.
Error Messages
Not Applicable
Steps to Reproduce
Run the query.
Root Cause
Not Applicable
Resolution
The update query is in place to migrate the interactions set for Bundles and Multilevel decisions. If all IH entries have an empty parent_id field, it is safe to drop the update.
Tags:
Published January 3, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.