Random images upload corrupt on larger batches

Question

When uploading small png files 100KB or less some randomly get corrupted. This was not always a problem and seemes to have croppted up but none of the code was ever changed.
&nbsp;
Public Async Function DropboxUpload(ByVal sql As String) As Task
Dim conn As New System.Data.SqlClient.SqlConnection(PrintQueue.ConnectionString)
Dim adpt As New System.Data.SqlClient.SqlDataAdapter(sql, conn)
Dim dt As New DataTable()
adpt.Fill(dt)
Using dbx As New DropboxClient("xxx")
Dim i As Integer
For i = 0 To dt.Rows.Count - 1

Using mem As New FileStream("\r2d2.agslab.local\Prod_Data\RaytracerImages\ASET\final\s" &amp; dt.Rows(i).Item("lngstoneid").ToString &amp; ".png", FileMode.Open, FileAccess.Read)
Dim updated = Await dbx.Files.UploadAsync("/" &amp; dt.Rows(i).Item("lngstoneid").ToString &amp; ".png", Dropbox.Api.Files.WriteMode.Overwrite.Instance, body:=mem)
End Using
&nbsp;
Next
End Using
dt.Dispose()
adpt.Dispose()
conn.Close()
conn.Dispose()
End Function
&nbsp;

Greg-DB · Answer

Thanks for the report! We'll be happy to look into this, but we could use some more information to help us reproduce this. Can you please share:

- a sample original file (before being corrupted)
- the output of some additional logging showing the correct contents in the mem object before upload (e.g., a hash)
- the output of the API call for a corrupted file upload
- a sample corrupted file

Thanks in advance!

gtordjman · Answer

Here is a link to the corrput file&nbsp;https://www.dropbox.com/s/pzwq0mo6lgceark/104093225044.png?dl=0&nbsp;Link to the original file that isn't&nbsp;https://www.dropbox.com/s/uxjs630oyg6d45v/s104093225044.png?dl=0&nbsp;I need to log the&nbsp;output but is there a specific item in the API output I should be looking for? File sizes are the same but MD5 doesn't match.

Greg-DB · Answer

Thanks! It appears these two files only differ by two seemingly random bytes.

If you can print the full metadata returned by the upload call, and a hash value of the returned contents of mem right before the corrupted upload, that would be helpful. Also, since it seems like this happens randomly, if you could also include the specific files for the output you share that would be useful.

gtordjman · Answer

