When a Schedule Database compaction or check are run, eithe manually or as part of an NVDB backup, the following error message is returned:
error: Raw database check failed on table 'scheduled phases'. Error 13: Failed to read record. Unable to initialize database.
This occurs when a database table structure becomes inconsistent and may become corrupt due to lack of space, comit operations aborted (power cut) or when the database tables exceed 2GB in early NVBU versions. The NetVault check/ compact/repair utility is then unable to perform a check due to the corrupted table structure.
To prevent irreversible situation caused by corruptions, Technical Support recommends a NVDB backup be run daily and kept long enough to allow restore of a previously known 'good' NVDB at any time.
1. Stop NetVault Services
2. Browse your way into the NetVault db directory and rename your "ScheduleDatabase" to "Old_ScheduleDatabase"
3. Restart NetVault Services (a New ScheduleDatabse will be generated at this time)
4. Find and restore your most recent "Good" NetVault Database Backup... just restoring the "Schedule Manager"
5. Once the restore of the Schedule Manager has completed, NetVault Services will STOP, you will then have to restart them and "Abort" any jobs that may kick off once the Services have been restarted.
6. Recreate any new jobs that may have been created after the date of the NetVault Database backup just restored. These newer jobs were not present when the restored backup was taken.
The ScheduleDatabase should now be able to pass the checks.
