usdigitalresponse / arpa-reporter

Web app to aid government agencies in reporting on ARPA grants.
Apache License 2.0
3 stars 0 forks source link

[Partner submission] Validation Error for Subrecipient (warning vs error #362

Closed mhuang-usdr closed 2 years ago

mhuang-usdr commented 2 years ago

Hi, for our project 10002, I am still getting a validation error that is not a warning that prevents me from validating this file. Can you elaborate on what is causing the issue?

This is what I get:

unexpected error validating subrecipient: error: insert into "arpa_subrecipients" ("record", "tin", "uei", "upload_id") values ($1, $2, $3, $4) returning * - duplicate key value violates unique constraint "arpa_subrecipients_tenant_id_tin_unique"

The error text suggests that a duplicate subrecipient already exists, but the same error would have applied for project 10003 (also has subrecipients already in the system). The difference is that 10003 will allow me to validate with a warning, but 10002 will not.