CMDBuild Forum

Cmdbuild 2.3.3

Hello everyone,

 

I have some problems with cmdbuild 2.3.3 and I can't find a solution.

 

Everytime I am trying to send an email  (with task manager, or directly from a card ,...) I have the same error on my cmdbuild.log

 

WARN  2015-08-24 16:19:00 [scheduler] error executing command

java.util.NoSuchElementException

at java.util.AbstractList$Itr.next(Unknown Source)

at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)

at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)

at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)

at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)

at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)

at org.cmdbuild.logic.email.DefaultEmailTemplateSenderFactory$QueuedEmailTemplateSender.execute(DefaultEmailTemplateSenderFactory.java:248)

at org.cmdbuild.logic.taskmanager.commons.SchedulerCommandWrapper.execute(SchedulerCommandWrapper.java:20)

at org.cmdbuild.scheduler.command.Commands$ConditionalCommand.execute(Commands.java:99)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.sendEmail(AsynchronousEventTaskJobFactory.java:225)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.access$600(AsynchronousEventTaskJobFactory.java:52)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory$2.execute(AsynchronousEventTaskJobFactory.java:118)

at org.cmdbuild.scheduler.command.Commands$SafeCommand.execute(Commands.java:40)

at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute(BuildableCommandBasedJob.java:62)

at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)

at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)

at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)

at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)

at org.cmdbuild.scheduler.quartz.QuartzJob.execute(QuartzJob.java:19)

at org.quartz.core.JobRunShell.run(JobRunShell.java:207)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)

INFO  2015-08-24 16:19:00 [cmdbuild] stopping job '399885'

I tried to change my SMTP configuration but I still have the problem with the same error.

 

Here is my smtp configuration

 

Email Menu - Accounts :

 

Name : default

Username : empty (I never used it before and it works, if i have a good memory i used the email version in 2.2.2)

Password : empty (I never used it before and it works, if i have a good memory i used the email version in 2.2.2)

 

Outgoing

Adresse : My email address (like before)

SMTP Server : My SMTP server

SMTP port : My SMTP port

Enable ssl : 0

Send folder : Empty

 

Incoming : 

Everything empty


Email - Templates 

Name : Test

Description : Test

Keep Sync : 1

Prompt sync : 0

Delay : None

 

Template : 

Default account : default

From : my address

to : an other address

Cc : empty

Bcc  Empty

Subject : Here is my test

Body : I am trying to send an email

 

Then i save.

 

Do you have an issue ?

Thank you.

Previously Quentinv wrote:

Hello everyone,

 

I have some problems with cmdbuild 2.3.3 and I can't find a solution.

 

Everytime I am trying to send an email  (with task manager, or directly from a card ,...) I have the same error on my cmdbuild.log

 

WARN  2015-08-24 16:19:00 [scheduler] error executing command

java.util.NoSuchElementException

at java.util.AbstractList$Itr.next(Unknown Source)

at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)

at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)

at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)

at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)

at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)

at org.cmdbuild.logic.email.DefaultEmailTemplateSenderFactory$QueuedEmailTemplateSender.execute(DefaultEmailTemplateSenderFactory.java:248)

at org.cmdbuild.logic.taskmanager.commons.SchedulerCommandWrapper.execute(SchedulerCommandWrapper.java:20)

at org.cmdbuild.scheduler.command.Commands$ConditionalCommand.execute(Commands.java:99)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.sendEmail(AsynchronousEventTaskJobFactory.java:225)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.access$600(AsynchronousEventTaskJobFactory.java:52)

at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory$2.execute(AsynchronousEventTaskJobFactory.java:118)

at org.cmdbuild.scheduler.command.Commands$SafeCommand.execute(Commands.java:40)

at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute(BuildableCommandBasedJob.java:62)

at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)

at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)

at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)

at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)

at org.cmdbuild.scheduler.quartz.QuartzJob.execute(QuartzJob.java:19)

at org.quartz.core.JobRunShell.run(JobRunShell.java:207)

