Manage Permissions User Role Assignments table fails to load with high volume of data

[basilv]

Describe the bug
With 10,000 user role assignments for a single application the user role assignments table fails to load with a 502 error. Lambda takes about 11+ seconds to respond (successfully), but has an error posting the result back to the API gateway.

Entries from log file:
Using ~5000 user role assignments still took a long time but returned successfully.

[ERROR] [1721076795143] LAMBDA_RUNTIME Failed to post handler success response. Http response code: 413.

File "/var/runtime/lambda_runtime_client.py", line 62, in post_invocation_result
rapid_client.post_invocation_result(invoke_id, result_data if isinstance(result_data, bytes) else result_data.encode('utf-8'), content_type)
RuntimeError: Failed to post invocation response
RequestId: fe26f07e-074b-43aa-9cd6-2abc6ee1e64a
Error
: Runtime exited with
error
: exit status 1
Runtime.ExitError

END RequestId: fe26f07e-074b-43aa-9cd6-2abc6ee1e64a

To Reproduce
Steps to reproduce the behavior:

1. Go to FAM Test environment
2. Go to Manage Permissions
3. Choose application "Fake application for load testing with realistic data volumes"

Discussion:
Overall solution is to add backend pagination and sorting

Acceptance Criteria:

• add backend pagination
• add backend sorting
• frontend table based on backend pagination
• update or add backend tests

Additional Context:
Separate tickets to be created for frontend search and filter
Likely implemented with new screen design