CMDBuild Forum

com.google.common.util.concurrent.UncheckedExecutionException: org.cmdbuild.dao.DaoException: error mapping record id = 597 type = _Report to model = class org.cmdbuild.report.dao.ReportDataImpl

2019-10-21 16:45:20.059 [http-nio-8080-exec-3] ERROR o.c.s.r.v.c.h.ExceptionHandlerService - ws processing error
com.google.common.util.concurrent.UncheckedExecutionException: org.cmdbuild.dao.DaoException: error mapping record id = 597 type = _Report to model = class org.cmdbuild.report.dao.ReportDataImpl
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2050) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4870) ~[closure-compiler-v20180716.jar:na]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [catalina.jar:8.5.43]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [catalina.jar:8.5.43]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:798) [tomcat-coyote.jar:8.5.43]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-coyote.jar:8.5.43]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) [tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_152]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.43]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_152]
Caused by: org.cmdbuild.dao.DaoException: error mapping record id = 597 type = _Report to model = class org.cmdbuild.report.dao.ReportDataImpl
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$PreparedQueryImpl$ResultRowImpl.toModel(QueryBuilderServiceImpl.java:1215) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.core.q3.PreparedQuery.lambda$asList$2(PreparedQuery.java:92) ~[cmdbuild-dao-core-3.0-SNAPSHOT.jar:na]
at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) ~[na:1.8.0_152]
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) ~[na:1.8.0_152]
at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) ~[na:1.8.0_152]
Caused by: java.lang.NullPointerException: rich reports array cannot be null
at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:895) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl.(ReportDataImpl.java:44) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl.(ReportDataImpl.java:22) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl$ReportDataImplBuilder.build(ReportDataImpl.java:216) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl$ReportDataImplBuilder.build(ReportDataImpl.java:149) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$PreparedQueryImpl$ResultRowImpl.toModel(QueryBuilderServiceImpl.java:1213) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
… 124 common frames omitted
2019-10-21 16:45:20.093 [http-nio-8080-exec-10] ERROR o.c.s.r.v.c.h.ExceptionHandlerService - ws processing error
com.google.common.util.concurrent.UncheckedExecutionException: com.google.common.util.concurrent.UncheckedExecutionException: java.lang.NullPointerException: classe not found for name = _BimLayer
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2050) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4870) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:73) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:64) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) [tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) [tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_152]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.43]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_152]
Caused by: com.google.common.util.concurrent.UncheckedExecutionException: java.lang.NullPointerException: classe not found for name = _BimLayer
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2050) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4870) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:73) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:64) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.cache.CacheService$1.get(CacheService.java:40) ~[cmdbuild-core-commons-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.bim.BimLayerRepositoryImpl.getAll(BimLayerRepositoryImpl.java:36) ~[cmdbuild-bim-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.bim.BimLayerRepositoryImpl.doGetByOwnerOrNull(BimLayerRepositoryImpl.java:51) ~[cmdbuild-bim-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.bim.BimLayerRepositoryImpl.lambda$getByOwnerOrNull$0(BimLayerRepositoryImpl.java:46) ~[cmdbuild-bim-core-3.0-SNAPSHOT.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4875) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2276) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044) ~[closure-compiler-v20180716.jar:na]
… 119 common frames omitted
Caused by: java.lang.NullPointerException: classe not found for name = _BimLayer
at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:980) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.dao.driver.repository.ClasseWithoutHierarchyReadonlyRepository.getClasse(ClasseWithoutHierarchyReadonlyRepository.java:28) ~[cmdbuild-dao-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$QueryBuilderImpl.from(QueryBuilderServiceImpl.java:179) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$QueryBuilderImpl.from(QueryBuilderServiceImpl.java:174) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.bim.BimLayerRepositoryImpl.doGetAll(BimLayerRepositoryImpl.java:40) ~[cmdbuild-bim-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.cache.CacheService$1.lambda$get$0(CacheService.java:40) ~[cmdbuild-core-commons-3.0-SNAPSHOT.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4875) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2276) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044) ~[closure-compiler-v20180716.jar:na]
… 132 common frames omitted
2019-10-21 16:45:20.128 [http-nio-8080-exec-2] WARN org.cmdbuild.menu.MenuServiceImpl - TODO: dashboard currently disabled, skipping menu record = MenuTreeNodeImpl{, type=DASHBOARD, description=Item situation, objectType=831, code=dfbc9d35-5e44-ccc3-e072-ede2adfbd111}
2019-10-21 16:45:20.154 [http-nio-8080-exec-2] WARN org.cmdbuild.menu.MenuServiceImpl - TODO: dashboard currently disabled, skipping menu record = MenuTreeNodeImpl{, type=DASHBOARD, description=RfC situation, objectType=946, code=6f2f1bb1-8227-c405-7281-1a54e500bdab}
2019-10-21 16:45:20.179 [http-nio-8080-exec-2] ERROR org.cmdbuild.menu.MenuServiceImpl - error processing menu record = MenuTreeNodeImpl{, type=REPORT_PDF, description=Location list with assets, objectType=Location list with assets, code=b19e215b-44f2-8f7c-2a47-abea8c570e03}
com.google.common.util.concurrent.UncheckedExecutionException: org.cmdbuild.dao.DaoException: error mapping record id = 597 type = _Report to model = class org.cmdbuild.report.dao.ReportDataImpl
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2050) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache.get(LocalCache.java:3951) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4870) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:73) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.cache.LocalCacheServiceImpl$1.get(LocalCacheServiceImpl.java:64) ~[cmdbuild-core-all-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportRepositoryImpl.getByCodeOrNull(ReportRepositoryImpl.java:49) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportRepository.getReportByCode(ReportRepository.java:29) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) ~[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105) ~[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331) ~[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56) ~[spring-security-web-4.2.3.RELEASE.jar:4.2.3.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-4.3.4.RELEASE.jar:4.3.4.RELEASE]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-coyote.jar:8.5.43]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:808) ~[tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498) ~[tomcat-coyote.jar:8.5.43]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:8.5.43]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_152]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_152]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:8.5.43]
at java.lang.Thread.run(Thread.java:748) ~[na:1.8.0_152]
Caused by: org.cmdbuild.dao.DaoException: error mapping record id = 597 type = _Report to model = class org.cmdbuild.report.dao.ReportDataImpl
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$PreparedQueryImpl$ResultRowImpl.toModel(QueryBuilderServiceImpl.java:1215) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.core.q3.PreparedQuery.getOneOrNull(PreparedQuery.java:39) ~[cmdbuild-dao-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportRepositoryImpl.lambda$getByCodeOrNull$1(ReportRepositoryImpl.java:49) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4875) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2276) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2154) ~[closure-compiler-v20180716.jar:na]
at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2044) ~[closure-compiler-v20180716.jar:na]
… 125 common frames omitted
Caused by: java.lang.NullPointerException: rich reports array cannot be null
at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:895) ~[closure-compiler-v20180716.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl.(ReportDataImpl.java:44) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl.(ReportDataImpl.java:22) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl$ReportDataImplBuilder.build(ReportDataImpl.java:216) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.report.dao.ReportDataImpl$ReportDataImplBuilder.build(ReportDataImpl.java:149) ~[cmdbuild-report-core-3.0-SNAPSHOT.jar:na]
at org.cmdbuild.dao.driver.postgres.q3.QueryBuilderServiceImpl$PreparedQueryImpl$ResultRowImpl.toModel(QueryBuilderServiceImpl.java:1213) ~[cmdbuild-dao-postgresql-3.0-SNAPSHOT.jar:na]
… 132 common frames omitted

Did you have any luck resolving this?

try to configure the database manually. there is error in your cmdbuild connection with postgresql.
refer to the Cmdbuild Technical Manual