jbrzusto / TO_DO

sensorgnome / motus TODO list for jbrzusto
0 stars 0 forks source link

file processing errors #140

Open zcrysler opened 6 years ago

zcrysler commented 6 years ago

Junior Tremblay has had a few errors when uploading data, one seems to have prevented data from processing, the other has not, but he still wants to know why in case it's an issue on his end:

This is the most recent error, the data looks like it was processed fine but he wants to know what the issue was for project 3: Job ID 884253 File uploaded: SGdata.zip Will run tag finder on 49 receiver boot sessions Error: Error in result_bind_rows(rs@ptr, values): Column 'len' cannot be null [1048]

He also uploaded data for project 159 back in October which had errors that prevented processing, and still seems as though it hasn't gone through (at least in hourly plots). The data files were: Tour3_BBBK1778_proj159.zip Tour1_BBBK1031.zip Tour2_BBBK1749.zip Tour3_BBBK1778.zip garage_BBBK0110.zip

I think the error message was the same for all of them, but this is the one he sent me: Objet : motus job 665626: processing complete Thank-you for the upload - it has been processed. Any product(s) are listed here:

Processing Summary: File uploaded: Tour3_BBBK1778.zip Error: Error in sqliteSendQuery(con, statement, bind.data): rsqlite_query_send: could not execute: UNIQUE constraint failed: files.name

The file he uploaded looks ok and should have data up to Oct 5th, but that receiver was last updated June 29th in project 0