RLC: "I have an approval waiting" notification gives error: Failed to format e-mail message - query did not return a unique result

ID:    D25228
Published:    25 December 2017
Updated:    07 December 2018

Defect Id


Originally Reported Against

Release Control 6.2

Resolved In

Release Control 6.2.3


ERROR 22-12-2017 09:29:30 [Events] -- Failed to format e-mail message. 
org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 2
 at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(
 at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(
 at org.springframework.orm.hibernate4.HibernateTemplate.execute(
 at com.serena.sbm.persistence.NotificationResponseDAOImpl.getResponseByNotificationIdAndName(
ERROR 22-12-2017 09:29:30 [Events] -- An error occurred while processing the 'A - I have an approval waiting' notification for the 'xxx' user. 


Check the email response for the problematic notification to make sure no duplicate sets of email response for the same name.

Find Answers

Type a question or describe what you are looking for below

My Recent Searches

Welcome kb sso

Additional Assistance

  • Submit a Case Online
  • FAQs