CMDBuild Forum

Re: Error in Export CSV file

Hi I'm working on CMDBuild 2.4.3, and when I try to export a class with "Export CSV" tool, this error ha been raised:

 

ERROR 2018-05-18 09:00:09 [jsonrpc ] A java.lang.IllegalArgumentException occurred calling method class org.cmdbuild.servlets.json.management.ExportCSV.export: Cannot use an empty clause along with other where clauses

java.lang.IllegalArgumentException: Cannot use an empty clause along with other where clauses

at org.cmdbuild.dao.driver.postgres.query.WherePartCreator.visit(WherePartCreator.java:346)

at org.cmdbuild.dao.query.clause.where.EmptyWhereClause.accept(EmptyWhereClause.java:21)

at org.cmdbuild.dao.driver.postgres.query.WherePartCreator.visit(WherePartCreator.java:172)

at org.cmdbuild.dao.query.clause.where.AndWhereClause.accept(AndWhereClause.java:20)

at org.cmdbuild.dao.driver.postgres.query.WherePartCreator.<init>(WherePartCreator.java:97)

at org.cmdbuild.dao.driver.postgres.query.WherePartCreator.<init>(WherePartCreator.java:85)

at org.cmdbuild.dao.driver.postgres.query.QueryCreator.appendWhere(QueryCreator.java:63)

at org.cmdbuild.dao.driver.postgres.query.QueryCreator.buildQuery(QueryCreator.java:40)

at org.cmdbuild.dao.driver.postgres.query.QueryCreator.<init>(QueryCreator.java:28)

at org.cmdbuild.dao.driver.postgres.EntryQueryCommand.run(EntryQueryCommand.java:65)

at org.cmdbuild.dao.driver.postgres.PostgresDriver.query(PostgresDriver.java:194)

at org.cmdbuild.dao.view.DBDataView.executeQuery(DBDataView.java:416)

at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:161)

at org.cmdbuild.services.localization.LocalizedDataView.executeQuery(LocalizedDataView.java:208)

at org.cmdbuild.dao.view.ForwardingDataView.executeQuery(ForwardingDataView.java:161)

at org.cmdbuild.dao.view.user.UserDataView.executeQuery(UserDataView.java:182)

at org.cmdbuild.dao.view.user.UserQuerySpecsBuilder.run(UserQuerySpecsBuilder.java:159)

at org.cmdbuild.servlets.json.management.export.DBDataSource.getEntries(DBDataSource.java:60)

at org.cmdbuild.servlets.json.management.export.csv.CsvExporter.writeCsvDataToFile(CsvExporter.java:43)

at org.cmdbuild.servlets.json.management.export.csv.CsvExporter.export(CsvExporter.java:33)

at org.cmdbuild.logic.data.access.DefaultDataAccessLogic.exportClassAsCsvFile(DefaultDataAccessLogic.java:1292)

at org.cmdbuild.logic.data.access.ForwardingDataAccessLogic.exportClassAsCsvFile(ForwardingDataAccessLogic.java:296)

at org.cmdbuild.servlets.json.management.ExportCSV.export(ExportCSV.java:40)

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

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

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

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

at org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:877)

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

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

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

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)

 

Could you give me some suggestion?

 

Please 

have you give idea to fix this problem?

We often use "export csv" function, and this bug is for us a big problem.

please answer to this message!!!

 

thanks

We suggest you use the latest version, we released CMDBuild 2.5.1 yesterday.
CMDBuild Team