at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)

INFO  2015-08-24 16:19:00 [cmdbuild] stopping job '399885'

I tried to change my SMTP configuration but I still have the problem with the same error.

 

Here is my smtp configuration

 

Email Menu - Accounts :

 

Name : default

Username : empty (I never used it before and it works, if i have a good memory i used the email version in 2.2.2)

Password : empty (I never used it before and it works, if i have a good memory i used the email version in 2.2.2)

 

Outgoing

Adresse : My email address (like before)

SMTP Server : My SMTP server

SMTP port : My SMTP port

Enable ssl : 0

Send folder : Empty

 

Incoming : 

Everything empty


Email - Templates 

Name : Test

Description : Test

Keep Sync : 1

Prompt sync : 0

Delay : None

 

Template : 

Default account : default

From : my address

to : an other address

Cc : empty

Bcc  Empty

Subject : Here is my test

Body : I am trying to send an email

 

Then i save.

 

Do you have an issue ?

Thank you.

Hi,
do you get that same error also when trying to send an e-mail from a card? Do you get it in the moment you click on "save"? 
Could you please try to set the log level for "email" at "DEBUG"? To do so change the line:
log4j.logger.email=INFO
to:
log4j.logger.email=DEBUG
in the file {webapp}/WEB-INF/conf/log4j.conf
To apply the modification you just need to wait 60 seconds, then could you please try to send an e-mail from a card and see if you get more information in the logs about the error? (the errors will appear with the pattern: DEBUG <date> [email] ...)
Another couple of suggestions: the queue is active? did you try to send an e-mail without using any template? 
Let us know.
Regards,
 
The CMDBuild Team
 
 

Hello, 

 
I changed the value for 
 
log4j.logger.email=DEBUG

The only informations I have with debug patern is 
 
DEBUG 2015-08-27 17:20:00 [email   ] getting all outgoing e-mails where delay is elapsed
DEBUG 2015-08-27 17:20:00 [email   ] grouping e-mails by account
 
 
WARN  2015-08-27 17:22:00 [scheduler] error executing command
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(Unknown Source)
at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
at org.cmdbuild.logic.email.DefaultEmailTemplateSenderFactory$QueuedEmailTemplateSender.execute(DefaultEmailTemplateSenderFactory.java:248)
at org.cmdbuild.logic.taskmanager.commons.SchedulerCommandWrapper.execute(SchedulerCommandWrapper.java:20)
at org.cmdbuild.scheduler.command.Commands$ConditionalCommand.execute(Commands.java:99)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.sendEmail(AsynchronousEventTaskJobFactory.java:225)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.access$600(AsynchronousEventTaskJobFactory.java:52)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory$2.execute(AsynchronousEventTaskJobFactory.java:118)
at org.cmdbuild.scheduler.command.Commands$SafeCommand.execute(Commands.java:40)
at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute(BuildableCommandBasedJob.java:62)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.quartz.QuartzJob.execute(QuartzJob.java:19)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
INFO  2015-08-27 17:22:00 [cmdbuild] stopping job '399885'
 
 
 
Yes the queue is activate, I also tried with the queue OFF, same problem.
 
did you try to send an e-mail without using any template?
 
Yes i just tried. I have a java error directly in CMDBUILD : 
 
E-mail update call failure

all: services/json/email/email/update
---------------------------------------
Error: java.util.NoSuchElementException
	at java.util.AbstractList$Itr.next(Unknown Source)
	at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
	at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
	at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
	at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
	at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
	at org.cmdbuild.servlets.json.email.Email.update(Email.java:344)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


So just after I tried with
log4j.logger.email=TRACE
But I don't have more information..

I will try asap a new clean installation of cmdbuild with an empty database, maybe I have a problem here :slight_smile:



Dear QuentinV,
 
we tried to reproduce your issue, but with no success. The only thing we could do is to try with your database, of course, if it not contains sensitive data. Are you able to send it?
 
Best regards.
 
