: ADDM Import fails with the error ?ERROR: SQL Server database exception (0x80131904): Received an invalid column length from the bcp client for colid 8?

[#1]

Summary

When importing the ADDM xml inventory into the staging database it fails with the error: ?ERROR: SQL Server database exception (0x80131904): Received an invalid column length from the bcp client for colid 8?

Symptoms

When importing the XML inventory from ADDM into the staging database it fails with an output similar to the one below:

======== SoftwareInstanceVirtualMachine Nodes Successfully truncated database table 'SoftwareInstanceVirtualMachine_ci'

• ERROR: SQL bulk copy failed for table 'SoftwareInstanceVirtualMachine_ci'

• ERROR: Failed to write imported data into the SQL Server database staging table.

• ERROR: SQL Server database exception (0x80131904): Received an invalid column length from the bcp client for colid 8.
  ======== Completed with Failure: 1
  Total time before failure: 116.641 seconds

Cause

This is an issue with certain products that have inventory in ADDM returning a list of host containers whereas our adapter schema is only expecting a single host container.

Resolution

The following steps can be used to resolve the issue by updating the ?FNMPADDMSettings.xml?.

1. Take a backup of the current staging database.

2. Take a backup of the ?FNMPADDMSettings.xml?, this will usually reside alongside the FNMPADDMStage.exe file.

3. Modify FNMPADDMSettings.xml and search for the ?SoftwareInstanceVirtualMachine Nodes? mapping.

4. Change the line that says ?#HostContainer:HostContainment:ContainedHost:Host.key AS 'GuestHostKey',? and set it to ?single(#HostContainer:HostContainment:ContainedHost:Host.key) AS 'GuestHostKey',?

5. Perform the import of ADDM inventory into the staging database (any method will do i.e. stream, stage etc).

Additional Information

So far the only products which return a ?list? of hosts are those which we don?t support e.g. VirtualBox and this data will not appear in FNMP even after this fix is applied as FNMP will only import VM data that is a type that we support e.g. VMWare etc.