CI Relationship editor page fails to load and throws error "Maximum execution time exceeded"

Description

When editing a many-to-many related list, loading the list of "Available" records fails when there is already a large set of records "Selected", making users unable to modify certain many-to-many related lists.

M2MList ajax call fails with a large set of m2m_selected_ids values, generating the error:

"Error Message Information could not be downloaded from the server because the transaction was canceled

Reason: "maximum execution time exceeded"

Steps to Reproduce

Open a CI, for example server - cpesx-vpcm302.
Click on theasset CI relationships (+) icon.
Notice the three available resources that can be added to the relationship:

5. Click on the first relation, the page takes certain time and completes successfully.

6. Click on the second relation, observe the error:

"Error Message Information could not be downloaded from the server because the transaction was canceled

Transaction time: 15,649ms(varies)

Reason: "maximum execution time exceeded"

Workaround

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.

By default the Transaction Quota Rule (/nav_to.do?uri=sysrule_quota.do?sys_id=52b8381637d86700b097339b34990ec6) would be 15sec, the workaround would be to modify the Transaction Quota Rules to 20sec, or possibly higher, but not exceeding 35sec.

Related Problem: PRB1240595