error uploading detection file

[jkburges]

Detection file uploads are erroring for some files, e.g. https://aatams.emii.org.au/aatams/receiverDownloadFile/show/77353288

The exception in the log is:

2013-10-10 09:53:06,876 [quartzScheduler_Worker-9] [] ERROR FileProcessorJob - 
Assertion failed: 

assert(detSurgery.detectionId)
       |          |
       |          null
       [surgeryId:4463056, sensorId:4462993, 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)
        at au.org.emii.aatams.DetectionSurgery$addToPreparedStatement.call(Unknown Source)
        at au.org.emii.aatams.detection.JdbcTemplateVueDetectionFileProcessorService$_insertDetections_closure2_closure6.doCall(JdbcTemplateVueDetectionFileProcessorService.groovy:124)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:616)

[danfruehauf]

Bugger, works on my machine:

[jkburges]

Just a stab in the dark: were there any other uploads going on at the time?

[jkburges]

Unfortunately, we don't have logging going back that far so it's a bit hard to verify the above.

[danfruehauf]

No idea, that's my machine. Pretty inevitable for me to now restore the AATAMS DB on my machine and try again.

[jkburges]

No - I mean, when it happened on production, was there another upload happening? But we can't tell anyway...

[kereid]

A little more info from James not sure if it will help:

I just would like to clarify that it is not only the project manta csv uploads that are recording error messages. I have also received errors from shoalhaven uploads and I believe Stephanie Brodie also encountered an error whilst uploading data on the 29/10. I am unsure if these errors are related to the same issue or not.