pilmill9 / bioacoustics

0 stars 0 forks source link

SIO database detection document #17

Open marie-r opened 7 years ago

marie-r commented 7 years ago

This might not be a code issue. When iterating through the list of detection documents in the SIO database, there appears to be a document named: "SOCAL49M_d05-08 It cannot be retrieved by name using the standard query handler method q.GetDocument(collection, id) which formats the following string (Queries.Java/getDocument): String.format("for $d in collection(\"%s\") where base-uri($d) = \"dbxml:///%s/%s\" return $d", collection, collection, docname); returning that there is an unexpected qualified name.

We need to investigate to see what is going on here. Is there a valid document with this name or is it empty and if so we should delete it. Surprisingly, looking in metadata/source-docs/Detections where the source material should be archived, there is nothing that matches the glob: ls SOCAL49M_d05

marie-r commented 7 years ago

It looks like there are a fair number of attempts to add documents that resulted in empty documents. The following detection documents are empty:

./Detections/- ./Detections/-d ./Detections/.a ./Detections/05C ./Detections/06 ./Detections/09 ./Detections/10C ./Detections/10G ./Detections/11 ./Detections/12 ./Detections/14G ./Detections/16C ./Detections/18G ./Detections/19G ./Detections/23G ./Detections/26G ./Detections/31G2 ./Detections/32G2 ./Detections/33G2 ./Detections/35G2 ./Detections/a ./Detections/b ./Detections/c ./Detections/calls ./Detections/CINMS01C ./Detections/CINMS01C.GgLo ./Detections/CINMS02B ./Detections/CINMS02C ./Detections/CINMS03B ./Detections/CINMS03C ./Detections/CINMS03J ./Detections/CINMS03K ./Detections/CINMS04B ./Detections/CINMS04C ./Detections/CINMS04J ./Detections/CINMS04K ./Detections/CINMS05B ./Detections/CINMS05C ./Detections/CINMS05K2 ./Detections/CINMS06B ./Detections/CINMS07J ./Detections/CINMS07K3 ./Detections/CINMS08B ./Detections/CINMS08J ./Detections/CINMS08K3 ./Detections/CINMS09B ./Detections/CINMS09J ./Detections/CINMS10B ./Detections/CINMS10C ./Detections/CINMS12B ./Detections/CINMS12B_disks_1-16_df100_20finDPI-too ./Detections/CINMS12C ./Detections/CINMS13B ./Detections/CINMS13C ./Detections/CINMS14B ./Detections/CINMS15C ./Detections/CINMS16B ./Detections/CINMS16C ./Detections/CINMS17B ./Detections/CINMS17C ./Detections/CINMS18B ./Detections/CINMS18C ./Detections/CINMS19B ./Detections/CINMS19C ./Detections/CINMS20B ./Detections/CINMS20C ./Detections/CINMS21B ./Detections/CINMS21C ./Detections/CINMS22B ./Detections/CINMS22C ./Detections/CINMS23B ./Detections/CINMS23C ./Detections/CINMS24B ./Detections/CINMS24C ./Detections/CINMS25B ./Detections/CINMS25C ./Detections/CINMS26B ./Detections/CINMS26C ./Detections/CINMS27B ./Detections/CINMS27C ./Detections/CINMS28B ./Detections/CINMS28C ./Detections/counts ./Detections/d ./Detections/data ./Detections/EBK.Tethys ./Detections/Echosounders ./Detections/Explosion ./Detections/GofAK_CB02_d05-08_LF_SCJ_all ./Detections/GofMX_GC01_BW_pickLog_kpm120730_formatted ./Detections/GofMX_GC01_Pms_pickLog_kpmedited111215 ./Detections/GofMX_MC04_BW_pickLog_kpm120730_formatted ./Detections/GofMX_MC04_Ksp_pickLog_kpm120206 ./Detections/GofMX_MC04_Pms_pickLog_kpm111219 ./Detections/Hawaii08hf ./Detections/images ./Detections/LJ31P ./Detections/LJ32P ./Detections/LJ33P ./Detections/LJ34P ./Detections/LJ35P ./Detections/logs_as ./Detections/long ./Detections/MBARI01M1 ./Detections/only_SCJ_no ./Detections/parts ./Detections/Point ./Detections/Ships_aa ./Detections/SOCAL ./Detections/SOCAL01A ./Detections/SOCAL01C ./Detections/SOCAL02A ./Detections/SOCAL02C ./Detections/SOCAL04A ./Detections/SOCAL05A ./Detections/SOCAL05E ./Detections/SOCAL07E ./Detections/SOCAL08A ./Detections/SOCAL09B ./Detections/SOCAL11B ./Detections/SOCAL14B ./Detections/SOCAL15A ./Detections/SOCAL16B ./Detections/SOCAL18H ./Detections/SOCAL19A ./Detections/SOCAL22A ./Detections/SOCAL26A2 ./Detections/SOCAL26B ./Detections/SOCAL26H ./Detections/SOCAL26J ./Detections/SOCAL27A2 ./Detections/SOCAL27H ./Detections/SOCAL28A2 ./Detections/SOCAL29H ./Detections/SOCAL30J ./Detections/SOCAL32B ./Detections/SOCAL32C ./Detections/SOCAL32K2 ./Detections/SOCAL33A2 ./Detections/SOCAL34M ./Detections/SOCAL35K3 ./Detections/SOCAL36H ./Detections/SOCAL37H ./Detections/SOCAL37P_DL19 ./Detections/SOCAL37S ./Detections/SOCAL38H ./Detections/SOCAL38P ./Detections/SOCAL38S ./Detections/SOCAL41S ./Detections/SOCAL44H_LF_d01-09_SCJ_no ./Detections/SOCAL44M_LF_disks01-04_BmD ./Detections/SOCAL45H_LF_disks01-04_SCJ_no ./Detections/SOCAL46H ./Detections/SOCAL46N_LF_disks01-08_SCJ_no ./Detections/SOCAL47H_LF_disks04-06_SCJ_no ./Detections/SOCAL49H ./Detections/SOCAL49N_MF_Broadband ./Detections/SOCAL52M ./Detections/SOCAL53H ./Detections/SOCAL53M ./Detections/SOCAL53N ./Detections/SOCAL54H ./Detections/SOCAL54M ./Detections/SOCAL54N ./Detections/SOCAL55H ./Detections/SOCAL55N ./Detections/SOCAL56H ./Detections/SOCAL56N ./Detections/SOCAL57N ./Detections/SOCAL58H ./Detections/Sur ./Detections/WAT_NC_01

These will need to be removed and we'll need to determine what is causing these. A user should not be able to make an empty document, we may need to update our validation rules.