-- CMDBuild Team
 
Previously QuentinV wrote:
Hello, 
 
I changed the value for 
 
log4j.logger.email=DEBUG

The only informations I have with debug patern is 
 
DEBUG 2015-08-27 17:20:00 [email   ] getting all outgoing e-mails where delay is elapsed
DEBUG 2015-08-27 17:20:00 [email   ] grouping e-mails by account
 
 
WARN  2015-08-27 17:22:00 [scheduler] error executing command
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(Unknown Source)
at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
at org.cmdbuild.logic.email.DefaultEmailTemplateSenderFactory$QueuedEmailTemplateSender.execute(DefaultEmailTemplateSenderFactory.java:248)
at org.cmdbuild.logic.taskmanager.commons.SchedulerCommandWrapper.execute(SchedulerCommandWrapper.java:20)
at org.cmdbuild.scheduler.command.Commands$ConditionalCommand.execute(Commands.java:99)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.sendEmail(AsynchronousEventTaskJobFactory.java:225)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.access$600(AsynchronousEventTaskJobFactory.java:52)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory$2.execute(AsynchronousEventTaskJobFactory.java:118)
at org.cmdbuild.scheduler.command.Commands$SafeCommand.execute(Commands.java:40)
at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute(BuildableCommandBasedJob.java:62)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.quartz.QuartzJob.execute(QuartzJob.java:19)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
INFO  2015-08-27 17:22:00 [cmdbuild] stopping job '399885'
 
 
 
Yes the queue is activate, I also tried with the queue OFF, same problem.
 
did you try to send an e-mail without using any template?
 
Yes i just tried. I have a java error directly in CMDBUILD : 
 
E-mail update call failure

all: services/json/email/email/update
---------------------------------------
Error: java.util.NoSuchElementException
	at java.util.AbstractList$Itr.next(Unknown Source)
	at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
	at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
	at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
	at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
	at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
	at org.cmdbuild.servlets.json.email.Email.update(Email.java:344)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


So just after I tried with
log4j.logger.email=TRACE
But I don't have more information..

I will try asap a new clean installation of cmdbuild with an empty database, maybe I have a problem here :slight_smile:



 

Hello
I unfortunately not able to send you my database (sorry :-)). 
 
I will try to fix it by myself, but for the moment the email function is not that much important for me, I just wanted to try out.
 
If I find a solution I will post it here
 
Thank you
 
Previously Tecnoteca wrote:
Dear QuentinV,
 
we tried to reproduce your issue, but with no success. The only thing we could do is to try with your database, of course, if it not contains sensitive data. Are you able to send it?
 
Best regards.
 
-- CMDBuild Team
 
Previously QuentinV wrote:
Hello, 
 
I changed the value for 
 
log4j.logger.email=DEBUG

The only informations I have with debug patern is 
 
DEBUG 2015-08-27 17:20:00 [email   ] getting all outgoing e-mails where delay is elapsed
DEBUG 2015-08-27 17:20:00 [email   ] grouping e-mails by account
 
 
WARN  2015-08-27 17:22:00 [scheduler] error executing command
java.util.NoSuchElementException
at java.util.AbstractList$Itr.next(Unknown Source)
at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
at org.cmdbuild.logic.email.DefaultEmailTemplateSenderFactory$QueuedEmailTemplateSender.execute(DefaultEmailTemplateSenderFactory.java:248)
at org.cmdbuild.logic.taskmanager.commons.SchedulerCommandWrapper.execute(SchedulerCommandWrapper.java:20)
at org.cmdbuild.scheduler.command.Commands$ConditionalCommand.execute(Commands.java:99)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.sendEmail(AsynchronousEventTaskJobFactory.java:225)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory.access$600(AsynchronousEventTaskJobFactory.java:52)
at org.cmdbuild.logic.taskmanager.task.event.asynchronous.AsynchronousEventTaskJobFactory$2.execute(AsynchronousEventTaskJobFactory.java:118)
at org.cmdbuild.scheduler.command.Commands$SafeCommand.execute(Commands.java:40)
at org.cmdbuild.scheduler.command.BuildableCommandBasedJob.execute(BuildableCommandBasedJob.java:62)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.ForwardingJob.execute(ForwardingJob.java:23)
at org.cmdbuild.logic.taskmanager.scheduler.DefaultSchedulerFacade$JobWithCallback.execute(DefaultSchedulerFacade.java:40)
at org.cmdbuild.scheduler.quartz.QuartzJob.execute(QuartzJob.java:19)
at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)
INFO  2015-08-27 17:22:00 [cmdbuild] stopping job '399885'
 
 
 
