So far, i tracked down the error and fixed on my source code.
The bug is in the source code of acs-kernel version 5.5 and 5.6 (if not also on HEAD) within the file /acs-kernel/sql/postgresql/apm-create.sql line 1537
The error is in the select query in the line 1549:
"and parameter_id = get_value__parameter_id"
when it must be "and parameter_id = v_parameter_id" instead
You can take a look at the psql function from /api-doc
/api-doc/plsql-subprogram-one?type=FUNCTION&name=apm__get_value
create or replace function apm__get_value(int4,varchar) returns varchar as '
1:declare
2: get_value__package_id alias for $1;
3: get_value__parameter_name alias for $2;
4: v_parameter_id apm_parameter_values.parameter_id%TYPE;
5: value apm_parameter_values.attr_value%TYPE;
6:begin
7: v_parameter_id := apm__id_for_name (get_value__package_id, get_value__parameter_name);
8:
9: select attr_value into value from apm_parameter_values v
10: where v.package_id = get_value__package_id
11: and parameter_id = get_value__parameter_id;
12:
13: return value;
14:
15:end;' language 'plpgsql';
cheers,