Skip to content

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.

image

Habe leider keinen anderen FQDN gefunden, die das Problem auslöst.

Edited by Peter Oettig
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information