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.
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.
This issue is still open but not currently scheduled to be addressed.
Affected components: Integration: ILMT & BigFix, Inventory import (read/write/export)
Master issue ID: IOK-994047
Also known as: ITAM-675
Oct 25, 2022 02:38 AM - edited Nov 20, 2023 01:33 PM