[Infra] Unable to delete an agency that used to have a user in it.

[mhuang-usdr]

Expected behavior:

• I can delete any agency without users in it.

Current behavior:

• I can delete an agency that never had users in it.
• I cannot delete an agency that had a user in it, but the user was deleted. Console message:

fetchApi.js:41 DELETE https://api.grants.usdigitalresponse.org/api/organizations/0/agencies/del/1 500 g @ fetchApi.js:41 deleteAgency @ agencies.js:26 (anonymous) @ vuex.esm.js:851 y.dispatch @ vuex.esm.js:516 dispatch @ vuex.esm.js:406 F.forEach.n.<computed> @ vuex.esm.js:1064 (anonymous) @ EditAgency.vue:201 Promise.then (async) handleDelete @ EditAgency.vue:200 En @ vue.runtime.esm.js:3017 n @ vue.runtime.esm.js:1815 Co.i._wrapper @ vue.runtime.esm.js:7473

fetchApi.js:48 Uncaught (in promise) Error: {"status":500,"message":"Internal Server Error"} at fetchApi.js:48:40 (anonymous) @ fetchApi.js:48

[ed-snodgrass]

I tried this running locally (with Docker) and I was able to delete an Agency after adding a user and then deleting the user. I'm not suggesting this is fixed, just noting it worked locally. If this bug still exists then I'd be curious what the environment differences are between those databases.

[ClaireValdivia]

Thanks Ed, I'll do some testing to see if I can recreate

[ClaireValdivia]

tested and this seems to be working fine now! I had two users in an agency - confirmed that I could not delete the agency while the users were in it; but once the users were deleted, I successfully deleted the agency. closing this issue.