Yes the queue is activate, I also tried with the queue OFF, same problem.
 
did you try to send an e-mail without using any template?
 
Yes i just tried. I have a java error directly in CMDBUILD : 
 
E-mail update call failure

all: services/json/email/email/update
---------------------------------------
Error: java.util.NoSuchElementException
	at java.util.AbstractList$Itr.next(Unknown Source)
	at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
	at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
	at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
	at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
	at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
	at org.cmdbuild.servlets.json.email.Email.update(Email.java:344)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)


So just after I tried with
log4j.logger.email=TRACE
But I don't have more information..

I will try asap a new clean installation of cmdbuild with an empty database, maybe I have a problem here :slight_smile:



 

 

Hello Everyone,

 
I tried to fix it ( and I think it's almost ok !)
 
From now, the error messages changed for : 
 
Call: services/json/email/email/update
---------------------------------------
Error: java.util.NoSuchElementException
	at java.util.ArrayList$Itr.next(ArrayList.java:834)
	at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
	at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
	at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
	at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
	at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
	at org.cmdbuild.servlets.json.email.Email.update(Email.java:344)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:101)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:61)
	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:158)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	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:259)
	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:259)
	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:259)
	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:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)


Do you have an idea ?

Thank you
What did you do exactly for fix it?
 
-- CMDBuild Team
 
Previously Quentinv wrote:
Hello Everyone,
 
I tried to fix it ( and I think it's almost ok !)
 
From now, the error messages changed for : 
 
Call: services/json/email/email/update
---------------------------------------
Error: java.util.NoSuchElementException
	at java.util.ArrayList$Itr.next(ArrayList.java:834)
	at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
	at org.cmdbuild.data.store.dao.DataViewStore.findCard(DataViewStore.java:259)
	at org.cmdbuild.data.store.dao.DataViewStore.read(DataViewStore.java:178)
	at org.cmdbuild.logic.email.DefaultEmailLogic.read(DefaultEmailLogic.java:317)
	at org.cmdbuild.logic.email.DefaultEmailLogic.update(DefaultEmailLogic.java:323)
	at org.cmdbuild.servlets.json.email.Email.update(Email.java:344)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.cmdbuild.servlets.JSONDispatcher.dispatch(JSONDispatcher.java:101)
	at org.cmdbuild.servlets.JSONDispatcher.doPost(JSONDispatcher.java:61)
	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:158)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
	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:259)
	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:259)
	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:259)
	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:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:957)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)


Do you have an idea ?

Thank you

 

Hello,

 
We finally fix the problem on cmdbuild. (we are using 2.3.4 now).
 
We are using cmdbuild since  the version 1.5.0, and we decided to compare our database with an empty cmdbuild.
 
We saw many differences in the table email, and _EmailAccount. Maybe a problem in the sql patch when we changed our version ? (we had first version 1.5.0, then 2.2.2 then 2.3.3 and the last one, 2.3.4). I send you our SQL query we used to fix it :
 

COMMENT ON TABLE "Email" IS 'MODE: reserved|TYPE: class|DESCR: Email|SUPERCLASS: false|STATUS: active';

