Alle OEs nicht anzeigbar
Wenn man mit globalen Leserechte /cntl/ou im NETVS aufruft und den Slider "Nur eigene Organisationseinheiten anzeigen" deaktiviert bekommt man folgende Fehlermeldung:
{
"failed_response": {
"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": "23505",
"message": "duplicate key value violates unique constraint \"unq_tmp_608342_0_pkey_org_unit\"",
"detail": "Key (key_nr)=(2339) already exists.",
"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 org_wapi_3_0.ta_stmt_handler(jsonb,jsonb,wapi_3_0.exec_ta_stmt_rec_type) line 61 at PERFORM\\nPL/pgSQL function wapi_3_0.exec_ta_handler(bigint,jsonb,boolean,boolean,boolean,boolean) line 564 at RETURN QUERY\\nPL/pgSQL function wapi_3_0.ta_handler(text,bigint,boolean,boolean,boolean) line 7 at RETURN QUERY",
"dml_src_table": null,
"schema": "pg_temp_11",
"table": "tmp_608342_0_pkey_org_unit",
"column": "",
"datatype": "",
"constraint": "unq_tmp_608342_0_pkey_org_unit"
},
"others": {},
"traceback": [
{
"function": "wapi_3_0.exec_ta_handler",
"param": {
"wapi.transaction_stmt.index": 0
}
}
]
}
},
"route_info": {
"path": "/cntl/ou"
}
}