Micros 3700 4.1 Database Validation Failed 1

[MDLAFOLLETTE]

I've been getting a database validation error for several months and the batch doesn't complete. I've tried rebuilding the database and continue to get the same validation error. Any suggestions? Thanks Mike

Here are the messages I'm receiving in the the 3700d.log:

Sun Jan 13 10:15:07 2013 | SERVER | Database Manager | 0 | Database backup complete |
Sun Jan 13 10:15:07 2013 | SERVER | Database Manager | 0 | Making copy of database for validation |
Sun Jan 13 10:15:07 2013 | SERVER | Database Manager | 0 | Starting database validation |
Sun Jan 13 10:15:08 2013 | SERVER | Database Manager | 0 | Database validation complete. |
Sun Jan 13 10:15:08 2013 | SERVER | Database Manager | 0 | Database validation failed, see \micros\common\etc\DM.log for details. |

Messages from the DM log file:

1/13/2013 10:13:15 AM Starting backup
Adaptive Server Anywhere Backup Utility Version 9.0.2.3396
(101051 of 101051 pages, 100% complete)
(40 of 40 pages, 100% complete)
Transaction log truncated
Database backup completed
1/13/2013 10:15:07 AM Database backup complete
1/13/2013 10:15:07 AM Making copy of database for validation
1/13/2013 10:15:07 AM Starting database validation
Adaptive Server Anywhere Validation Utility Version 9.0.2.3396
Internal database error *** ERROR *** Assertion failed: 101412 (9.0.2.3396)
Page number on page does not match page requested -- transaction rolled back
1/13/2013 10:15:08 AM Database validation complete.
1/13/2013 10:15:08 AM Database validation failed, see \micros\common\etc\DM.log for details.
1/13/2013 10:15:08 AM Backing up Micros passwords and encryption keys.
1/13/2013 10:15:08 AM Micros passwords and encryption key backup complete.
1/13/2013 10:15:08 AM Creating Micros compressed backup file.
1/13/2013 10:16:30 AM Micros compressed backup file created.
1/13/2013 10:16:30 AM Backing up Micros passwords and encryption keys.
1/13/2013 10:16:30 AM Micros passwords and encryption key backup complete.
1/13/2013 10:21:38 AM DM Return Code = 0
1/13/2013 10:25:37 AM DM Return Code = 0
1/13/2013 11:02:55 AM Rebuilding database file
1/13/2013 11:02:55 AM C:\MICROS\Database\Data\Rebuild\MICROS.DB
1/13/2013 11:02:55 AM Please wait...rebuilding definitions and data will take
1/13/2013 11:02:55 AM a while. The actual time is dependant on the size of
1/13/2013 11:02:55 AM the database and the computer hardware configuration.
1/13/2013 11:11:12 AM Starting newly created database
1/13/2013 11:11:17 AM Completing Rebuild
1/13/2013 11:12:44 AM Stopping database
1/13/2013 11:12:53 AM Completed rebuilding of the database
1/13/2013 11:13:24 AM Database rebuild success.
1/13/2013 11:33:00 AM DM Return Code = 0
1/13/2013 11:33:25 AM DM Return Code = 0
1/13/2013 11:54:40 AM DM Return Code = 0
1/14/2013 4:02:55 AM Logging on as DBA.
1/14/2013 4:03:03 AM Starting backup
Adaptive Server Anywhere Backup Utility Version 9.0.2.3396
(67655 of 67655 pages, 100% complete)
(13976 of 13976 pages, 100% complete)
Transaction log truncated
Database backup completed
1/14/2013 4:08:03 AM Database backup complete
1/14/2013 4:08:03 AM Making copy of database for validation
1/14/2013 4:08:04 AM Starting database validation
Adaptive Server Anywhere Validation Utility Version 9.0.2.3396
Internal database error *** ERROR *** Assertion failed: 101412 (9.0.2.3396)
Page number on page does not match page requested -- transaction rolled back
1/14/2013 4:08:04 AM Database validation complete.
1/14/2013 4:08:04 AM Database validation failed, see \micros\common\etc\DM.log for details.
1/14/2013 4:08:04 AM Backing up Micros passwords and encryption keys.
1/14/2013 4:08:04 AM Micros passwords and encryption key backup complete.
1/14/2013 4:08:04 AM Creating Micros compressed backup file.
1/14/2013 4:09:12 AM Micros compressed backup file created.
1/14/2013 4:09:12 AM Backing up Micros passwords and encryption keys.
1/14/2013 4:09:12 AM Micros passwords and encryption key backup complete.
1/14/2013 4:09:12 AM DM Return Code = 3
1/14/2013 2:38:43 PM DM Return Code = 0

 

[motie38]

You might try force starting the database without the micros.log file and then trying the backup/validate again.

 

[michelle305]

I thought this message indicates severe corruption w/the db. Probable new db needed.

 

[MDLAFOLLETTE]

Deleting the MICROS.BAD file and the old validation DB copy solved the problem. Thanks everyone.