Failing Prod Build

[smcgregor]

The following incident translations are empty strings in production, which is causing a test failure and preventing the production build:

incident_id: 731, language: es

incident_id: 731, language: fr

incident_id: 731, language: ja

incident_id: 735, language: es

incident_id: 735, language: fr

incident_id: 735, language: ja

incident_id: 679, language: es

incident_id: 679, language: fr

incident_id: 679, language: ja

incident_id: 703, language: es

incident_id: 703, language: fr

incident_id: 703, language: ja

incident_id: 710, language: es

incident_id: 710, language: fr

incident_id: 710, language: ja

Example showing the empty strings in the DB:

Confirming the source data is not empty:

I confirmed that @datherton09 changed a record in question, which would trigger the re-translation: https://incidentdatabase.ai/incidents/history/?incident_id=731

So it would appear this is a translation service failure. Options include:

1. Deleting the offending records in the DB UI.
2. Running a migration a la 2025.09.09T12.00.00.delete-empty-translations.js

[smcgregor]

This problem has recurred on https://incidentdatabase.ai/cite/1245 which has a Norwegian article. I am going to run a migration one more time and see if I can find the failed translation in the build history.

[smcgregor]

More translation failures: https://github.com/responsible-ai-collaborative/aiid/actions/runs/24434077890/job/71384371092

Added a workflow to make it easier to clean them up: #3847

[smcgregor]

Removed via workflow: https://github.com/responsible-ai-collaborative/aiid/actions/runs/24490025652