Hibernate Exception while sending mail from an asynchronous Event Listener in Grails 2.5.2 about grails-asynchronous-mail

[kefirfromperm]

Hello,

You are trying to use the plugin in environment where a hibernate session is absent. Just use withNew Session. http://docs.grails.org/2.5.x/ref/Domain%20Classes/withNewSession.html

AsynchronousMailMessage.withNewSession {
    asynchronousMailService.sendMail {
          multipart true
          to inParam?.user
          subject "Report ${obj?.reportFileName}.pdf"
          body "Your report is generated and attached with this mail."
          attachBytes "${obj?.reportFileName}.pdf", "application/pdf", obj?.generatedBytes
    }
}

If it will be OK, please close this issue.

[abhaygoel]

Thanks a lot Vitali. Appreciate your help.

I’ll close the issue.

Regards,

Abhay

From: Vitalii Samolovskikh [email protected]
Reply-To: kefirfromperm/grails-asynchronous-mail [email protected]
Date: Friday, May 20, 2016 at 6:10 PM
To: kefirfromperm/grails-asynchronous-mail [email protected]
Cc: Abhay Goel [email protected], Author [email protected]
Subject: Re: [kefirfromperm/grails-asynchronous-mail] Hibernate Exception while sending mail from an asynchronous Event Listener in Grails 2.5.2 (#59)

Hello,

You are trying to use the plugin in environment where a hibernate session is absent. Just use withNew Session. http://docs.grails.org/2.5.x/ref/Domain%20Classes/withNewSession.html

AsynchronousMailMessage.withNewSession {
    asynchronousMailService.sendMail {
          multipart true
          to inParam?.user
          subject "Report ${obj?.reportFileName}.pdf"
          body "Your report is generated and attached with this mail."
          attachBytes "${obj?.reportFileName}.pdf", "application/pdf", obj?.generatedBytes
    }
}
If it will be OK, please close this issue.

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub

[abhaygoel]

Hi Vitalii,

Unfortunately, I’m getting another error this time.

Here’s the updated code:

AsynchronousMailMessage.withNewSession {
    asynchronousMailService.sendMail {
        multipart true
        to user
        subject "Report ${reportFileName}.pdf"
        body "Your report is generated and attached with this mail."

        attach("${reportFileName}.pdf", "application/pdf", generatedBytes)
    }
}

Stacktrace:

grails.validation.ValidationException: Validation Error(s) occurred during save():

• Field error in object 'grails.plugin.asyncmail.AsynchronousMailMessage' on field 'attachments[0].attachmentName': rejected value [null]; codes [grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.attachments[0].attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.attachments.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error.java.lang.String,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.error,asynchronousMailAttachment.attachmentName.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].attachmentName,asynchronousMailAttachment.attachmentName.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.attachmentName,asynchronousMailAttachment.attachmentName.nullable.error.attachments[0].attachmentName,asynchronousMailAttachment.attachmentName.nullable.error.attachments.attachmentName,asynchronousMailAttachment.attachmentName.nullable.error.attachmentName,asynchronousMailAttachment.attachmentName.nullable.error.java.lang.String,asynchronousMailAttachment.attachmentName.nullable.error,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.attachments[0].attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.attachments.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.attachmentName,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable.java.lang.String,grails.plugin.asyncmail.AsynchronousMailAttachment.attachmentName.nullable,asynchronousMailAttachment.attachmentName.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].attachmentName,asynchronousMailAttachment.attachmentName.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.attachmentName,asynchronousMailAttachment.attachmentName.nullable.attachments[0].attachmentName,asynchronousMailAttachment.attachmentName.nullable.attachments.attachmentName,asynchronousMailAttachment.attachmentName.nullable.attachmentName,asynchronousMailAttachment.attachmentName.nullable.java.lang.String,asynchronousMailAttachment.attachmentName.nullable,nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].attachmentName,nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.attachmentName,nullable.attachments[0].attachmentName,nullable.attachments.attachmentName,nullable.attachmentName,nullable.java.lang.String,nullable]; arguments [attachmentName,class grails.plugin.asyncmail.AsynchronousMailAttachment]; default message [Property [{0}] cannot be null]
• Field error in object 'grails.plugin.asyncmail.AsynchronousMailMessage' on field 'attachments[0].content': rejected value [null]; codes [grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.attachments[0].content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.attachments.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error.[B,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.error,asynchronousMailAttachment.content.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].content,asynchronousMailAttachment.content.nullable.error.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.content,asynchronousMailAttachment.content.nullable.error.attachments[0].content,asynchronousMailAttachment.content.nullable.error.attachments.content,asynchronousMailAttachment.content.nullable.error.content,asynchronousMailAttachment.content.nullable.error.[B,asynchronousMailAttachment.content.nullable.error,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.attachments[0].content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.attachments.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.content,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable.[B,grails.plugin.asyncmail.AsynchronousMailAttachment.content.nullable,asynchronousMailAttachment.content.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].content,asynchronousMailAttachment.content.nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.content,asynchronousMailAttachment.content.nullable.attachments[0].content,asynchronousMailAttachment.content.nullable.attachments.content,asynchronousMailAttachment.content.nullable.content,asynchronousMailAttachment.content.nullable.[B,asynchronousMailAttachment.content.nullable,nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments[0].content,nullable.grails.plugin.asyncmail.AsynchronousMailMessage.attachments.content,nullable.attachments[0].content,nullable.attachments.content,nullable.content,nullable.[B,nullable]; arguments [content,class grails.plugin.asyncmail.AsynchronousMailAttachment]; default message [Property [{0}] cannot be null]

                at grails.plugin.asyncmail.AsynchronousMailPersistenceService.save(AsynchronousMailPersistenceService.groovy:8)

                at GrailsMelodyGrailsPlugin$_closure4$_closure16$_closure17.doCall(GrailsMelodyGrailsPlugin.groovy:184)

                at grails.plugin.asyncmail.AsynchronousMailService$_sendAsynchronousMail_closure1.doCall(AsynchronousMailService.groovy:42)

                at grails.plugin.asyncmail.AsynchronousMailService.sendAsynchronousMail(AsynchronousMailService.groovy:41)

                at GrailsMelodyGrailsPlugin$_closure4$_closure16$_closure17.doCall(GrailsMelodyGrailsPlugin.groovy:184)

                at AsynchronousMailGrailsPlugin$_configureSendMail_closure8.doCall(AsynchronousMailGrailsPlugin.groovy:128)

                at GrailsMelodyGrailsPlugin$_closure4$_closure16$_closure17.doCall(GrailsMelodyGrailsPlugin.groovy:184)

                at MailGrailsPlugin$_configureSendMail_closure7.doCall(MailGrailsPlugin.groovy:175)

                at GrailsMelodyGrailsPlugin$_closure4$_closure16$_closure17.doCall(GrailsMelodyGrailsPlugin.groovy:184)

                at com.bq.export.BqExportService$__tt__generateReportAsByteArray_closure7.doCall(BqExportService.groovy:252)

                at com.bq.export.BqExportService.$tt__generateReportAsByteArray(BqExportService.groovy:251)

                at GrailsMelodyGrailsPlugin$_closure4$_closure16$_closure17.doCall(GrailsMelodyGrailsPlugin.groovy:184)

                at com.bq.export.BqExportController$_generateReportAndMail_closure1.doCall(BqExportController.groovy:41)

                at groovyx.gpars.group.PGroup$3.call(PGroup.java:289)

                at groovyx.gpars.group.PGroup$4.run(PGroup.java:313)

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

                at java.lang.Thread.run(Thread.java:745)

2016-05-20 18:56:21,706 +0530 [Actor Thread 1] TRACE AsynchronousMailService:104  - Start send job immediately.

2016-05-20 18:56:21,718 +0530 [quartzScheduler_Worker-4] TRACE AsynchronousMailJob:104  - Entering execute method.

2016-05-20 18:56:21,728 +0530 [quartzScheduler_Worker-4] TRACE AsynchronousMailJob:104  - Exiting execute method. Execution time = 10ms

From: Vitalii Samolovskikh [email protected]
Reply-To: kefirfromperm/grails-asynchronous-mail [email protected]
Date: Friday, May 20, 2016 at 6:10 PM
To: kefirfromperm/grails-asynchronous-mail [email protected]
Cc: Abhay Goel [email protected], Author [email protected]
Subject: Re: [kefirfromperm/grails-asynchronous-mail] Hibernate Exception while sending mail from an asynchronous Event Listener in Grails 2.5.2 (#59)

Hello,

You are trying to use the plugin in environment where a hibernate session is absent. Just use withNew Session. http://docs.grails.org/2.5.x/ref/Domain%20Classes/withNewSession.html

AsynchronousMailMessage.withNewSession {
    asynchronousMailService.sendMail {
          multipart true
          to inParam?.user
          subject "Report ${obj?.reportFileName}.pdf"
          body "Your report is generated and attached with this mail."
          attachBytes "${obj?.reportFileName}.pdf", "application/pdf", obj?.generatedBytes
    }
}
If it will be OK, please close this issue.

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub

[kefirfromperm]

Try to set
grailsApplication.config.asynchronous.mail.newSessionOnImmediateSend = false

[abhaygoel]

Hi Vitalli,

No luck Still the same problem.

Regards,

Abhay

From: Vitalii Samolovskikh [email protected]
Reply-To: kefirfromperm/grails-asynchronous-mail [email protected]
Date: Friday, May 20, 2016 at 10:52 PM
To: kefirfromperm/grails-asynchronous-mail [email protected]
Cc: Abhay Goel [email protected], Author [email protected]
Subject: Re: [kefirfromperm/grails-asynchronous-mail] Hibernate Exception while sending mail from an asynchronous Event Listener in Grails 2.5.2 (#59)

Try to set
grailsApplication.config.asynchronous.mail.newSessionOnImmediateSend = false

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub

[kefirfromperm]

Please print all parameters "${reportFileName}.pdf", "application/pdf", generatedBytes before call attach. All of them is not null and not blank?

[abhaygoel]

Yup. Already did that. I have printed them inside the sendMail closure and all are not null. I have tried with standard mail plugin (non-asynchronous) and it works fine.

From: Vitalii Samolovskikh [email protected]
Reply-To: kefirfromperm/grails-asynchronous-mail [email protected]
Date: Saturday, May 21, 2016 at 12:36 PM
To: kefirfromperm/grails-asynchronous-mail [email protected]
Cc: Abhay Goel [email protected], Author [email protected]
Subject: Re: [kefirfromperm/grails-asynchronous-mail] Hibernate Exception while sending mail from an asynchronous Event Listener in Grails 2.5.2 (#59)

Please print all parameters "${reportFileName}.pdf", "application/pdf", generatedBytes before call attach. All of them is not null and not blank?

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub

[kefirfromperm]

Which database do you use?
Please attach latest log.

[puneetbehl]

@abhaygoel Maybe you could create a sample application describing the problem scenario and share the github link here so that we can try to solve it.

[kefirfromperm]

Can't reproduce.