CMDBuild Forum

Error in services/json/dashboard/fulllist

Hi, 

I have got never any dashboard in the project. I have experimented with view based on SQL / DB function now. After that the error started to occur every time during start and reaload the application or open the (empty) dashboard menu. It is the same in both modules. 

Please help me by any hint hoe to repair this issue. I removed all crated views, restart Tomcat and no effect. 

Thanks in advance,

Jiří

Here is the error:

Call: services/json/dashboard/fulllist

---------------------------------------

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[16]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])

at org.cmdbuild.servlets.json.management.JsonResponse.toString(JsonResponse.java:61)

at org.cmdbuild.servlets.JSONDispatcher.writeResponseData(JSONDispatcher.java:309)

at org.cmdbuild.servlets.JSONDispatcher.writeResponse(JSONDispatcher.java:216)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:109)

at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:73)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)

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)

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[16]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])

at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:218)

at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:183)

at org.codehaus.jackson.map.ser.std.SerializerBase.wrapAndThrow(SerializerBase.java:140)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:158)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.std.StdContainerSerializers$IndexedListSerializer.serializeContents(StdContainerSerializers.java:122)

at org.codehaus.jackson.map.ser.std.StdContainerSerializers$IndexedListSerializer.serializeContents(StdContainerSerializers.java:71)

at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.StdSerializerProvider._serializeValue(StdSerializerProvider.java:610)

at org.codehaus.jackson.map.ser.StdSerializerProvider.serializeValue(StdSerializerProvider.java:256)

at org.codehaus.jackson.map.ObjectMapper._configAndWriteValue(ObjectMapper.java:2575)

at org.codehaus.jackson.map.ObjectMapper.writeValueAsString(ObjectMapper.java:2097)

at org.cmdbuild.servlets.json.management.JsonResponse.toString(JsonResponse.java:59)

... 50 more

Caused by: java.lang.UnsupportedOperationException

at org.cmdbuild.dao.entrytype.attributetype.UndefinedAttributeType.accept(UndefinedAttributeType.java:17)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter$TypeConverter.(JsonDashboardDTO.java:118)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter.(JsonDashboardDTO.java:102)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter.(JsonDashboardDTO.java:95)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource$1.apply(JsonDashboardDTO.java:72)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource$1.apply(JsonDashboardDTO.java:69)

at com.google.common.collect.Iterators$8.transform(Iterators.java:817)

at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)

at com.google.common.collect.Iterators.addAll(Iterators.java:365)

at com.google.common.collect.Lists.newArrayList(Lists.java:162)

at com.google.common.collect.Lists.newArrayList(Lists.java:146)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource.getOutput(JsonDashboardDTO.java:91)

at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.get(BeanPropertyWriter.java:483)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:418)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

... 65 more

 

 

Solved:
The reason was in CMDBuild unsupported data type returned from DB function (BIGINT).
Jiří
 
Previously Jiří wrote:

Hi, 

I have got never any dashboard in the project. I have experimented with view based on SQL / DB function now. After that the error started to occur every time during start and reaload the application or open the (empty) dashboard menu. It is the same in both modules. 

Please help me by any hint hoe to repair this issue. I removed all crated views, restart Tomcat and no effect. 

Thanks in advance,

Jiří

Here is the error:

Call: services/json/dashboard/fulllist

---------------------------------------

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[16]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])

at org.cmdbuild.servlets.json.management.JsonResponse.toString(JsonResponse.java:61)

at org.cmdbuild.servlets.JSONDispatcher.writeResponseData(JSONDispatcher.java:309)

at org.cmdbuild.servlets.JSONDispatcher.writeResponse(JSONDispatcher.java:216)

at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:109)

at org.cmdbuild.servlets.JSONDispatcher.doGet(JSONDispatcher.java:73)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

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:240)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)

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)

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[16]->org.cmdbuild.servlets.json.serializers.JsonDataSource["output"])

at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:218)

at org.codehaus.jackson.map.JsonMappingException.wrapWithPath(JsonMappingException.java:183)

at org.codehaus.jackson.map.ser.std.SerializerBase.wrapAndThrow(SerializerBase.java:140)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:158)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.std.StdContainerSerializers$IndexedListSerializer.serializeContents(StdContainerSerializers.java:122)

at org.codehaus.jackson.map.ser.std.StdContainerSerializers$IndexedListSerializer.serializeContents(StdContainerSerializers.java:71)

at org.codehaus.jackson.map.ser.std.AsArraySerializerBase.serialize(AsArraySerializerBase.java:86)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:446)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

at org.codehaus.jackson.map.ser.BeanSerializer.serialize(BeanSerializer.java:112)

at org.codehaus.jackson.map.ser.StdSerializerProvider._serializeValue(StdSerializerProvider.java:610)

at org.codehaus.jackson.map.ser.StdSerializerProvider.serializeValue(StdSerializerProvider.java:256)

at org.codehaus.jackson.map.ObjectMapper._configAndWriteValue(ObjectMapper.java:2575)

at org.codehaus.jackson.map.ObjectMapper.writeValueAsString(ObjectMapper.java:2097)

at org.cmdbuild.servlets.json.management.JsonResponse.toString(JsonResponse.java:59)

... 50 more

Caused by: java.lang.UnsupportedOperationException

at org.cmdbuild.dao.entrytype.attributetype.UndefinedAttributeType.accept(UndefinedAttributeType.java:17)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter$TypeConverter.(JsonDashboardDTO.java:118)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter.(JsonDashboardDTO.java:102)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSourceParameter.(JsonDashboardDTO.java:95)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource$1.apply(JsonDashboardDTO.java:72)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource$1.apply(JsonDashboardDTO.java:69)

at com.google.common.collect.Iterators$8.transform(Iterators.java:817)

at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)

at com.google.common.collect.Iterators.addAll(Iterators.java:365)

at com.google.common.collect.Lists.newArrayList(Lists.java:162)

at com.google.common.collect.Lists.newArrayList(Lists.java:146)

at org.cmdbuild.servlets.json.serializers.JsonDashboardDTO$JsonDataSource.getOutput(JsonDashboardDTO.java:91)

at sun.reflect.GeneratedMethodAccessor158.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.get(BeanPropertyWriter.java:483)

at org.codehaus.jackson.map.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:418)

at org.codehaus.jackson.map.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:150)

... 65 more