Fixing "An Unexpected Database Error" in Symantec Messaging Gateway

Products

• Messaging Gateway

Issue/Introduction

When creating a filter policy in Symantec Messaging Gateway, you might encounter the following error: 
An unexpected database error has occurred. Please contact your system administrator.

The Control Center logs show this error:
java.sql.SQLSyntaxErrorException: (conn=X) Data too long for column 'match_string' at row 1

Environment

SMG 10.X.X

Cause

The error occurs because the value being inserted into the match_string column exceeds the column's size limit of 255 characters.

Resolution

Ensure no condition or value exceeds 255 characters. If needed, shorten the string.