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.

SQL Server authentication is locked out for the database user.

The problem occurs when the credentials are provided wrongly in configuration files.

To unlock the user, turn off BigFix Inventory in services and then perform the below steps:
  1. Open SQL Server Management Studio.
  2. Connect to the SQL Server instance you want to configure.
  3. In the Object Explorer window, expand the Security folder.
  4. Expand the Logins folder and select the related database user from the context menu.
  5. Right-click Properties > Status.
  6. Deselect 'SQL Server authentication: Login is locked out'.
  7. Click OK to save the changes.

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
Issues and resolution related to DB2 database fix pack installation
After you install DB2 fix pack and restart BigFix Inventory, the application does not work and following message is displayed. 
We're sorry, but something went wrong.
In tema.log the following error is found:
Java::ComIbmDb2JccAm::SqlSyntaxErrorException: The name of the object to be created is identical to the existing name "DBO.SCHEMA_MIGRATIONS" of type "TABLE"
Once you install a fix pack for DB2, perform the steps mentioned in DB2 for Linux, UNIX, and Windows.
Note: Take a backup of the database before you activate or deactivate your database. For more information, see Backing up the DB2 database. To learn about maintaining a database, see Maintaining the DB2 database.
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®. To troubleshoot this issue, 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.
Unable 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 as 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, there is a possibility 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 initial import takes time depending on the amount of 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 (which was SUADB in the earlier versions). 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\BigFix Enterprise\BFI\wlp\usr\servers\server1\config\database.yml

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