API 4.1: nd.bcd.list: column \"bcd.dns_search_list\" must appear in the GROUP BY clause or be used in an aggregate function
{
"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": "42803",
"message": "column \"bcd.dns_search_list\" must appear in the GROUP BY clause or be used in an aggregate function",
"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 nd_wapi_4_1.ta_stmt_handler(jsonb,wapi_4_1.exec_ta_stmt_rec_type) line 528 at PERFORM\\nSQL statement \"select\\n eh_ret_stmt_pos, eh_ret_stmt_idx,\\n (attrs.dict #> array[int_dwh_tab_arg_name, dwh_gpk_col_name])::bigint,\\n attrs.dict - attrs.fattrs,\\n nextval('obj_dict_pos_seq')\\n from nd_wapi_4_1.ta_stmt_handler(in_ta_osr_jsonb => stmt_osr_jsonb, in_stmt_rec => rp_tah_stmt_rec) as attrs(dict, fattrs)\"\\nPL/pgSQL function wapi_4_1.exec_ta_handler(bigint,jsonb,boolean,boolean,boolean,boolean,text,text) line 1107 at RETURN QUERY\\nSQL statement \"select tah.out_stmt_pos, tah.out_stmt_idx, tah.out_obj_dict from wapi_4_1.exec_ta_handler(\\n in_ta_id => ta_id,\\n in_ta_osr_jsonb => ta_osr_jsonb,\\n in_keep_tmp_ta => in_keep_tmp_ta,\\n in_report_stmt_pos => in_report_stmt_pos,\\n in_is_dry_mode => in_is_dry_mode,\\n in_ignore_maint_state => in_ignore_maint_state,\\n in_su_login_name => in_su_login_name,\\n in_language_tag => in_language_tag\\n ) AS tah\"\\nPL/pgSQL function wapi_4_1.ta_handler(text,text,text,boolean,boolean,boolean,boolean,text,text) line 33 at RETURN QUERY",
"dml_src_table": null,
"schema": "",
"table": "",
"column": "",
"datatype": "",
"constraint": ""
},
"others": {},
"traceback": [
{
"function": "wapi_4_1.exec_ta_handler",
"param": {
"wapi.transaction_stmt.pos": [
{
"state": null,
"value": 0
}
],
"wapi.transaction_stmt.idx": [
{
"state": null,
"value": "bcd_list"
}
]
}
}
],
"hint": null
}
}Request:
[
{
"idx": "bcd_list",
"name": "nd.bcd.list",
"old": {
"is_own": true,
"sorting_params_list": [
"name"
]
}
},
{
"idx": "bcd2ou_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "nd.bcd2ou.list"
},
{
"idx": "unit_list",
"inner_join_ref": {
"bcd2ou_list": "default"
},
"name": "org.unit.list"
},
{
"idx": "ip_subnet_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "nd.ip_subnet.list"
},
{
"idx": "vlan_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "nd.vlan.list"
},
{
"idx": "vxlan_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "nd.vxlan.list"
},
{
"idx": "bcd_categ_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "ndcfg.bcd_categ.list"
},
{
"idx": "bcd_seclvl_list",
"inner_join_ref": {
"bcd_list": "default"
},
"name": "ndcfg.bcd_seclvl.list"
},
{
"idx": "__lang_bcd_categ_list",
"inner_join_ref": {
"bcd_categ_list": null
},
"name": "cntl.ot_lang_attr_val.list"
},
{
"idx": "__lang_bcd_seclvl_list",
"inner_join_ref": {
"bcd_seclvl_list": null
},
"name": "cntl.ot_lang_attr_val.list"
}
]Activity
changed milestone to %API 4.1 Release
assigned to @rainer.steinmueller and @ao2437
unassigned @ao2437
Jetzt ist es das (selber request):
{ "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": "42803", "message": "column \"bcd.dns_search_list\" must appear in the GROUP BY clause or be used in an aggregate function", "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 nd_wapi_4_1.ta_stmt_handler(jsonb,wapi_4_1.exec_ta_stmt_rec_type) line 528 at PERFORM\\nSQL statement \"select\\n eh_ret_stmt_pos, eh_ret_stmt_idx,\\n (attrs.dict #> array[int_dwh_tab_arg_name, dwh_gpk_col_name])::bigint,\\n attrs.dict - attrs.fattrs,\\n nextval('obj_dict_pos_seq')\\n from nd_wapi_4_1.ta_stmt_handler(in_ta_osr_jsonb => stmt_osr_jsonb, in_stmt_rec => rp_tah_stmt_rec) as attrs(dict, fattrs)\"\\nPL/pgSQL function wapi_4_1.exec_ta_handler(bigint,jsonb,boolean,boolean,boolean,boolean,text,text) line 1107 at RETURN QUERY\\nSQL statement \"select tah.out_stmt_pos, tah.out_stmt_idx, tah.out_obj_dict from wapi_4_1.exec_ta_handler(\\n in_ta_id => ta_id,\\n in_ta_osr_jsonb => ta_osr_jsonb,\\n in_keep_tmp_ta => in_keep_tmp_ta,\\n in_report_stmt_pos => in_report_stmt_pos,\\n in_is_dry_mode => in_is_dry_mode,\\n in_ignore_maint_state => in_ignore_maint_state,\\n in_su_login_name => in_su_login_name,\\n in_language_tag => in_language_tag\\n ) AS tah\"\\nPL/pgSQL function wapi_4_1.ta_handler(text,text,text,boolean,boolean,boolean,boolean,text,text) line 33 at RETURN QUERY", "dml_src_table": null, "schema": "", "table": "", "column": "", "datatype": "", "constraint": "" }, "others": {}, "traceback": [ { "function": "wapi_4_1.exec_ta_handler", "param": { "wapi.transaction_stmt.pos": [ { "state": null, "value": 0 } ], "wapi.transaction_stmt.idx": [ { "state": null, "value": "bcd_list" } ] } } ], "hint": null } }
Please register or sign in to reply