Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-45017

Error in sending mails without subject

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 20.3, 21.0, 22.0 [Tentative]
    • Fix Version/s: 22.0 [Tentative]
    • Component/s: Messages Tool
    • Labels:
      None
    • 21 Status:
      Please Merge
    • 20 status:
      Please Merge
    • Test Plan:
      Hide
      1. Send a message to a user marking the autoforward check from the messages tool of Sakai.
      2. The user who has received the email must reply from its mail manager and remove the mail subject.

      When this email is sent, the above error will appear.

      Show
      Send a message to a user marking the autoforward check from the messages tool of Sakai. The user who has received the email must reply from its mail manager and remove the mail subject. When this email is sent, the above error will appear.

      Description

      If we have activated the function to answer mails outside sakai, when a mail is replied outside Sakai and it does not have any subject, the following error is produced:

      [org.subethamail.smtp.server.Session-/155.54.216.50:11750] org.subethamail.smtp.server.Session.run Unexpected error in the SMTP handler thread
      org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
      	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:163)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      	at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
      	at org.sakaiproject.component.app.messageforums.ui.PrivateMessageManagerImpl.getPrivateMessageWithRecipients(PrivateMessageManagerImpl.java:1706)
      	at org.sakaiproject.component.app.messageforums.ui.PrivateMessageManagerImpl.markMessageAsRepliedForUser(PrivateMessageManagerImpl.java:1674)
      	at org.sakaiproject.component.app.messageforums.ui.PrivateMessageManagerImpl.processPvtMsgReplySentAction(PrivateMessageManagerImpl.java:2274)
      	at sun.reflect.GeneratedMethodAccessor5682.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
      	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:283)
      	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
      	at com.sun.proxy.$Proxy285.processPvtMsgReplySentAction(Unknown Source)
      	at org.sakaiproject.component.app.messageforums.SynopticMsgcntrManagerImpl.sendPrivateMessageDesktop(SynopticMsgcntrManagerImpl.java:1305)
      	at sun.reflect.GeneratedMethodAccessor5680.invoke(Unknown Source)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      	at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
      	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:283)
      	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
      	at com.sun.proxy.$Proxy296.sendPrivateMessageDesktop(Unknown Source)
      	at org.sakaiproject.mailarchive.SakaiMessageHandlerFactory$1.data(SakaiMessageHandlerFactory.java:249)
      	at org.subethamail.smtp.command.DataCommand.execute(DataCommand.java:64)
      	at org.subethamail.smtp.server.RequireTLSCommandWrapper.execute(RequireTLSCommandWrapper.java:30)
      	at org.subethamail.smtp.server.CommandHandler.handleCommand(CommandHandler.java:99)
      	at org.subethamail.smtp.server.Session.runCommandLoop(Session.java:244)
      	at org.subethamail.smtp.server.Session.run(Session.java:145)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
      	at java.lang.Thread.run(Thread.java:748)
      Caused by: org.hibernate.exception.ConstraintViolationException: could not execute statement
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:72)
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:211)
      	at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:62)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3124)
      	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
      	at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:465)
      	at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:351)
      	at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
      	at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:67)
      	at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1227)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1293)
      	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
      	at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
      	at org.sakaiproject.component.app.messageforums.ui.PrivateMessageManagerImpl.lambda$getPrivateMessageWithRecipients$5(PrivateMessageManagerImpl.java:1703)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
      	... 38 more
      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: no se puede realizar una inserciĆ³n NULL en ("SAKAI_PR"."MFR_MESSAGE_T"."TITLE")
      

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  victor.gomollon Victor Gomollon Martos
                  Reporter:
                  victor.gomollon Victor Gomollon Martos
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration