Database problems
Database problems are related to issues with connecting to DB2 and MSSQL Server as well as retrieving information from these databases.
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.
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:- Log on to IBM Security Access Manager.
- In the top navigation bar, click .
- Select the instance and then, from the drop-down list on the right of the Reverse Proxy bar, select .
- In the Advanced Configuration File Editor,
locate the https-timeout parameter and specify
the value of 300.Example:
https-timeout = 300
- 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 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.
, and change the value of the
- Checking the database name.
- The default database name is
TEMADB
, however it changed since earlier versions, where the database was calledSUADB
. You can check the name of your database in the database.yml file in one of the following directories./opt/ibm/BFI/wlp/usr/servers/server1/config/database.yml
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.