After migrating Symantec Endpoint Protection Manager (SEPM) sites to 12.1 Release Update 4 (RU4), several Unexpected Server Error notifications are displayed in the Symantec Endpoint Protection Manager console Server Status pane during replications. These errors only occur on Managers using the embedded Sybase SQL Anywhere database.
The following error is written to the scm-server0/1.log:
SEVERE: Invalid query statement. in:
java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Not enough values for
at sybase.jdbc4.sqlanywhere.IConnection.nativePrepareStatement(Native Method)
A change was made to one of the database views in the RU4 database schema. During the migration process, the V_SEM_SVA_COMPUTER view is temporarily removed and then recreated. This causes the embedded database engine to invalidate the V_SEM_SVA_COMPUTER_NAME database view which queries information from V_SEM_COMPUTER.
The errors are cosmetic and do not affect the actual functionality of the manager, or replication.
Symantec is aware of this problem and will update this document when a solution becomes available.
To work around this problem, delete and recreate the V_SEM_SVA_COMPUTER_NAME database view using the following steps: