Application error upon upgrade to 10.6.3-2

I need a solution

Hello,

We just upgraded our SMG to the latest version 10.6.3-2 and now we can’t access the control center.  When we access the web console (using admin account), it say that 

Application Error
Application Error
The application encountered an error. If you are the administrator, please check the log files for details.
Click here to return to the previous page 
 
                class com.symantec.smg.controlcenter.internal.dataaccess.DataAccessException: An unexpected database error has occurred. Please contact your system administrator. ; nested exception is: 
java.sql.SQLSyntaxErrorException: Unknown column ‘threat_defense’ in ‘field list’
at com.symantec.smg.controlcenter.internal.dataaccess.DAOHelper.executeQuery(DAOHelper.java:285)
at com.symantec.smg.controlcenter.reporting.ReportDAOMySQL.getStatisticDashboard(ReportDAOMySQL.java:849)
at com.symantec.smg.controlcenter.monitoring.dashboard.DashboardManager.retrieveMsgStatDetailed(DashboardManager.java:274)
at com.symantec.smg.controlcenter.monitoring.dashboard.DashboardManager.calculateTotals(DashboardManager.java:324)
at com.symantec.smg.controlcenter.monitoring.dashboard.DashboardFlow.buildPage(DashboardFlow.java:189)
at com.symantec.smg.controlcenter.monitoring.dashboard.DashboardFlow.view(DashboardFlow.java:106)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
It seems that database schema migration failed so that a column couldn’t be found.  I have full backups (previous version) available. Is there any solution other than reinstall OS and restore it from full backup?  Accessing spam quarantine console for users seems to be working fine.
 
Thank you,
 
0

Related:


Leave a Reply