Example: Customer is deploying security data and receives error "BMXAA7387E - While attempting to retrieve 5001 of
APPLICATIONAUTH, the operation was terminated because the preset limit
5000 was exceeded for retrieving APPLICATIONAUTH into a single set.
Reduce the number of selected objects for the operation."
Target Environment System properties mxe.db.fetchResultLogLimit and mxe.db.fetchResultStopLimit are set to 5000 out of the box. The data from applicationauth exceeds the default values. This error can happen for any Object that the result set exceeds that preset limit.
Resolving the problem
In Target Environment System properties mxe.db.fetchResultLogLimit and mxe.db.fetchResultStopLimit should be increased to 12000 in this case. This can be done by increasing the Global Value, checking the properties, and then performing a Live Refresh.