DX Infrastructure Management

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.