AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
#Power
 View Only
Back to discussions
Expand all | Collapse all

BESReporting database is too old to use with this version of WebReports

  • 1.  BESReporting database is too old to use with this version of WebReports

    Posted Thu May 20, 2021 08:22 AM

    I did BigFix upgrade to 9.5.17

    While open WebBrowser UI there is an error: "The BESReporting database is too old to use with this version of WebReports. Please upgrade your BESReporting database or configure or configure the LocalBESReportingServer DSN to a valid database."

    The error description can be seen in different places(window/frаme). For example, in the VM configuration window(frаme) of the ILMT software.

    I've checked the BESReports database version:

    # su - db2inst1 $ db2 connect to BESREPOR $ db2 "select Name, Value from dbo.DBINFO where Name = 'Version'" NAME VALUE ------- ------- Version 74 1 record(s) selected.

    I know it should be version 75 instead. So I did manual upgrade this time:

    [root_9.5.17.94-rhe6.x86_64]# ./install.sh -upgrade -reuseDb

    However it did not help.






    #Support
    #SupportMigration
    #AIX


  • 2.  RE: BESReporting database is too old to use with this version of WebReports
    Best Answer

    Posted Thu May 20, 2021 08:29 AM

    It is needed to properly set up the environment before running the upgrade command.

    Please do the steps :

    1. Login as root to Web Reports machine
    2. Change folder and modify setup
    # cd /opt/BESServer/bin # cp BESAdmin.sh setup_test.sh

    edit setup_test.sh and remove the last line :

    $BES_LIBPATH/BESAdmin "$"

    3.Set the execution permission for setup_test.sh

    4.Set the environment running setup_test.sh

    # ./setup_test.sh

    5.Submit upgrade command

    # /opt/BESWebReportsServer/bin/BESWebReportsServer -initializeDB -upgrade "$DB2_CONN_PWD"

    where $DB2_CONN_PWD is the password of the user that Web Reports use to connect the BESREPOR database

    I'd recommend to take a backup of BESREPOR database before submitting this command.

    The log file /var/log/BESInitializeBESReportsDB is produced by this command.






    #AIX
    #SupportMigration
    #Support


Related Content