[Task]: deploy & run load-transform in production

[jamesbursa]

Summary

Deploy the latest code to production and run the load-transform job in production.

Troubleshoot and fix any errors or issues. Verify that the database looks right.

Acceptance criteria

• Code has been run in production.
• Fixes have been made and/or follow up tickets created.

[jamesbursa]

Deployment was successful (https://github.com/HHS/simpler-grants-gov/releases/tag/2024.5.9-1) after setting up schemas #1848.

The foreign tables were created manually.

Then executed the load using:

bin/run-command.sh api prod '["flask", "--app=src.app:create_app", "data-migration", "load-transform", "--load", "--no-transform", "--no-set-current"]'

It was successful on the following tables:

• "tforecast"
• "tforecast_hist"
• "tapplicanttypes_forecast"
• "tapplicanttypes_forecast_hist"
• "tfundactcat_forecast"
• "tfundactcat_forecast_hist"
• "tfundinstr_forecast"
• "tfundinstr_forecast_hist"
• "topportunity"
• "topportunity_cfda"

Failed on tables:

• "tsynopsis" - psycopg.errors.FdwUnableToCreateExecution: error fetching result: OCIStmtFetch2 failed to fetch next result row / DETAIL: ORA-01555: snapshot too old: rollback segment number 21 with name "_SYSSMU21_2881811878$" too small