Error: 'The DELETE statement conflicted with the SAME TABLE REFERENCE constraint ELEM_YR_COST_ELE_YEAR_COST_FK'

This is a known issue, but there's a workaround.

To work around it, follow these steps:

You'll see the error profile in the logs. If you take your error ID into Configuration Tools and click the Error Log button, you’ll see the full stack trace. Here's the key line to look out for:

'Cause: java.sql.SQLException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "ELEM_YR_COST_ELE_YEAR_COST_FK". The conflict occurred in database "moslive", table "dbo.ELEMENT_YEAR_COSTS", column 'ELEMENT_YEAR_COST_ID'