Known Issue: SendSoftwareBundle inventory import step reading from ILMT SQL Server database may fail with error: "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column." (IOK-994047)

[#1]

Summary

The SendSoftwareBundle step executed when reading inventory data from an IBM License Metric Tool (ILMT) / HCL BigFix Inventory SQL Server database may fail with the following error:

Error: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

Details

This issue occurs if imported data contains values which are longer than can fit into database column sizes in the compliance database.

Logging generated by the import process when this issue occurs looks like the following:

2020-03-23 05:16:34,267 [INFO ]     SendSoftwareBundle (Transfer data from source 'BIG_FIX_INVENTORY_SQLSERVER' to FNMP) (VersionFrom: 8.0)
2020-03-23 05:16:34,267 [INFO ]       Reading records from intermediate file Evidence--655--SendSoftwareBundle.int.xml
2020-03-23 05:16:34,314 [INFO ]       Failed to execute Reader 'SendSoftwareBundle' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\CustomInventory\Reader\ilmt sql\InstallerEvidence.xml, at step line 1
Error: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
2020-03-23 05:16:34,314 [INFO ]       All retries have been attempted for Reader 'SendSoftwareBundle'
2020-03-23 05:16:34,314 [INFO ]       Completed with error in 0 seconds.
2020-03-23 05:16:34,314 [INFO ]     Released application lock Reader_5c7c36d6-93ac-496d-8dde-723439aba5d1_Evidence_ALL
2020-03-23 05:16:34,314 [ERROR]     System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.

Fix status

This issue is still open but not currently scheduled to be addressed.

Other information

Affected components: Integration: ILMT & BigFix, Inventory import (read/write/export)

Master issue ID: IOK-994047

Also known as: ITAM-675