These Hashes are MD5&nbsp;File15/21/2017 2:01:44 PM File: 104089993044.png Hash: d89be0f0ecf34eb9c194d335c4266a685/21/2017 2:01:44 PM API Return Data: Id id:vGOpbpekL5AAAAAAAAAbaA5/21/2017 2:01:44 PM API Return Data: ClientModified 5/21/2017 9:01:44 PM5/21/2017 2:01:44 PM API Return Data: ServerModified 5/21/2017 9:01:44 PM5/21/2017 2:01:44 PM API Return Data: Rev 36d44dd81a3a5/21/2017 2:01:44 PM API Return Data: Size 174925/21/2017 2:01:44 PM API Return Data: MediaInfo5/21/2017 2:01:44 PM API Return Data: SharingInfo5/21/2017 2:01:44 PM API Return Data: PropertyGroups5/21/2017 2:01:44 PM API Return Data: HasExplicitSharedMembers5/21/2017 2:01:44 PM API Return Data: ContentHash d9f4df76dc2a9b03ae9f8b42cba3bdeddd99f8712a562709c6b21010f4fe842e5/21/2017 2:01:44 PM API Return Data: IsFile True5/21/2017 2:01:44 PM API Return Data: IsFolder False5/21/2017 2:01:44 PM API Return Data: AsFolder5/21/2017 2:01:44 PM API Return Data: IsDeleted False5/21/2017 2:01:44 PM API Return Data: AsDeleted5/21/2017 2:01:44 PM API Return Data: Name 104089993044.png5/21/2017 2:01:44 PM API Return Data: PathLower /104089993044.png5/21/2017 2:01:44 PM API Return Data: PathDisplay /104089993044.png5/21/2017 2:01:44 PM API Return Data: ParentSharedFolderIdhttps://www.dropbox.com/s/g20ts7y9xmmqrzv/104089993044.png?dl=0&nbsp;File 2&nbsp;5/21/2017 2:01:48 PM File: 104089993054.png Hash: 03e49852ceabec2a05b07dc98d4096ca5/21/2017 2:01:49 PM API Return Data: Id id:vGOpbpekL5AAAAAAAAAbbw5/21/2017 2:01:49 PM API Return Data: ClientModified 5/21/2017 9:01:49 PM5/21/2017 2:01:49 PM API Return Data: ServerModified 5/21/2017 9:01:49 PM5/21/2017 2:01:49 PM API Return Data: Rev 36db4dd81a3a5/21/2017 2:01:49 PM API Return Data: Size 182265/21/2017 2:01:49 PM API Return Data: MediaInfo5/21/2017 2:01:49 PM API Return Data: SharingInfo5/21/2017 2:01:49 PM API Return Data: PropertyGroups5/21/2017 2:01:49 PM API Return Data: HasExplicitSharedMembers5/21/2017 2:01:49 PM API Return Data: ContentHash ce21d0c6e4946f8d265a6c27c6a403826ab1e619ce4b92537e4481ddf21960ac5/21/2017 2:01:49 PM API Return Data: IsFile True5/21/2017 2:01:49 PM API Return Data: IsFolder False5/21/2017 2:01:49 PM API Return Data: AsFolder5/21/2017 2:01:49 PM API Return Data: IsDeleted False5/21/2017 2:01:49 PM API Return Data: AsDeleted5/21/2017 2:01:49 PM API Return Data: Name 104089993054.png5/21/2017 2:01:49 PM API Return Data: PathLower /104089993054.png5/21/2017 2:01:49 PM API Return Data: PathDisplay /104089993054.png5/21/2017 2:01:49 PM API Return Data: ParentSharedFolderIdhttps://www.dropbox.com/s/aks7hwao8u18shh/104089993054.png?dl=0&nbsp;File 35/21/2017 2:01:50 PM File: 104089993056.png Hash: 158a2c4fa5fa813128d82b8b437bf3515/21/2017 2:01:50 PM In QR5/21/2017 2:01:52 PM API Return Data: Id id:vGOpbpekL5AAAAAAAAAbcQ5/21/2017 2:01:52 PM API Return Data: ClientModified 5/21/2017 9:01:50 PM5/21/2017 2:01:52 PM API Return Data: ServerModified 5/21/2017 9:01:50 PM5/21/2017 2:01:52 PM API Return Data: Rev 36dd4dd81a3a5/21/2017 2:01:52 PM API Return Data: Size 183175/21/2017 2:01:53 PM API Return Data: MediaInfo5/21/2017 2:01:53 PM API Return Data: SharingInfo5/21/2017 2:01:53 PM API Return Data: PropertyGroups5/21/2017 2:01:53 PM API Return Data: HasExplicitSharedMembers5/21/2017 2:01:53 PM API Return Data: ContentHash 0be68a169fa35229a951165365562bcbfaae391849dafc9fc8817151df5f6cea5/21/2017 2:01:53 PM API Return Data: IsFile True5/21/2017 2:01:53 PM API Return Data: IsFolder False5/21/2017 2:01:53 PM API Return Data: AsFolder5/21/2017 2:01:53 PM API Return Data: IsDeleted False5/21/2017 2:01:53 PM API Return Data: AsDeleted5/21/2017 2:01:53 PM API Return Data: Name 104089993056.png5/21/2017 2:01:53 PM API Return Data: PathLower /104089993056.png5/21/2017 2:01:53 PM API Return Data: PathDisplay /104089993056.png5/21/2017 2:01:53 PM API Return Data: ParentSharedFolderIdhttps://www.dropbox.com/s/fkdy7lps4b0umkx/104089993056.png?dl=0

gtordjman · Answer

I actually found the problem. It has to do with our sonicwall, a setting was changed earlier this year where the sonicwall issues an SSL certificate to each client and makes the secured connection outside of our network so traffic could be monitored (DPI-SSL). I added dropbox to the exclusions list and now it seems to be working.

Thanks

Forum Discussion

Random images upload corrupt on larger batches

6 Replies

About Dropbox API Support & Feedback

Related Content

All files downloaded from Dropbox are corrupt

Corrupt file disappeared??

Start Dropbox in batch file - Windows10

Corrupted Word Documents

Image appears to be corrupted

Recent Discussions

/oauth2/authorize (code flow) redirects to http://www.dropbox.com/home instead of redirect_uri

Add id and .tag fields to DeletedMetadata in the API

Shared Link - Download in .NET

Dropbox API server root certificate changes for .Net

GetCurrentAccountAsync API Failing for some Team Members while using Impersonation