ices-eg / wg_WGEEL

Joint EIFAAC/ICES/GFCM Working Group on Eels
http://ices.dk/community/groups/Pages/WGEEL.aspx
5 stars 12 forks source link

Annex 5, integration fails #248

Closed jdpo closed 1 year ago

jdpo commented 1 year ago

Integrating did not work; gives an error:

Error: Failed to fetch row: ERROR: new row for relation "t_eelstock_eel" violates check constraint "ck_qal_id_and_missvalue" DETAIL: Failing row contains (549699, 6, 2020, null, LT_total, LT, Y, F, null, 0, null, landings recorded in 2019, 2022-09-08, NC, dc_2022, Public).

Notable: In this line there is no value and the qualifier in the line that does not work is "NC", otherwise it looks fine