Error Server Failed to Resume Transaction

Affected Software/Reports/DLL(s): EDP

Affected Software Version: N/A

Symptoms: This error may occur in EDP during the Commit stage:

"System.Data.SqlClient.SqlException (0x80131904): The server failed to resume the transaction. Desc:5600000001.

The transaction active in this session has been committed or aborted by another session."

Cause/Details: This error typically occurs when a missing reference value does not exist in the EDD or database. Examples:

•When committing data bound for DT_EQUIPMENT_PARAMETER, data must be first populated in AT_EQUIPMENT_PARAMETER that ties together the PARAM_CODE to the EQUIPMENT_CODE.

•When committing data bound for RT_GROUP_MEMBER, data in MEMBER_TYPE must match value in RT_GROUP.GROUP_TYPE.

Resolution/Workaround: Review the EDD and update where necessary.