ADDM import fails with the error ?Unable to read data from the transport connection: The connection was closed.?

[#1]

Summary

When performing an import using the ADDM out of the box adapter this fails with the following error : Unable to read data from the transport connection: The connection was closed.

Symptoms

When performing an import using the ADDM out of the box adapter this fails with the following error message:

? <TimeStamp>: ERROR : *** ERROR: SQL bulk copy failed for table 'DiscoveredPackages_ci'
<TimeStamp>: ERROR : *** ERROR: An error occurred when attempting to read data from ADDM or when trying to write data to SQL Server: System.IO.IOException: Unable to read data from the transport connection: The connection was closed.
at ADDMSource.Program.DoBulkCopy(DbConnection p_Connection, IDataReader p_DataReader, String p_TableName)
at ADDMSource.Program.Main(String[] args)
<TimeStamp> : ERROR : ======== Completed with Failure: 1?

Note: The tables listed in the error may not match the exact tables reference above depending on where in the import the connection was closed.

Cause

The error message is caused by the ADDM database closing the connection or the connection timing out, this could be caused by a network issue in the environment not allowing the data to transfer in the time allocated.

Resolution

The following information can be used to help identify the cause the of the error:

-Ensure there are no other intensive tasks running on the ADDM database at the time as the ADDM import.
-Review the ADDM event logs to see if there is a deadlock for example, this can be verified by the ADDM Administrator.
-Ensure the latest ADDM adapter is being used, the latest adapter can be downloaded from the Product and License Centre (https://flexerasoftware.subscribenet.com/).
- In the ?FnmpADDMSettings.XML? provided with the adapter increase the ?server timeout? to a larger value, for example ?7600?.


In addition to this attached to the article is an updated ?fnmpADDMStage.exe? that has additional keep alive calls that will allow the network traffic to be tracked across the network issue to identify drop in the connection, this can replace the default ?fnmpADDMStage.exe? and be used in conjunction with tools such as WireShark (https://www.wireshark.org/download.html ) by Network Administrators to identify any potential issues on the network.

Note: Please note that WireShark is tool created by a thirdparty and not supported by Flexera Software, this tool should be used in conjunction with the vendors guidelines.

Additional Information

Additional information on the configuration can be located in the install guide shipped with the ADDM adapter.