Error: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized

book

Article ID: 222725

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

Upgrade of the Symantec Endpoint Protection Manager (SEPM) fails to complete with error:

Error from the Upgrade-0.log

2021-08-23 19:09:30.638 THREAD 30 WARNING: Exception when truncateTxnLog by file ID with logical file name:Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.

2021-08-23 19:09:46.743 THREAD 30 WARNING: com.microsoft.sqlserver.jdbc.SQLServerException: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:262)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1632)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:602)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:524)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7375)

Cause

The customer SQL server was busy with other operation at the time the upgrade was attempted.

Environment

  • SEPM with SQL server

Resolution

After confirming that the SQL server is not performing operations such as a backup, you can run the "upgrade.bat" file from the SEPM installation bin folder to finish the upgrade process for the manager.