SQLDataException: Out of range value for column 'id' at row 1 in the Control Center log file

book

Article ID: 225875

calendar_today

Updated On:

Products

Messaging Gateway

Issue/Introduction

A large number of SQL errors accumulate in the Control Center log file BrightmailLog.log, with new groups of errors appearing every six or seven minutes.

Jul 07 2021 14:38:58 [BrightmailScheduler_Worker-43] [SoftwareVersionHelper] ERROR - 
com.symantec.smg.controlcenter.internal.dataaccess.DataAccessException: An 
unexpected database error has occurred. Please contact your system administrator. ; 
nested exception is:
         java.sql.SQLDataException: Out of range value for column 'id' at row 1

Cause

One or more of the status tables in the SMG Control Center database has reached the upper limit for the id column and can no longer append new records.

Resolution

This is a known issue which will be addressed in a future release.