Spam quarantine notifications are not sent out after update to 10.9.1

Products

• Messaging Gateway

Issue/Introduction

The Messaging Gateway has been updated to version 10.9.1 and users are no longer receiving spam quarantine notifications.

The Control Center logs contain an error similar to the following:

Jan 30 2025 11:25:01 [BrightmailScheduler_Worker-40] [SpamNotificationTask] ERROR - Notification poller error. A user could not be notified of new spam messages. 
com.symantec.smg.controlcenter.internal.dataaccess.DataAccessException: An unexpected database error has occurred. Please contact your system administrator. ; nested exception is: 
     java.sql.SQLException: Statement.executeQuery() command does NOT return a result-set as expected. Either use Statement.execute(), Statement.executeUpdate(), or correct command
    at com.symantec.smg.controlcenter.quarantine.QuarantineDAOMySQL.processNewSpam(QuarantineDAOMySQL.java:824)
    at com.symantec.smg.controlcenter.quarantine.spam.SpamNotificationManager.notification(SpamNotificationManager.java:185)
    at com.symantec.smg.controlcenter.quarantine.spam.SpamNotificationTask.executeTask(SpamNotificationTask.java:112)
    at com.symantec.smg.controlcenter.internal.scheduledtask.ScheduledTask.execute(ScheduledTask.java:133)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: Statement.executeQuery() command does NOT return a result-set as expected. Either use Statement.execute(), Statement.executeUpdate(), or correct command
    at org.mariadb.jdbc.Statement.executeQuery(Statement.java:178)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:316)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:316)
    at com.symantec.smg.controlcenter.quarantine.QuarantineDAOMySQL.processNewSpam(QuarantineDAOMySQL.java:749)
    ... 5 more

Resolution

This issue was addressed in patch 10.9.1-296 as well as in the 10.9.1 re-release. Install patch 296 if you encounter this issue with version 10.9.1 of the Messaging Gateway.

 

Additional Information

For information on patch management in the Messaging Gateway, please see this article:

Installing and removing patches for Messaging Gateway

 

How to Subscribe to a Broadcom knowledge article