IBM Support

Breaking Changes introduced in MS SQL 2016, make this database incompatible with LMT/BFI lower than 9.2.13

Troubleshooting


Problem

Prior to release 9.2.13, using  MSSQL 2016 could lead to data corruption in LMT/BFI databases.

More information can be found in the following links:

https://docs.microsoft.com/en-us/sql/database-engine/breaking-changes-to-database-engine-features-in-sql-server-2016?view=sql-server-2017
https://github.com/Microsoft/mssql-jdbc/issues/680

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/de5dbf3e-8c95-40f4-9e31-b71f1f31983d/change-in-datetime2-implementation-in-sql-server-2016?forum=transactsql
https://github.com/sequelize/sequelize/issues/9294

Cause

Utilizing this database engine may cause serious data loss in BFI/ILMT which can significantly impact its licensing audit capabilities. This may eventually lead to difficulties in proving  sub-capacity licensing compliance.
Due to the above, in 9.2.13 we have modified the LMT/BFI database interaction to prevent such situations.

Resolving The Problem

Upgrade to version 9.2.13 to start using MS SQL 2016.

In case you were already using MS SQL 2016 on releases lower than 9.2.13,  we will not be able to recover the lost data, however starting from the day of the upgrade, your data will be correctly populated. To make sure that valid data is populated,  you must perform the following steps after you complete the upgrade (once Schema Update completes):

1. Log in to the BigFix console and select the Run Capacity Scan and Upload Results fixlet.

2. In the lower pane, click Take Action and select the second option - Click here to run a single capacity scan and force upload of results. This is a one-off action, which does neither require stopping of the already running  scans nor can be used instead of the regular capacity scans.

3. Open the Target tab and select all computers. Then, click OK.


Cross reference information
Product Component Platform Version Edition
IBM BigFix Inventory Platform Independent All Versions

Document information

More support for: IBM License Metric Tool

Component: --

Software version: All Versions, Version Independent

Operating system(s): Platform Independent, Windows

Reference #: 2016328

Modified date: 09 October 2018