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)
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)
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.
Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.
