DX Unified Infrastructure Management

 View Only

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

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

    Broadcom Employee
    Posted Jun 10, 2014 09:53 AM
    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.