DX NetOps

 View Only
  • 1.  DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 14, 2020 06:10 AM
    Hi
    Customer upgrade to DX NetOps to 20.2.
    The about menu on the main page displays 19.2 but the sub menu shows 3.7.15
    Is that correct? 



    ------------------------------
    Senior Consultant
    CA Southern Africa
    Cape Town
    South Africa
    ------------------------------


  • 2.  RE: DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 14, 2020 07:35 AM
    Hi Klaus:

    It doesn't look right if they are on 20.2.  Did the upgrade complete successfully?  If you log on to the CAPC shell what does the .history say?

    cd /opt/CA/PerformanceCenter/InstallLogs
    [root@lvntest002958 InstallLogs]# cat .history
    Performance Center 3.7.4.688 installed at 09/23/2019 09:31:05
    Performance Center 20.2.1.213 installed at 06/28/2020 01:41:05

    You can also look at the install logs in the same directory for the date you did the upgrade.  There is a summary section in the beginning of each log that looks like this

    Summary
    -------

    Installation: Successful.

    1929 Successes
    0 Warnings
    0 NonFatalErrors
    0 FatalErrors

    Were there any non-fatal or fatal errors?


  • 3.  RE: DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 15, 2020 07:19 AM
    Thank you for response

    ------------------------------
    Senior Consultant
    CA Southern Africa
    Cape Town
    South Africa
    ------------------------------



  • 4.  RE: DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 16, 2020 03:42 AM
    Hi Klaus,

    during PC installation/upgrade we run different SQL statements to upgrade the information in the mysql database, among others, the version.

    If you have access to you mysql database, you can confirm the new version is not listed in the database

    /opt/CA/MySql/bin/mysql -uroot -p -e "select * from netqosportal.revision_info"

    This table is updated as part of dbmigration process. So, please, check the file in /opt/CA/PerformanceCenter/InstallLogs/dbmigrate.log corresponding to the upgrade to 20.2

    Look for a line like "INFO: Inserting new version entry into DB." and check if there was any error during the execution. The SQL statement is defined in

    /opt/CA/PerformanceCenter/SQL/portalrevision.sql

    If that statement was not executed, it is also possible that others weren't either.

    Regards



  • 5.  RE: DX NetOps Upgrade question

    Posted Oct 20, 2020 03:45 AM
    Hi Jose and Klaus, 
    I checked the dbmigrate.log.2020-10-15_13-30 log file and found the following message on a number of lines: no package

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: DbMigrate::runScript() - script upgrade/3.7.16.0/update_oob_group_names.sql (no package)

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: Running script /opt/CA/PerformanceCenter/Tools/bin/../../SQL/upgrade/3.7.16.0/update_oob_group_names.sql (no package)

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate run
    INFO: Inserting new version entry into DB.

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: DbMigrate::runScript() - script portalrevision.sql (no package)

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: Running script /opt/CA/PerformanceCenter/Tools/bin/../../SQL/portalrevision.sql (no package)

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate <init>
    INFO: DbMigrate::DbMigrate() (case 2), migrateXML = /opt/CA/PerformanceCenter/Tools/bin/../../SQL/_post_install.xml, addPlocLanguages = false, executePostSteps = false

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: DbMigrate::runScript() - script create_new_dashboards.sql (no package)

    Oct 15, 2020 1:31:36 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: Running script /opt/CA/PerformanceCenter/Tools/bin/../../SQL/create_new_dashboards.sql (no package)

    Oct 15, 2020 1:31:37 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: DbMigrate::runScript() - script update_menus_containertype.sql (no package)

    Oct 15, 2020 1:31:37 PM com.ca.im.installanywhere.util.DbMigrate logRunScriptInfo
    INFO: Running script /opt/CA/PerformanceCenter/Tools/bin/../../SQL/update_menus_containertype.sql (no package)


  • 6.  RE: DX NetOps Upgrade question

    Posted Oct 20, 2020 03:55 AM
    The results of the mysql query:  select * from netqosportal.revision_info

    netqosportal.revision_info




  • 7.  RE: DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 20, 2020 07:32 AM
    Hi Arnold,

    my log also shows the (no package) string. So, no worries about that.

    Can you please share the content of /opt/CA/PerformanceCenter/SQL/portalrevision.sql?

    You dbmigrade.log files looks like you installed 3.7.16 and not 20.2.1.213.

    Can you please share the name of the tar.gz file you use for the upgrade?

    Regards




  • 8.  RE: DX NetOps Upgrade question

    Posted Oct 20, 2020 03:48 AM
    Hi Joseph,
    I performed the upgrade and, as you can see from the screen shot below, saw no FatalError messages in the log files:
    Results CAPM upgrade to NetOps 20.2



  • 9.  RE: DX NetOps Upgrade question

    Broadcom Employee
    Posted Oct 20, 2020 10:17 AM
    Jose is on the right track here.

    Can you share the specific downloaded file names that were used to upgrade?

    The PC netqosportal revision_info table details shows an upgrade to r3.7.16, the latest r3.7.x series release, not an r20.2.x series release.

    That r3.7.16 is the correct release to map to the 19.2 label.

    ------------------------------
    Technical Support Engineer IV
    Broadcom
    ------------------------------