CMDBuild Forum

Inexistent attribute "IdClass" for table "_Dashboards"

Old Versions
#1

Hi,

We have updated from CMDBUILD 2.0 to  2.0.2.

When we create a new Chart in a Dashboard, the Data source not shows the list of PostgreSQL functions available.

We have got three functions:

CREATE OR REPLACE FUNCTION cmf_active_cards_for_class... 

ALTER FUNCTION cmf_active_cards_for_class(character varying)

  OWNER TO cmdb;

COMMENT ON FUNCTION cmf_active_cards_for_class(character varying) IS 'TYPE: function';

 
CREATE OR REPLACE FUNCTION cmf_count_active_cards...
ALTER FUNCTION cmf_count_active_cards(character varying)
  OWNER TO cmdb;
COMMENT ON FUNCTION cmf_count_active_cards(character varying) IS 'TYPE: function';
 
and
 
CREATE OR REPLACE FUNCTION cmf_vms_for_area...
ALTER FUNCTION cmf_vms_for_area()
  OWNER TO cmdb;
COMMENT ON FUNCTION cmf_vms_for_area() IS 'TYPE: function';
 
And the /var/log/tomcat6/cmdbuild.log file shows:

ERROR 2012-10-25 14:51:47 [persist ] Inexistent attribute "IdClass" for table "_Dashboards"

ERROR 2012-10-25 14:51:47 [sql     ] Inexistent attribute "IdClass" for table "_Dashboards"

Which is the problem?

Thanks. 

#2

Hi,

please don't care about the errors like "Inexistent attribute "IdClass" for table "_Dashboards" which is not a real problem.
 
About your problem: could you execute select _cm_function_list() and post here the result?
Remember that after you created a new function you need to clean CMDBuild's cache.
 
Best regards.
 
#3
Hi,
 
This is the output:
 
cmdb=> select _cm_function_list();
                                         _cm_function_list
----------------------------------------------------------------------------------------------------
 (cmf_vms_for_area,37198,"{o,o}","{Area,NumVMs}","{varchar,int4}",t)
 (cmf_active_cards_for_class,37129,"{i,o,o}","{ClassName,Class,Number}","{varchar,varchar,int4}",t)
 (cmf_count_active_cards,37130,"{i,o}","{ClassName,Count}","{varchar,int4}",f)
(3 rows)
 
Regards
#4

Thanks,

we reproduced and solved your problem caused by and error while serializing the functions.
The fix will be available in the next release.
 
Kind regards.
#5

Previously Tecnoteca wrote:

Thanks,

we reproduced and solved your problem caused by and error while serializing the functions.
The fix will be available in the next release.
 
Kind regards.
Hi, I am also having the same problem. When I am trying to click a process from workflow, "failure Class 32648 non found" is displaying. 
In the cmdbuild.log, following logs are written,
ERROR 2013-05-03 14:52:04 [persist ] Inexistent attribute "IdClass" for table "_Dashboards"
ERROR 2013-05-03 14:52:04 [sql     ] Inexistent attribute "IdClass" for table "_Dashboards"
 
I am using cmdbuild 2.0.4 and cmdbuild-shark-server-2.0.4 with postgresql 8.4 in windows.
 
Any help is much appreciated.
 
Thanks in advance.