A Cascade Delete of several million records may cause memory issues.
Steps to Reproduce
1. Create a table A, with Cascade delete set.
2. Create a table B, that references table A.
3. Insert Record X into table A.
4. Insert 20,000,000 records into table B all referencing record X.
5. Delete Record X.
This problem is under review and targeted to be fixed in a future release. To receive notifications when more information becomes available, subscribe to this Known Error article by clicking the Subscribe button at the top right of this form.
In New York use the workaround of creating the new system property below:
Name = glide.db.table_factory.large.row_count_based
Value = true
Related Problem: PRB1326958