DLFileRank related exception when accessing Document Library

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP3 (5.2.7)
• Component/s: DM
• Labels: None
• Environment: All

A "org.hibernate.StaleStateException: Batch update returned unexpected row" exception may occur when accessing documents in the Document Library.

More specifically, DLFileRank is used to keep track of the last 5 documents accessed by a user. When the user accesses a document the oldest DLFileRank is deleted. However, if multiple threads or multiple cluster attempts to remove the same DLFileRank, the above exception will occur.

This exception is a little misleading since there is no real problem in deleting the same DLFileRank multiple times. So to address this issue, the exception has been turned into a warning in the logs.

An alternative solution is to disable file ranks by setting the following in portal(-ext).properties.

dl.file.rank.enabled=false