Application error when copying a favorite report with a long name.

Products

• Messaging Gateway

Issue/Introduction

When attempting to copy a favorite report with a name longer that 254 characters, the Messaging Gateway Control Center generates an application error page and does not copy the favorite report.

Oct 28 2015 18:27:24 [http-bio-41443-exec-4] [ExceptionHandler] ERROR -
com.symantec.smg.controlcenter.BrightmailException: null ; nested exception is:
         com.symantec.smg.controlcenter.internal.dataaccess.DataAccessException: An unexpected database error has occurred. Please conta
ct your system administrator. ; nested exception is:
         com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at row 1
        at com.symantec.smg.controlcenter.reporting.favorite.FavoriteReportManager.addFavoriteReport(FavoriteReportManager.java:147)
        at com.symantec.smg.controlcenter.reporting.favorite.ReportFavoritesAction.copyFavorite(ReportFavoritesAction.java:833)

Cause

The name of the report is too long for the database table column that is used to store information on favorite reports.

Resolution

This is a known issue and will be addressed with a future release.

Please subscribe to this article to be automatically notified of any changes to this document.

Workaround

Limit the name of favorite reports to 254 characters or less.