stdout.log error - (ERROR) - Failed to add new wirelessap record

Document ID : KB000111187
Last Modified Date : 15/08/2018
Show Technical Document Details
Issue:
 This is the repeating message. I checked the runtime debug in Spectrum admin page. All debugs were off but at bottom the MAX button was selected so I put that to OFF now. But not sure why or what is causing this message.

Aug 11, 2018 14:57:30.753 (SRM/WirelessAPsHandler/bucketReader) (com.aprisma.spectrum.app.repmgr.dc.event.handler.WirelessAPsHandler) - (ERROR) - Failed to add new wirelessap record Aug 11, 2018 14:57:30.753 (SRM/WirelessAPsHandler/bucketReader) (com.aprisma.spectrum.app.repmgr.dc.event.handler.WirelessAPsHandler) - (ERROR) - Failed to add new wirelessap record Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO wirelessaps (event_key, timestamp, controller_mh, ap_mh, ap_grpName, clients_connected, data_sent, data_received) VALUES (?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'reporting.wirelessaps' doesn't exist
Resolution:
Stop Tomcat. 
Login to mysql

mysql>CREATE TABLE `wirelessaps` ( `ap_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event_key` bigint(20) unsigned NOT NULL, `timestamp` datetime NOT NULL, `controller_mh` int(10) unsigned NOT NULL, `ap_mh` int(10) unsigned NOT NULL, `ap_grpName` varchar(255) NOT NULL, `clients_connected` int(10) unsigned DEFAULT '0', `data_sent` bigint(20) unsigned DEFAULT '0', `data_received` bigint(20) unsigned DEFAULT '0', PRIMARY KEY (`ap_id`), KEY `idx_controller_mh` (`controller_mh`), KEY `idx_ap_mh` (`ap_mh`), KEY `idx_ap_grpName` (`ap_grpName`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
mysql>exit

Restart Tomcat