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
Related Articles
SendSoftwareBundle inventory import step reading from ILMT SQL Server database may fail with error: "The given value of ty… 4Number of Views ImportIntoFileSoftwareFileAttributeValue ManageSoft inventory reader step may fail with error: "The given value of type St… 4Number of Views Compliance Import fails with "The given value of type String from the data source cannot be converted to type nvarchar" 7Number of Views Known Issue: “WriteFileEvidence - Insert unmatched evidence” import writer step may fail with error due to NewFileEvidence… 65Number of Views Known Issue: “WriteFileEvidence - Insert unmatched evidence” import writer step may fail with error due to FileEvidenceFil… 42Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago