CMDBuild Forum

V2.4.1 Error printing cards, services/json/management/modreport/printcarddetails

CMDBuild 2.4.1 (upgraded from 2.4.0 where I had different error when printing cards), Tomcat 7.0.68, jdk 1.8.0_77 and postgresql-9.4-1206-jdbc42.jar

Printing single card of "ApplicationLists" ends up to this error. Other classes are ok, this one fails (tried several cards).

Call: services/json/management/modreport/printcarddetails
----------------------------------------------------------
Error: net.sf.jasperreports.engine.JRException: Unknown column name ApplicationLists#User_rights_management_responsibility#Description in result set.
 at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:454)
 at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:155)
 at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1373)
 at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1274)
 at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1250)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1010)
 at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:117)
 at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:558)
 at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:396)
 at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:91)
 at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:456)
 at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:863)
 at org.cmdbuild.report.ReportFactory.fillReport(ReportFactory.java:94)
 at org.cmdbuild.report.ReportFactoryTemplate.fillReport(ReportFactoryTemplate.java:77)
 at org.cmdbuild.servlets.json.management.ModReport.printCardDetails(ModReport.java:345)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:104)
 at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:64)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:188)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.cmdbuild.filters.LocalizationFilter.doFilter(LocalizationFilter.java:127)
 at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
 at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190)
 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.lang.Thread.run(Thread.java:745)

You should use shorter names in your data model.
The CMDBuild engine for SQL queries execution builds the queries using for reference fields “aliases” built with the domain name, in your example:

ApplicationLists#User_rights_management_responsibility#Description

Postgres does not accept names / aliases with a total length of more than 64 characters (unless you recompile it with a different option) and your alias is 66 characters long.
CMDBuild Team