Individual contributions export issues

[JonellaCulmer]

What we're after
A user reported having issues exporting data from our individual contributions datatable. This has been difficult to replicate and multiple searches have been attempted.

Export attempt 1:

I was doing an individual contributor search. I have three variations on JPMorgan (JP Morgan, J.P. Morgan and JPMorgan). I'm looking at the current cycle and the last cycle.
I'd get the results, hit export, and after a long wait, the site gives me that error message.

https://www.fec.gov/data/receipts/individual-contributions/?contributor_name=J.P.+Morgan&contributor_name=JP+Morgan&contributor_name=JPMorgan&two_year_transaction_period=2024&two_year_transaction_period=2022

Export attempt 2:
https://www.fec.gov/data/receipts/?committee_id=C00364778&two_year_transaction_period=2024&cycle=2024&line_number=F3X-11AI&data_type=processed

Action items:

• Back-end and DB teams run these ^ queries and concurrently monitor the API and database

Completion criteria:

• Problem and findings are documented and followup fix tickets for are opened, as necessary

[tmpayton]

I ran the two queries above several times while monitoring the API and the logs. I was unable to replicate the error. The logs showed the downloads were successful.

3:48:05.493: [APP/PROC/WEB.6]127.0.0.1 - - [07/Aug/2023:17:48:05 +0000] "POST /v1/download/schedules/schedule_a/?sort_hide_null=false&sort_nulls_last=false&data_type=processed&committee_id=C00364778&two_year_transaction_period=2024&line_number=F3X-11AI&sort=-contribution_receipt_date HTTP/1.1" 200 360 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36"

13:42:27.034: [RTR.8] fec-prod-api.app.cloud.gov - [2023-08-07T17:42:22.473053613Z] "POST /v1/download/schedules/schedule_a/?sort_hide_null=false&sort_nulls_last=false&contributor_name=JPMorgan&contributor_name=JP+Morgan&contributor_name=J.P.+Morgan&two_year_transaction_period=2024&two_year_transaction_period=2022&sort=-contribution_receipt_date&is_individual=true HTTP/1.1" 200 49 20 "-" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36"

I'd recommend that we close this issue since it can't be replicated.