The underlying connection was closed: The connection was closed unexpectedly.

Nov 9, 2016 at 12:44 PM
Hello, I am having an issue when importing the files using this tool. Suddenly the import failed and The underlying connection was closed: The connection was closed unexpectedly. can you help me with that? Thank you.
Coordinator
Nov 9, 2016 at 8:17 PM
Can you provide a bit more detail?
  1. A copy of your XML configuration file would be useful to see what you are doing.
  2. What are you importing into 2010,2013, 2016 or SharePoint Online?
  3. Are some files succeeding an some not, is it large files failing? Size that fails on?
Etc etc

Thanks, please advise and can get this sorted very quickly
Nov 11, 2016 at 12:39 AM
MadAboutImport wrote:
Can you provide a bit more detail?
  1. A copy of your XML configuration file would be useful to see what you are doing.
  2. What are you importing into 2010,2013, 2016 or SharePoint Online?
  3. Are some files succeeding an some not, is it large files failing? Size that fails on?
Etc etc

Thanks, please advise and can get this sorted very quickly
Here is the detail as you requested:
  1. XML Configuration :
<?xml version="1.0" encoding="utf-8"?>
<DataSetImportSettings xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Source>
    <SourceDataSetType>OLEDbSelect</SourceDataSetType>
    <OleDbSourceDataSetSettings>
      <ConnectionString>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\ImportForSharePoint\Copy of StaffDocuments2.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=0";</ConnectionString>
    </OleDbSourceDataSetSettings>
    <OleDbSelectSourceDataSetSettings>
      <SelectStatement>select * from [Files$]</SelectStatement>
    </OleDbSelectSourceDataSetSettings>
  </Source>
  <Destination>
    <AuthenticationSettings>
      <AuthenticationType>Current</AuthenticationType>
      <domain />
      <username />
    </AuthenticationSettings>
    <DestinationItemSettings>
      <DestinationItemType>Document</DestinationItemType>
      <ItemExistsBehaviour>Overwrite</ItemExistsBehaviour>
      <ImportMappings>
        <ImportMapping xsi:type="ImportMapping_String">
          <DestinationField>Title</DestinationField>
          <SourceColumn>Title</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Discipline</DestinationField>
          <SourceColumn>Discipline</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Doc Year</DestinationField>
          <SourceColumn>Doc Year</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Entity</DestinationField>
          <SourceColumn>Entity</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Well/Project Name</DestinationField>
          <SourceColumn>Well/Project Name</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Project Phase</DestinationField>
          <SourceColumn>Project Phase</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Doc Type</DestinationField>
          <SourceColumn>Doc Type</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_ManagedMetaDataAutoAdd">
          <DestinationField>Document Keywords</DestinationField>
          <SourceColumn>Document Keywords</SourceColumn>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_DateTimeFromString">
          <DestinationField>Creation Date</DestinationField>
          <SourceColumn>CreatedDate</SourceColumn>
    <ConversionMask>dd/MM/yyyy hh:mm:ss</ConversionMask>
    <Culture>en-GB</Culture>
        </ImportMapping>
    <ImportMapping xsi:type="ImportMapping_Native">
          <DestinationField>Archive</DestinationField>
          <SourceColumn>Archive</SourceColumn>
        </ImportMapping>
      </ImportMappings>
    </DestinationItemSettings>
    <DestinationListSettings>
    <DestinationWebUrlRelative>/sites/indodrilling/</DestinationWebUrlRelative>
    <DestinationFolderUrlRelative>/sites/indodrilling/AAL Development/</DestinationFolderUrlRelative>
      <DestinationServerUrl>http://teams-jkt.santos.com/</DestinationServerUrl>
      <DestinationListName>AAL Development</DestinationListName>
    </DestinationListSettings>
    <SourceColumns>
      <SourceFileNameAndPath>FullName</SourceFileNameAndPath>
      <ContentType>General Document</ContentType>
      <DestinationFileName>DestinationFileName</DestinationFileName>
    </SourceColumns>
  </Destination>
</DataSetImportSettings>
  1. I am using SharePoint 2010 on Premise
  2. Yes somefiles is succeeding and some not. But the case is vary, I have 251 Items to be imported. Sometimes only 50 items is successful, and sometimes 100 items is successful using the same source. The File size is vary... maximum is 10 MB. I also increase the upload limit in SharePoint to 100 MB but the error is still occurred.
  3. Here is the log file https://ufile.io/92b22
Btw how can I set metadata multivalue to be filled? I am aware that I cant use the ManagedMetaDataCSOM in sharepoint 2010.

Thanks
Coordinator
Nov 14, 2016 at 1:12 PM
You will need DIFS 2.6

Your server seems to have flood protection applied to limit the number of http requests but it is returning http 500 instead of 429 so DIFS is not quite sure how to deal with this.

You should use the PerItemImportThrottle to make DIFS pause after each import to avoid this being triggered.

You can check the updated documentation for how to use ManagedMetaDataAutoAdd with multiple terms.

Your log does show that some columns in your import source don't actually exist.

You should also refer to the updated documentation in respect to default mappings for created and modified dates since you appear to be trying to set these?
Nov 14, 2016 at 2:58 PM
MadAboutImport wrote:
You will need DIFS 2.6

Your server seems to have flood protection applied to limit the number of http requests but it is returning http 500 instead of 429 so DIFS is not quite sure how to deal with this.

You should use the PerItemImportThrottle to make DIFS pause after each import to avoid this being triggered.

You can check the updated documentation for how to use ManagedMetaDataAutoAdd with multiple terms.

Your log does show that some columns in your import source don't actually exist.

You should also refer to the updated documentation in respect to default mappings for created and modified dates since you appear to be trying to set these?
Thank you for your fast response, i will try the new DIFS 2.6 in the next morning and i will let you know the update.