ALTER TABLE "Email" ADD COLUMN "NoSubjectPrefix" boolean;
COMMENT ON COLUMN "Email"."NoSubjectPrefix" IS 'MODE: user|FIELDMODE: write|DESCR: No subject prefix|INDEX: 13|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "InputFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."InputFolder" IS 'MODE: write|DESCR: Input folder|INDEX: 11|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "ProcessedFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."ProcessedFolder" IS 'MODE: write|DESCR: Processed folder|INDEX: 12|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "RejectedFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."RejectedFolder" IS 'MODE: write|DESCR: Rejected folder|INDEX: 13|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "RejectNotMatching" boolean;
COMMENT ON COLUMN "_EmailAccount"."RejectNotMatching" IS 'MODE: write|DESCR: Reject not matching|INDEX: 14|STATUS: active';
 
I hope it can help someone :-) 
 
Dear Quentinvarquet,
 
if you are using version 2.3.4, the columns "InputFolder", "ProcessedFolder", "RejectedFolder", "RejectNotMatching" of table "_EmailAccount" are no more available since deleted from patch "2.3.2-1.sql". They must not be added again!
 
The column "NoSubjectPrefix" of table "Email" should be added with patch "2.1.9-03.sql". Please check the "Patch" table if the patch has been applied.
 
Best regards.
 
-- CMDBuild Team
 
Previously Quentinvarquet wrote:
Hello,
 
We finally fix the problem on cmdbuild. (we are using 2.3.4 now).
 
We are using cmdbuild since  the version 1.5.0, and we decided to compare our database with an empty cmdbuild.
 
We saw many differences in the table email, and _EmailAccount. Maybe a problem in the sql patch when we changed our version ? (we had first version 1.5.0, then 2.2.2 then 2.3.3 and the last one, 2.3.4). I send you our SQL query we used to fix it :
 

COMMENT ON TABLE "Email" IS 'MODE: reserved|TYPE: class|DESCR: Email|SUPERCLASS: false|STATUS: active';

ALTER TABLE "Email" ADD COLUMN "NoSubjectPrefix" boolean;
COMMENT ON COLUMN "Email"."NoSubjectPrefix" IS 'MODE: user|FIELDMODE: write|DESCR: No subject prefix|INDEX: 13|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "InputFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."InputFolder" IS 'MODE: write|DESCR: Input folder|INDEX: 11|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "ProcessedFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."ProcessedFolder" IS 'MODE: write|DESCR: Processed folder|INDEX: 12|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "RejectedFolder" character varying(50);
COMMENT ON COLUMN "_EmailAccount"."RejectedFolder" IS 'MODE: write|DESCR: Rejected folder|INDEX: 13|STATUS: active';

ALTER TABLE "_EmailAccount" ADD COLUMN "RejectNotMatching" boolean;
COMMENT ON COLUMN "_EmailAccount"."RejectNotMatching" IS 'MODE: write|DESCR: Reject not matching|INDEX: 14|STATUS: active';
 
I hope it can help someone :-) 
 

 

if you are using version 2.3.4, the columns “InputFolder”, “ProcessedFolder”, “RejectedFolder”, “RejectNotMatching” of table “_EmailAccount” are no more available since deleted from patch “2.3.2-1.sql”. They must not be added again!


I just did a new installation of cmdbuild 2.3.4 on my laptop with an empty database. 
 
I just checked in the database, in the table _EmailAccount and the columns "InputFolder", "ProcessedFolder", "RejectedFolder" are still here.
You are right, it's a mistake on empty databases and we'll fix it. Successfully migrated databases (from version < 2.3.2) does not have them and we are sure that they are no more used.
 
Best regards.
 
-- CMDBuild Team
 
Previously Quentinvarquet wrote:
if you are using version 2.3.4, the columns "InputFolder", "ProcessedFolder", "RejectedFolder", "RejectNotMatching" of table "_EmailAccount" are no more available since deleted from patch "2.3.2-1.sql". They must not be added again!

I just did a new installation of cmdbuild 2.3.4 on my laptop with an empty database. 
 
I just checked in the database, in the table _EmailAccount and the columns "InputFolder", "ProcessedFolder", "RejectedFolder" are still here.