Error loading the REFVALS EDD

<< Click to Display Table of Contents >>

EQuIS 7  >>  EDP > EDP Install, Configuration, Administration > EDP Troubleshooting >

Error loading the REFVALS EDD

Affected Software/Reports/DLL(s): EDP

 

Affected Software Version: N/A

 

Symptoms: This error may occur in EDP during the Commit stage while using the REFVALS EDD Format:

 

"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 the RT_GROUP_MEMBER.MEMBER_TYPE value in the EDD does not match code in the RT_GROUP.GROUP_TYPE field.

 

Resolution/Workaround: Review the EDD and update where necessary so that the RT_GROUP_MEMBER.MEMBER_TYPE value matches the same code as the parent RT_GROUP.GROUP_TYPE record.