Before upgrading from RA 9.0.161 to NFA 9.1.3 the Console tool fails while checking the version of Anomaly Detector.

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

Description:

When running the 'consoletool-exe.jar' on the RA console server before upgrading from RA 9.0.161 to NFA 9.1.3 an error like below is found:

 	[ALWAYS ] - checking for the AD db (nsas) at address 127.0.0.1 using sql [ SELECT count(*) as dbExists FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 	'nsas' ] 
 	[SEVERE ] - in AD portion of consoletool 	
 	com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '1-1-0-7' for key 'MajorVersion' 	
 	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 	
 	sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 	
 	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 	
 	java.lang.reflect.Constructor.newInstance(Unknown Source) 	
 	com.mysql.jdbc.Util.handleNewInstance(Util.java:409) 	
 	com.mysql.jdbc.Util.getInstance(Util.java:384) 	
 	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041) 	
 	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) 	
 	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) 	
 	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) 	
 	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) 	
 	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) 	
 	com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113) 	
 	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409) 	
 	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327) 	
 	com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.moveRevisionInfoIntoRevisionHistory(ConsoleInfoToPollerTool.java:967) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.UpdateAnomalyDetectorVersion2IfNeeded(ConsoleInfoToPollerTool.java:801) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.main(ConsoleInfoToPollerTool.java:323) 
 	[ALWAYS ] - com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool logging to D:\NETQOS\Reporter\Logs\ConsoleInfoToPollerTool 	
 	[ALWAYS ] - starting to run consoletool 	
 	[ALWAYS ] - checking for the AD db (nsas) at address 127.0.0.1 using sql [ SELECT count(*) as dbExists FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME =  'nsas' ] 
 	[SEVERE ] - in AD supported version portion of consoletool 	
 	com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'nsas.revision_info' doesn't exist 	
 	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 	
 	sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 	
 	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 	
 	java.lang.reflect.Constructor.newInstance(Unknown Source) 	
 	com.mysql.jdbc.Util.handleNewInstance(Util.java:409) 	
 	com.mysql.jdbc.Util.getInstance(Util.java:384) 	
 	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) 	
 	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) 	
 	com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) 	
 	com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) 	
 	com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) 	
 	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2562) 	
 	com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2512) 	
 	com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1476) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.isADOnMinimumSupportedVersion(ConsoleInfoToPollerTool.java:1111) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.UpdateAnomalyDetectorVersion2IfNeeded(ConsoleInfoToPollerTool.java:789) 	
 	com.ca.im.ra.MigrationTo912Tool.ConsoleInfoToPollerTool.main(ConsoleInfoToPollerTool.java:323) 
 	[ALWAYS ] - It looks like AnomalyDetector is not on a minimum supported version. 

Solution:

This occurs when you have an older version of Anomaly Detector like 2.x or earlier installed.

  1. To resolve this you must drop the Anomaly Detector database named 'nsas' on the 3308 instance of mysql with the commands below:

    mysql -P3308
    drop database nsas;

  2. Then run the 'consoletool-exe.jar' file again from the command prompt and check for any new errors.

If there are no new errors you can proceed with the upgrade of the Harvesters as per the NFA 9.1.3 Upgrade guide.