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 |
Problem
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
Thank you.