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

Title

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.

Was this helpful?

Support Hub

Product

FlexNet Manager Suite

Deployment type

On-premises

Visibility

Guest

URL Name

addm-import-fails-with-the-error-unable-to-read-data-from-the-transport-connection-the-connection-was-closed

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

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.

Summary

Symptoms

Cause

Resolution

Additional Information

Related Articles

Please wait...

Case id: 00001065