VBR data purge not working - Error 2314 Failed to purge BackupFinalJob, BackupSkippedFile

Article:TECH160142  |  Created: 2011-05-16  |  Updated: 2011-08-15  |  Article URL http://www.symantec.com/docs/TECH160142
Article Type
Technical Solution


Subject

Issue



Daily scheduled data purge of BackupFinalJob and BackupSkippedFile failing with Error 2314 and Error 2293


Error



vbr-web0.0.log snippets:

Error 2314:

Error 2314: com.veritas.ccsvc.server.core.ServerException: Failed to purge BackupFinalJob
at com.veritas.ccsvc.server.core.dil.DatabaseObject.createServerException(DatabaseObject.java:142)
at com.veritas.ccsvc.server.core.dil.BaseSearch.executeUpdate(BaseSearch.java:280)
at com.veritas.ccsvc.server.core.dil.BaseSearch.executeUpdate(BaseSearch.java:291)
at com.veritas.ccsvc.server.core.dil.BackupFinalJobDIL$Search.purge(BackupFinalJobDIL.java:1334)
at com.veritas.ccsvc.server.tasks.DataPurgeTask.purge(DataPurgeTask.java:250)
at com.veritas.ccsvc.server.tasks.DataPurgeTask.run(DataPurgeTask.java:67)
at com.veritas.ccsvc.server.scheduler.RunnableTask.run(RunnableTask.java:151)
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -189: Unable to find in index 'backupSkippedFileReason_idx' for table 'BackupSkippedFile'

Error 2293:

2011/04/23 11:38:21 CDT INFO com.veritas.ccsvc.server.tasks.DataPurgeTask.purge Error while purging BackupSkippedFile Data
Error 2293: com.veritas.ccsvc.server.core.ServerException: Failed to purge BackupSkippedFile
at com.veritas.ccsvc.server.core.dil.DatabaseObject.createServerException(DatabaseObject.java:142)
at com.veritas.ccsvc.server.core.dil.BaseSearch.executeUpdate(BaseSearch.java:280)
at com.veritas.ccsvc.server.core.dil.BaseSearch.executeUpdate(BaseSearch.java:291)
at com.veritas.ccsvc.server.core.dil.BackupSkippedFileDIL$Search.purge(BackupSkippedFileDIL.java:354)
at com.veritas.ccsvc.server.tasks.DataPurgeTask.purge(DataPurgeTask.java:110)
at com.veritas.ccsvc.server.tasks.DataPurgeTask.run(DataPurgeTask.java:67)
at com.veritas.ccsvc.server.scheduler.RunnableTask.run(RunnableTask.java:151)
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -189: Unable to find in index 'backupSkippedFileReason_idx' for table 'BackupSkippedFile'

 


Environment



VBR 6.6.2 on Windows 2003 32-bit


Cause



Corrupted/missing index for the affected tables


Solution



Stop VBR Services
Open Sybase Central GUI
- connect to the DB
- navigate under Indexes to locate the index named  'backupSkippedFileReason_idx'
- right-click on the index and select REBUILD
- this will take some time to finish
Start VBR Serviices
Check the vbr web 0  logs to see if the purge is erroring out within the next 24 hours.
 




Article URL http://www.symantec.com/docs/TECH160142


Terms of use for this information are found in Legal Notices