I wrote this function as following:
CREATE OR REPLACE FUNCTION cmf_apache_host_view(OUT os "LookUp", OUT system character varying, OUT admin character varying)
RETURNS SETOF record AS
$BODY$BEGIN
RETURN QUERY SELECT
"host"."os" as"os",
"Apache"."system",
"Apache"."admin"
FROM "host","Apache"
WHERE
"Apache"."ip" = "host"."ip";
END$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION cmf_apache_host_view()
OWNER TO postgres;
COMMENT ON FUNCTION cmf_apache_host_view() IS 'TYPE: function';
After clean the cache, I got this error:
Call: services/json/dashboard/list
-----------------------------------
Error: org.cmdbuild.servlets.json.management.JsonSerializationException: org.codehaus.jackson.map.JsonMappingException: (was java.lang.UnsupportedOperationException) (through reference chain: org.cmdbuild.servlets.json.management.JsonResponse["response"]->org.cmdbuild.servlets.json.serializers.JsonDashboardListResponse["dataSources"]->java.util.ArrayList[1]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])
Caused by: org.codehaus.jackson.map.JsonMappingException: (was java.lang.UnsupportedOperationException) (through reference chain: org.cmdbuild.servlets.json.management.JsonResponse["response"]->org.cmdbuild.servlets.json.serializers.JsonDashboardListResponse["dataSources"]->java.util.ArrayList[1]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])
Caused by: java.lang.UnsupportedOperationException
at org.cmdbuild.dao.entrytype.attributetype.UndefinedAttributeType.accept(UndefinedAttributeType.java:17)
Can you help me to fix it! Thank you all!