Reaper service not starting. MySQL error: Table 'harvester.reserved_proto_seating' doesn't exist Query: select protocol from reserved_proto_seating

Document ID : KB000047053
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem: 

Reaper service not starting:

Getting the following errors from the RealTimeReaperErrors9999-99-99 log.

********** RealtimeReaper ********** 
14:41:47 Severity 1 - RealtimeReaper starting up, logging level: 2
14:41:47 Severity 2 - MySQL error: Table 'harvester.reserved_proto_seating' doesn't exist
Query: select protocol from reserved_proto_seating
14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at ..\common\nfmydbutils.cpp 114
14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at

14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at nfrtreaper.cpp 2604
14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at nfrtreaper.cpp 1768
14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at nfrtreaper.cpp 1087
14:41:47 Severity 2 - hr_test failure 0x87fa0003 Error querying from database at nfWorkerThread.cpp 95
14:41:47 Severity 1 - Shutting Down
 
 
Tried restarting the services and rebooting but no success. 
Tried doing a select on the reserved_proto_seating table and got table does not exist.
Tried doing a repair with no success.

Environment:  

NFA 9.3.x and above

Resolution:

1. Do a backup of the DB if possible. 

2. Stop all the NFA services except for the MySQL service.

3. From a DOS prompt:

    mysql -P3308 -D harvester -t -e "DROP TABLE reserved_proto_seating;"

    mysql -P3308 -D harvester -t -e "CREATE TABLE `reserved_proto_seating` (`protocol` int(10) unsigned NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;"

4. Restart all the NFA services.

Additional Information:

 Reference case #00522121