Hi everyone,
I encountered an issue related to emails for the old PM (it was in OpenMaintenance 2.3 sample data). I couldn’t delete it because it didn’t exist in Preventive Maintenance. Temporarily, I set the time to December 28, 2021 (as the logs show) and the error disappeared, but after a few days, it reappeared and the cmdbuild couldn’t send other emails automatically.
If you know how to fix it, please show me how.
Thank you.
Blockquote
2026-01-30T13:10:00.171+07:00 [jobrun:1807699] INFO o.c.e.queue.EmailQueueServiceImpl - processing 146 outgoing email
2026-01-30T13:10:04.064+07:00 [jobrun:1807699] ERROR o.c.e.queue.EmailQueueServiceImpl - error sending email = Email{id=384836, reference=384268, subject=<[PM.2021.0001] Preventive maintenance…>, status=outgoing}
org.cmdbuild.dao.DaoException: error executing update for entry = CardImpl{id=384836, type=Email}
at org.cmdbuild.dao.postgres.services.EntryUpdateServiceImpl$EntryUpdateExecutor.lambda$executeUpdate$3(EntryUpdateServiceImpl.java:179) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:406) ~[guava-23.0.jar:na]
at org.cmdbuild.dao.postgres.services.EntryUpdateServiceImpl$EntryUpdateExecutor.executeUpdate(EntryUpdateServiceImpl.java:166) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.dao.postgres.services.EntryUpdateServiceImpl.executeUpdate(EntryUpdateServiceImpl.java:85) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.dao.postgres.services.PostgresServiceImpl.update(PostgresServiceImpl.java:249) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.dao.postgres.q3.DaoServiceImpl.update(DaoServiceImpl.java:226) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.dao.postgres.q3.DaoServiceImpl.update(DaoServiceImpl.java:178) ~[cmdbuild-dao-postgresql-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.data.EmailRepositoryImpl.update(EmailRepositoryImpl.java:73) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.inner.EmailServiceImpl.update(EmailServiceImpl.java:147) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.queue.EmailQueueServiceImpl.doSendEmail(EmailQueueServiceImpl.java:214) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.queue.EmailQueueServiceImpl.doSendEmailAndHandleErrors(EmailQueueServiceImpl.java:188) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at java.base/java.util.ArrayList.forEach(ArrayList.java:1511) ~[na:na]
at org.cmdbuild.email.queue.EmailQueueServiceImpl.doProcessEmailQueue(EmailQueueServiceImpl.java:167) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.queue.EmailQueueServiceImpl.doProcessEmailQueue(EmailQueueServiceImpl.java:142) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.email.queue.EmailQueueServiceImpl.processEmailQueue(EmailQueueServiceImpl.java:119) ~[cmdbuild-core-email-3.4.1-d.jar:3.4.1-d]
at jdk.internal.reflect.GeneratedMethodAccessor473.invoke(Unknown Source) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:569) ~[na:na]
at org.cmdbuild.jobs.runners.annotatedmethods.AnnotatedMethodJobSource.runJob(AnnotatedMethodJobSource.java:106) ~[cmdbuild-jobs-runners-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.jobs.JobRunner.runJobWithOutput(JobRunner.java:24) ~[cmdbuild-jobs-api-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.jobs.JobRunner.runJobWithOutput(JobRunner.java:16) ~[cmdbuild-jobs-api-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.jobs.inner.JobRunServiceImpl$JobRunner.doExecuteJob(JobRunServiceImpl.java:306) ~[cmdbuild-jobs-core-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.jobs.inner.JobRunServiceImpl$JobRunner.executeJob(JobRunServiceImpl.java:296) ~[cmdbuild-jobs-core-3.4.1-d.jar:3.4.1-d]
at org.cmdbuild.jobs.inner.JobRunServiceImpl$JobRunner.setContextAndExecuteJob(JobRunServiceImpl.java:285) ~[cmdbuild-jobs-core-3.4.1-d.jar:3.4.1-d]
at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:539) ~[na:na]
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[na:na]
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[na:na]
at java.base/java.lang.Thread.run(Thread.java:840) ~[na:na]
Caused by: org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [UPDATE “Email” SET “Subject” = ‘[PM.2021.0001] Preventive maintenance - Office Building 02 - Opening’, “Delay” = NULL, “Card” = 384268, “Signature” = NULL, “Content” = 'A new preventive maintenance with number PM.2021.0001 has been submitted.
**The request is scheduled for 28 Dic 2021 09:00 and must be completed within 28 Dic 2021 18:00.
**