Issue after upgrading to BigFix 10/BFI 10

Usage and Config BFI
1

I was just working through upgrading my environment to BigFix 10 and BFI 10. Everything seemed to be going great until after the BFI install.

When I launched BFI webpage, I got the message

Host The D82 database server must be version 10.1 with at least fix
pack 5 or version 10.5 with at least fix pack 6 and at least Workgroup
Server Edition or version 11.5 any edition The current version (10.5.0.3)
or edition is not supported.

Oops, I missed the DB2 upgrade. So I got 10.5.0.11 installed and now when I try BFI, I get the message

Something went wrong.
For more information, see the tema.log file.

There is a lot of content in the file, but it seems to be pointing to:

[5/10/20 4:58:14:133 UTC] 0000002a com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[ERROR] Java::ComIbmDb2JccAm::SqlSyntaxErrorException: The name of the object to be created is identical to the existing name “DBO.SCHEMA_MIGRATIONS” of type “TABLE”… SQLCODE=-601, SQLSTATE=42710, DRIVER=4.22.29: CREATE TABLE SCHEMA_MIGRATIONS (FILENAME varchar(255) NOT NULL PRIMARY KEY)

[5/10/20 4:58:14:141 UTC] 0000002a com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[INFO] Starting deep hw scan initializer

[5/10/20 4:58:14:265 UTC] 0000002a com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[ERROR] Java::ComIbmDb2JccAm::SqlSyntaxErrorException: The name of the object to be created is identical to the existing name “DBO.SCHEMA_MIGRATIONS” of type “TABLE”… SQLCODE=-601, SQLSTATE=42710, DRIVER=4.22.29: CREATE TABLE SCHEMA_MIGRATIONS (FILENAME varchar(255) NOT NULL PRIMARY KEY)
…
[5/10/20 4:58:57:462 UTC] 00000026 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.DEBUG: due a previous initialization failure application instance can not be returned
[5/10/20 4:58:57:463 UTC] 00000026 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.DEBUG: resetting rack response due exception

Any ideas on what to do?

I will look to open an incident on this, but this would be the first one since moving to HCL and I am not set up for support yet.

Thanks

1 Like
2

After trying to get this to work for a while without success I had to do the following

  1. Remove BFI Server
  2. Shutdown all BigFix processes
  3. Restore TEMADB
  4. Start BigFix processes
  5. Install BFI server

When I started up the web page, I was prompted to upgrade the schema and it worked.

My next step is to let this run for a bit and then upgrade to DB2 11.

1 Like