Tech Tips: Pre 9.1.3 upgrade console tool fails checking AD version

Document created by Christopher_Walsh Employee on Jun 23, 2014
Version 1Show Document
  • View in full screen mode
Hello All,
Another upgrade tip to help you have a sucessful migration from RA 9.0.161 to NFA 9.1.3.
If you have an older versioni of Anomaly Detector on  your RA console server, the database needs to be dropped before running the console tool.
This document has also been published as on support.ca.com at the link below:
Title: Before upgrading from RA 9.0.161 to NFA 9.1.3 the Console tool fails while checking the version of Anomaly Detector.

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.

 

This document was generated from the following discussion: Tech Tips: Pre 9.1.3 upgrade console tool fails checking AD version

Attachments

    Outcomes