Suche mit regex failed und wirft keinen Fehler
Ich hab versucht in der Suche s/^up zu suchen, der Suchindikator rotiert ewig und im Network Tab sehe ich das der Search-Request mit 400 gefailed ist:
request:
[
{
"name": "nd.bcd.list",
"old": {
"name_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"sorting_params_list": [
"name"
]
}
},
{
"name": "dns.record.list",
"old": {
"fqdn_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"is_auth": true,
"sorting_params_list": [
"fqdn"
]
}
},
{
"name": "dns.record.list",
"old": {
"data_regexp": "(?i).*^ub.*",
"is_auth": true,
"fetch_limit": 25,
"sorting_params_list": [
"data"
]
}
},
{
"name": "dns.fqdn.list",
"old": {
"value_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"sorting_params_list": [
"value"
]
}
},
{
"name": "nd.device.list",
"old": {
"fqdn": "s/^ub",
"fetch_limit": 25
}
},
{
"name": "org.unit.list",
"old": {
"name_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"sorting_params_list": [
"short_name"
]
}
},
{
"name": "org.unit.list",
"old": {
"short_name_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"sorting_params_list": [
"short_name"
]
}
},
{
"name": "cntl.group.list",
"old": {
"name": "s/^ub",
"fetch_limit": 25,
"sorting_params_list": [
"name"
]
}
},
{
"name": "cntl.group.list",
"old": {
"name_regexp": "(?i).*^ub.*",
"fetch_limit": 25,
"sorting_params_list": [
"name"
]
}
}
]
response:
{
"exception": {
"error": {
"code": 0,
"description": "[cntl] Generische Fehlermeldung bei Verletzung einer Prüfbedingung",
"details": null
},
"error_type": {
"code": -20102,
"name": "chk_constraint_violation",
"description": "Datensatzprüfkriterium verletzt"
},
"constraint": {
"name": null,
"description": null
},
"stacked_diag_params": {
"sqlstate": "23514",
"message": "value for domain dns.fqdn_type violates check constraint \"chk_fqdn_type_val\"",
"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 22 at RAISE\\nSQL statement \"SELECT eh.set_err(sd_rec, fpkg, fname, up_kv_rec_list, et_rec)\"\\nPL/pgSQL function wapi_4_0.insert_ta_stmt_value(record,wapi_4_0.ta_stmt,text,text,jsonb,boolean,text,jsonb,boolean,boolean) line 256 at PERFORM\\nSQL statement \"SELECT wapi_4_0.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_exists => param_rec_jsonb ? 'old_value',\\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_exists => param_rec_jsonb ? 'new_value',\\n --\\n in_conv_text2json => do_text2json\\n )\"\\nPL/pgSQL function wapi_4_0.insert_ta_stmt_list(bigint,wapi_4_0.imp_ta_stmt_rec_type[],text) line 105 at PERFORM\\nSQL statement \"SELECT wapi_4_0.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_4_0.ta_handler(text,text,text,boolean,boolean,boolean,boolean,text,text) line 28 at PERFORM",
"dml_src_table": null,
"schema": "dns",
"table": "",
"column": "",
"datatype": "fqdn_type",
"constraint": "chk_fqdn_type_val"
},
"others": {},
"traceback": [
{
"function": "cntl.standardize_fqdn",
"param": {
"dns.fqdn.value": [
{
"state": null,
"value": "s/^ub"
}
]
}
},
{
"function": "cntl.conv_daty_s2db",
"param": {
"nd.device.fqdn": [
{
"state": null,
"value": "s/^ub"
}
],
"cntl.data_type.name": [
{
"state": null,
"value": "fqdn"
}
]
}
},
{
"function": "wapi_4_0.insert_ta_stmt_value",
"param": {
"wapi.system.name": [
{
"state": null,
"value": "nd"
}
],
"wapi.object_type.name": [
{
"state": null,
"value": "device"
}
],
"wapi.transaction_stmt_param.name": [
{
"state": null,
"value": "fqdn"
}
],
"wapi.transaction_stmt_param.old_value": [
{
"state": null,
"value": "s/^ub"
}
],
"wapi.transaction_stmt_param.new_value": [
{
"state": null,
"value": null
}
]
}
},
{
"function": "wapi_4_0.insert_ta_stmt_list",
"param": {
"wapi.transaction_stmt.name": [
{
"state": null,
"value": "nd.device.list"
}
],
"wapi.transaction_stmt.pos": [
{
"state": null,
"value": 4
}
],
"wapi.transaction_stmt.idx": [
{
"state": null,
"value": "4"
}
]
}
}
],
"hint": null
}
}
Edited by Janis Streib