After upgrading our Bigfix server to the lates release (9.5.10), we have encountered an issue with our webreports not able to connect (?) to the BESREPOR database. A manual connection test appear to be successful as well as a DB initialization:
DB initialization:
[root@bfuatsvr]# /var/opt/BESWebReportsServer/BESReportsData/InitializeBESReportsDB.sh “BESREPOR” “db2inst1” “************” db2server 50000
Target database version: 73
Checking database version (if it exists)…
Database already up to date.
Successfully initialized BESREPOR database.
/opt/BESWebReportsServer/bin
Connection test:
[db2inst1@bfuatsvr]$ db2 connect to ‘BESREPOR’ user ‘db2inst1’ using ‘************’
Database Connection Information
Database server = DB2/AIX64 10.5.5
SQL authorization ID = db2inst1
Local database alias = BESREPOR
WebReports.log:
Mon, 15 Oct 2018 13:49:00 +1100 – 2383849216 – Failed to convert database db2server to a datasource: Database Error: The database is not initialized.
Mon, 15 Oct 2018 13:49:15 +1100 – 2383849216 – Failed to convert database db2server to a datasource: Database Error: The database is not initialized.
We are able to login to the webreports webgui but the option to modify datasource is not available under “Administration”. It only has:
-Scheduled activities
-Filter Management
-Address Book
The following are missing:
-User Management
-Datasource Settings
-Errors
Not sure what else to check as nothing (as far as we (users) are aware has changed except for the upgrade. We have upgraded since 9.2 but so far only had issue with DB now. Thank you