Skip to content

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
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information