Known Issue: ReadContainerInstances ManageSoft reader may fail importing long values from the HardwareValue table with error: "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column" (IOJ-2127108)

[#1]

Symptoms

The ReadContainerImages ManageSoft reader executed during the inventory import process may fail with errors such as:

2020-07-09 01:23:21,130 [INFO ] ReadContainerInstances (Transfer data from source 'FlexNet Manager Suite' to FNMP) (VersionFrom: 14.3) 2020-07-09 01:23:21,276 [INFO ] Failed to execute Reader 'ReadContainerInstances' from file \\batchsvr\batchdata\Flexera Software\Compliance\ImportProcedures\Inventory\\Reader\managesoft\Container.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-07-09 01:23:21,424 [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.

Details

This issue is caused by long values retrieved from the HardwareVaues.Value column in the inventory database (which has type nvarchar(max)) being inserted into target fields in the ImportedContainerInstance table in the compliance database (which have type nvarchar(256)) without being truncated.

This issue can potentially affect data inserted into the following fields in the ImportedContainerInstance table:

• ContainerId
• Name
• ImageTag
• EntryPoint
• Cmd
• Status

Remediation

This issue can be avoided by upgrading to a FlexNet Manager Suite version that contains a fix for this issue.

Alternatively, the issue can be fixed by updating the SQL query in the ReadContainerInstances reader in the C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Reader\ManageSoft\Container.xml file so that long values are truncated to a length that is suitable for storing in the the ImportedContainerInstance table.

For example, change the expressions for the following columns returned from the SQL SELECT statement in this query to the following:

LEFT(v_id.Value, 256) AS [ContainerID],
LEFT(v_name.Value, 256) AS [Name],
LEFT(v_imagetag.Value, 256) AS [ImageTag],
CAST(v_cpu.Value AS float) AS [PartialNumberOfProcessors],
CAST(v_mem.Value AS bigint) AS [TotalMemoryLimit],
LEFT(v_entryp.Value, 256) AS [Entrypoint],
LEFT(v_cmd.Value, 256) AS [Cmd],
LEFT(v_status.Value, 256) AS [Status],

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R1.1 / Sep 2020 (Cloud), 2020 R2 (On Premises)

Other information

Affected components: Containers, Inventory import (read/write/export)

Master issue ID: IOJ-2127108

Also known as: FNML-71147