Duplicate entry error is thrown when going to Account Settings

• Type: Regression Bug
• Status: Closed
• Resolution: No Longer Reproducible
• Affects Version/s: 7.0.X EE, Master
• Fix Version/s: None
• Component/s: My Account
• Labels:
  • QA-AUTOMATION
  • QA-V
• Story Points: 1
• Fix Priority: 3
• QA Test Name:
  • CPDocumentum#AddAllDocumentTypes
  • CPDocumentum#DeleteCheckedoutDocument
  • CPDocumentum#DeleteDocumentInSubfolder
  • CPDocumentum#EditDocumentFile
  • CPDocumentum#EditDocumentTitleRemoveFileExtension
  • CPDocumentum#MoveDocumentToHome
  • CPDocumentum#SearchDocumentViaHome
  • CPDocumentum#ViewRepository
  • CPPagetemplates#LocalizeDefaultPageTemplates
  • CPSharepoint#CheckinDocument
  • CPSharepoint#DeleteDocumentInSubfolder
  • CPSharepoint#MoveCheckedoutDocumentToFolder
  • CPSharepoint#MoveDocumentToHome
  • CPSharepoint#SearchDocumentViaHome
  • CPSharepoint#ViewEditedCheckedoutDocument
  • CPSharepoint#ViewRepository
  • CPSitetemplates#LocalizeDefaultSiteTemplates
  • MessageboardsUsecase#ViewMBThreadAndReplyThreadInGmail
  • PGSharepoint#ViewDocumentAsGuest
  • XssUsecase#ViewBookmarkNoXSS
• QA Test Score: 88

Steps to reproduce:

1. Start a clean bundle
2. Go to My Account > Account Settings

Actual result:
Duplicate entry error is thrown(only occurs on the first time):

05:21:00,848 ERROR [http-nio-8080-exec-5][JDBCExceptionReporter:234] Duplicate entry '20156-general' for key 'IX_BA4413D5'
05:21:00,863 ERROR [http-nio-8080-exec-5][BaseJSPFormNavigatorEntry:54] Unable to include JSP /user/announcements.jsp
org.apache.jasper.JasperException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into AnnouncementsDelivery (companyId, userId, type_, email, sms, website, deliveryId) values (?, ?, ?, ?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:440)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:473)
	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:377)
...
...
05:21:03,536 ERROR [http-nio-8080-exec-5][IncludeTag:128] Current URL /group/control_panel/manage?p_p_id=com_liferay_my_account_web_portlet_MyAccountPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_auth=a4qNaWKo generates exception: An exception occurred processing JSP page /html/taglib/ui/form_navigator/lexicon/sections.jspf at line 37____34: 			<aui:fieldset id="<%= _getSectionId(formNavigatorEntry.getKey()) %>">__35: __36: 				<%__37: 				PortalIncludeUtil.include(__38: 					pageContext,__39: 					new PortalIncludeUtil.HTMLRenderer() {__40: ______Stacktrace: [Sanitized]
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '20156-general' for key 'IX_BA4413D5'
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1040)
...

Expected result:
No error is thrown on the console.