Manche suchen nach FQDN verursachen HTTP 400, aber Fehlermeldung wird nicht angezeigt
Wenn man zum Beispiel nach der (nichtexistenten) Domain ... sucht, gibt der execute-Endpoint Fehler 400 zurück mit content:
{
"exception": {
"error": {
"code": 1,
"description": "[cntl] Ungültige Eingabesyntax für entsprechenden Datentyp",
"details": null
},
"error_type": {
"code": -20900,
"name": "format_error",
"description": "Datentyp-Formatierungsfehler"
},
"constraint": {
"name": null,
"description": null
},
"stacked_diag_params": {
"sqlstate": "23514",
"message": "value for domain strng.short_uc_kw_type violates check constraint \"chk_short_uc_kw_type_len\"",
"detail": "",
"hint": "",
"context": "PL/pgSQL function eh.set_err(eh.stacked_diag_params_rec_type,name,name,eh.userparams_kv_rec_type[],eh.typecode_rec_type) line 8 at RAISE\\nSQL statement \"SELECT eh.set_err(sd_rec, fpkg, fname, up_kv_rec_list, et_rec)\"\\nPL/pgSQL function wapi_3_2.insert_ta_stmt_value(record,wapi_3_2.ta_stmt,text,text,jsonb,bigint,text,boolean,boolean,text,jsonb,bigint,text,boolean,boolean,boolean,text) line 228 at PERFORM\\nSQL statement \"SELECT wapi_3_2.insert_ta_stmt_value(\\n in_cvsn_rec => cvsn_rec,\\n in_stmt_rec => wapi_ta_stmt_rec,\\n in_stmt_param_name => param_rec_jsonb ->> 'name',\\n --\\n in_stmt_old_value => param_rec_jsonb ->> 'old_value',\\n in_stmt_old_value_jsonb => param_rec_jsonb -> 'old_value',\\n in_stmt_old_r_pos => (stmt_idx2pos_dict -> old_ref_stmt_idx)::integer,\\n\\n in_stmt_old_r_param => param_rec_jsonb ->> 'old_ref_stmt_param',\\n -- default: false (falls nicht angegeben)\\n in_stmt_old_r_allow_no_data => param_rec_jsonb ? 'old_ref_allow_no_data' and (param_rec_jsonb ->> 'old_ref_allow_no_data')::boolean,\\n in_stmt_old_exists => old_exists,\\n --\\n in_stmt_new_value => param_rec_jsonb ->> 'new_value',\\n in_stmt_new_value_jsonb => param_rec_jsonb -> 'new_value',\\n in_stmt_new_r_pos => (stmt_idx2pos_dict -> new_ref_stmt_idx)::integer,\\n\\n in_stmt_new_r_param => param_rec_jsonb ->> 'new_ref_stmt_param',\\n -- default: false (falls nicht angegeben)\\n in_stmt_new_r_allow_no_data => param_rec_jsonb ? 'new_ref_allow_no_data' and (param_rec_jsonb ->> 'new_ref_allow_no_data')::boolean,\\n in_stmt_new_exists => new_exists,\\n --\\n in_conv_text2json => do_text2json,\\n in_src_fmt => in_src_fmt\\n )\"\\nPL/pgSQL function wapi_3_2.insert_ta_stmt_list(bigint,wapi_3_2.imp_ta_stmt_rec_type[],text,text) line 128 at PERFORM\\nSQL statement \"SELECT wapi_3_2.insert_ta_stmt_list(\\n in_ta_id => ta_id,\\n in_stmt_list => stmt_list,\\n in_http_rq_mthd => in_http_rq_mthd\\n )\"\\nPL/pgSQL function wapi_3_2.ta_handler(text,text,text,boolean,boolean,boolean,boolean,text) line 22 at PERFORM",
"dml_src_table": null,
"schema": "strng",
"table": "",
"column": "",
"datatype": "short_uc_kw_type",
"constraint": "chk_short_uc_kw_type_len"
},
"others": {},
"traceback": [
{
"function": "cntl.conv_daty_s2db",
"param": {
"org.unit.short_name": "USCJERUSALEM.USC.UNI-KARLSRUHE.DE",
"cntl.data_type.name": "text_kw_uc_short"
}
},
{
"function": "wapi_3_2.insert_ta_stmt_value",
"param": {
"wapi.transaction_stmt_param.name": "short_name",
"wapi.transaction_stmt_param.old_value": "USCJERUSALEM.USC.UNI-KARLSRUHE.DE",
"wapi.transaction_stmt_param.new_value": null
}
},
{
"function": "wapi_3_2.insert_ta_stmt_list",
"param": {
"wapi.transaction_stmt.pos": 6,
"wapi.transaction_stmt.idx": "6"
}
}
]
}
}
Die Fehlermeldung wird vom Frontend aber nicht mit dem Poostorm-Fehler angezeigt. Es lädt einfach forever.
Habe leider keinen anderen FQDN gefunden, die das Problem auslöst.
Edited by ts9019