Error encountered uploading data on 29/10 about aatams HOT 3 CLOSED

Hi Kate,

I am still getting error emails from this events file. It is related to Project Manta again…I have attached the CSV to see if you can find where this is originating from.

Cheers,
James

P.s.As I (Kate) cannot find an easy way to upload a file to Gihub I've saved the csv file in Sheryl > Portal 2 Release 1 > proj manta csv file for aatams bug #42

from aatams.

Error encountered by Stephanie Brodie on 29/10 was:

2013-10-29 09:23:13,188 [quartzScheduler_Worker-8] [] ERROR FileProcessorService - Error processing file
Assertion failed:

assert(detSurgery.detectionId)
| |
| null
[surgeryId:4462616, sensorId:2240259, detectionId:null]

    at org.codehaus.groovy.runtime.InvokerHelper.assertFailed(InvokerHelper.java:386)
    at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.assertFailed(ScriptBytecodeAdapter.java:662)
    at au.org.emii.aatams.DetectionSurgery.addToPreparedStatement(DetectionSurgery.groovy:82)

I believe these errors have been resolved by 6f9dd32 - "reverted little bobby tables branch" which was merged on 10/11/2013

The commit above fixes problems reporting date format errors when uploading the Project Manta CSV file provided by James above.

Note that the incorrectly formatted dates in the CSV file will need to be corrected before this file can be uploaded and that this can be done independently to the problems reporting this issue being fixed in production. The format required is "yyyy-MM-dd HH:mm:ss Z"

from aatams.

Closing this. Trying to upload the "project manta" file results in an error: "Incorrect format for Date/Time expected yyyy-MM-dd HH:mm:ss Z" which is correct given the date format used in the file (e.g. 13/09/2007 12:38)

from aatams.