Database problems

Database problems are related to issues with connecting to DB2 and MSSQL Server as well as retrieving information from these databases.

Windows SQL Server

During the import, SQL Server uses 99% of the physical memory.
To solve the problem, set the maximum amount of memory that can be used by SQL Server. For more information, see Server Memory Options and How to: Set a Fixed Amount of Memory (SQL Server Management Studio) in the SQL Server documentation.
The login process to SQL Server fails.
During a login process to SQL server, the following error is displayed: 
Login failed for user 'username'. The user is not associated with a trusted SQL Server connection.
(Microsoft SQL Server, Error: 18452).

The cause of this error is that SQL server is configured to use Windows Authentication mode and does not allow the use of SQL accounts. To solve this problem, enable the SQL Server Authentication in SQL Server. For more information, see Enabling the SQL Server Authentication Mode.

Windows DB2

BigFix Inventory cannot connect to its database and the following error is written in the logs: Connection refused. ERRORCODE=-4499, SQLSTATE=08001.
The problem occurs because the DB2® database is not yet activated after a restart and is thus not accessible to BigFix Inventory. To solve the problem, run the following command after you restart the database:
db2 activate db database_name
BigFix Inventory cannot connect to the database. The default port range is modified.
The default local port range for Linux™ is 32768-61000. If the default range is modified, it is possible that the DB2® port number is allocated to another local process. If the port number is pre-allocated, BigFix Inventory cannot connect to DB2®. Complete the following steps:
  • Ensure that IPv4 is being used.
  • Use the netstat command to check whether DB2® is listening on the expected port, and no other socket is pre-allocated the DB2® port.
  • If DB2® is not listening on the expected port, restart DB2® and check again.
It is impossible to establish a connection to a data source in the BigFix Inventory web user interface with single sign-on enabled.
An error message is displayed after you saved the connection parameters on the Data Sources pane:
Unexpected WebSEAL Response.
Code: 0x38cf04d3
Error: DPWWA1235E
Please contact your system administrator. This may indicate an insufficient proxy HTTPS timeout.
To be able to save the connection parameters successfully, increase the https-timeout parameter in the ISAM Reverse Proxy configuration. For example, to set the timeout to 5 minutes:
  1. Log on to IBM Security Access Manager.
  2. In the top navigation bar, click Secure Web Settings > Manage > Reverse Proxy.
  3. Select the instance and then, from the drop-down list on the right of the Reverse Proxy bar, select Manage > Configuration > Edit Configuration File.
  4. In the Advanced Configuration File Editor, locate the https-timeout parameter and specify the value of 300.
    Example:
    https-timeout = 300
  5. Click Save.

Both databases

After you restore the BigFix database, new data is not displayed in BigFix Inventory.
To ensure that only newly created data is imported to BigFix Inventory, the data that is stored in the BigFix database is marked with the so-called sequence number. The number is incremented with every change. Every import contains data starting from the sequence number reported during the last successful import to the current sequence number.

When the BigFix database is restored, the sequence number is restored to the value from the time when the database backup was created. Thus, it might happen that the sequence number after the restoration is lower than the sequence number reported during the last successful import. In such case, the first import after the database restoration does not include any data. After that import, the sequence number is updated and the next import contains new data.

However, data from the period between the database restoration and the first successful import is not imported which creates a gap. To solve the problem, go to Management > Advanced Server Settings, and change the value of the resynchronize_datasources_once parameter to true. Then, run an import. This import will be time-consuming as it will import all software scan data from the restored BigFix database to cover the gap. The subsequent imports will run in the normal operation mode.

Checking the database name.
The default database name is TEMADB, however it changed since earlier versions, where the database was called SUADB. You can check the name of your database in the database.yml file in one of the following directories.

Linux /opt/ibm/BFI/wlp/usr/servers/server1/config/database.yml

Windows C:\Program Files\IBM\BFI\wlp\usr\servers\server1\config\database.yml

In earlier versions, the default installation path is C:\Program Files\IBM\SUA or /opt/ibm/SUA.