Send user last comment of subtask via email notification when subtask is marked done

[Jerrod Van]

I have 7 subtasks 

1 of the subtasks i would like to send a user info to a user after its closed. How can i set this up? Adding the user as a reporter or participant on the subtask doesnt seem to work. 

I also setup an autmation to email the user when the subtask is closed but it only emails what is in the automation not the last comment in the subtask . 

[Andy Heinzer]

From looking at your error, it appears you might be having the same problem as in https://community.atlassian.com/t5/Jira-Core-questions/Exception-Errors-in-JIRA-7-3-7-after-upgrade-with-Create-Issue/qaq-p/606843

In which case, if you're using a MS SQL 2008 database with a version of Jira such as 7.2.x or higher, that database version is actually not compatible with these newer versions of Jira.  Switching databases has steps you can follow to get past this problem.   But before you do that, you will likely need to select a supported platform database that corresponds to your Jira version.

If this doesn't help, could you let me know what version of Jira you have, and what database type/version your jira site is using?

[Mihai Mihai]

Hello @Andy Heinzer

Thank you for your reply.

We are using JIRA 7.5.2 server, and the database is ORACLE : Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

This problem appeared recently for us, and we migrated from 7.1.9 to 7.5.2 a long time ago.

Please let me know if you have any other ideas.

Thank you.

[Andy Heinzer]

I found that you created a support case for this issue over in https://getsupport.atlassian.com/servicedesk/customer/portal/20/GHS-133743

I believe that Adrian is on the right path in this case.  I found a few other cases with a similar error and while some of them were in regards to unsupported platforms (databases), there are other cases where Jira can exceed its memory allocations in such a way that it can cause unexpected behavior. 

Hence the GC logging parameters Adrian is asking to enable there will be the most helpful for us to understand whats happening in regards to Jira trying to collect used memory objects when this problem happens.