AppSync: Error while adding email addresses to alert settings if the string is over 255 characters.

Summary: When adding additional email addresses to alert settings for service plans we are getting this error:"org.hibernate.exception.DataException: could not execute statement."

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms



When adding additional email addresses to alert settings for service plans we are getting this error:"org.hibernate.exception.DataException: could not execute statement."            
 
Server logs:
 
02-13-2018 12:46:38.328 ERROR [default task-44] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [ServerName] [] ERROR: value too long for type character varying(255)
02-13-2018 12:46:38.328 ERROR [default task-44] [org.jboss.as.ejb3.invocation] [ServerName] [] WFLYEJxxxxx: EJB Invocation failed on component AWEntityServiceBean for method public com.emc.archway.datamodel.AWEntity

Cause

While adding the recipients email address to the alert settings for the particular service plan (Ex : Appsync UI screen / copy management / filesystem / host name / object in the Alert Setting button). You cannot enter a list of email addresses longer than 255 Characters.
 
As per the logs it is exceeding the maximum character limit of 255 characters. So, the total number of char combined from many email address should be 255 characters or less than that.

AppSync only allows a maximum of 255 characters for this field.

Resolution

  • You can remove any not required user from the list and proceed.
  • You can add the new user to the DL which is already exists.
  •  Raise enhancement request if customer is not ready to do both

Affected Products

AppSync

Products

AppSync
Article Properties
Article Number: 000057246
Article Type: Solution
Last Modified: 18 Sep 2025
Version:  4
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.