git.net

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Mifos-developer] Wrong MySQL(The RuntimeException could not be mapped to a response, re-throwing to the HTTP container)


This is also addressed in the MySQL-5.7 changes that I made. I would
suggest looking at this branch if you run into further issues with SQL:
https://github.com/conradsp/fineract/tree/mysql-5.7

The fix for this particular issue is: ALTER TABLE `scheduled_email_campaign`
ADD `previous_run_status` VARCHAR(10) NULL;


On Mon, Jun 11, 2018 at 11:13 AM Emmanuel Njoku <einjoku@xxxxxxxxx> wrote:

> Unable to find Unknown column 't9.previous_run_status.
>
> 104659 [Scheduler1_Worker-1] ERROR org.quartz.core.JobRunShell - Job
> DEFAULT.Execute EmailJobDetail1 threw an unhandled Exception:
> org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
> Invocation of method 'sendEmailMessage' on target class [class
> com.sun.proxy.$Proxy188] failed; nested exception is
> org.springframework.orm.jpa.JpaSystemException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]; nested
> exception is <openjpa-2.4.1-r422266:1730418 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
> at
>
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:331)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
> ~[quartz-2.1.7.jar:na]
> at
>
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]
> Caused by: org.springframework.orm.jpa.JpaSystemException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]; nested
> exception is <openjpa-2.4.1-r422266:1730418 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
> at
>
> org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:418)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:122)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:417)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodIntercceptor.invoke(CrudMethodMetadataPostProcessor.java:111)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at com.sun.proxy.$Proxy184.findByStatusType(Unknown Source) ~[na:na]
> at
>
> org.apache.fineract.infrastructure.campaigns.email.service.EmailCampaignWritePlatformCommandHandlerImpl.sendEmailMessage(EmailCampaignWritePlatformCommandHandlerImpl.java:556)
> ~[classes/:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_144]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
> at
>
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at com.sun.proxy.$Proxy188.sendEmailMessage(Unknown Source) ~[na:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_144]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
> at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:269)
> ~[spring-core-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:322)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> ... 3 common frames omitted
> Caused by: org.apache.openjpa.persistence.PersistenceException: Unknown
> column 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT
> t0.id, t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
> at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5003)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4963)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:133)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:154)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2116)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:39)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1257)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1013)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:869)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:800)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:541)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:274)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:290)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> ~[na:1.8.0_144]
> at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> ~[na:1.8.0_144]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_144]
> at
>
> org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:360)
> ~[spring-orm-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at com.sun.proxy.$Proxy368.getResultList(Unknown Source) ~[na:na]
> at
>
> org.springframework.data.jpa.repository.query.JpaQueryExecution$CollectionExecution.doExecute(JpaQueryExecution.java:81)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na]
> at
>
> org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:59)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na]
> at
>
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:97)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na]
> at
>
> org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:88)
> ~[spring-data-jpa-1.6.4.RELEASE.jar:na]
> at
>
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:384)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na]
> at
>
> org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:344)
> ~[spring-data-commons-1.8.4.RELEASE.jar:na]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
> ~[spring-aop-4.0.8.RELEASE.jar:4.0.8.RELEASE]
> at
>
> org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)
> ~[spring-tx-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> ... 24 common frames omitted
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown
> column 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT
> t0.id, t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:218)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:202)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1117)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1800)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:258)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:500)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:425)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:392)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:427)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:230)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:220)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:93)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
>
> org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2075)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:33)
> ~[openjpa-all-2.4.1.jar:2.4.1]
> ... 49 common frames omitted
> 104701 [Scheduler1_Worker-1] ERROR org.quartz.core.ErrorLogger - Job
> (DEFAULT.Execute EmailJobDetail1 threw an exception.
> org.quartz.SchedulerException: Job threw an unhandled exception.
> at org.quartz.core.JobRunShell.run(JobRunShell.java:224)
> ~[quartz-2.1.7.jar:na]
> at
>
> org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
> [quartz-2.1.7.jar:na]
> Caused by:
> org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
> Invocation of method 'sendEmailMessage' on target class [class
> com.sun.proxy.$Proxy188] failed; nested exception is
> org.springframework.orm.jpa.JpaSystemException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]; nested
> exception is <openjpa-2.4.1-r422266:1730418 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
> t21.is_loan_officer, t21.mobile_no, t21.office_id,
> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
> t22.id, t22.is_active, t22.display_name, t22.email_address,
> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_outbound
> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
> JOIN
> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
> LEFT
> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
> t20.id
> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
> t11
> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
> at
>
> org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:331)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at
>
> org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:112)
> ~[spring-context-support-4.0.7.RELEASE.jar:4.0.7.RELEASE]
> at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
> ~[quartz-2.1.7.jar:na]
> ... 1 common frames omitted
> Caused by: org.springframework.orm.jpa.JpaSystemException: Unknown column
> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT t0.id
> ,
> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name,
> t3.opening_date, t3.parent_id, t1.office_joining_date,
> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
> t1.reopened_on_date, t1.default_savings_account,
> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
> t12.id, t12.is_active, t12.display_name, t12.email_address,
> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
> t10.username, t9.approvedon_date, t13.id, t13.core_report,
> t13.description,
> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
> t14.id,
> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
> t14.username, t9.closedon_date, t9.email_attachment_file_format,
> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
> t15.description, t15.report_category, t15.report_name, t15.report_sql,
> t15.report_subtype, t15.report_type, t15.use_report,
> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
> t16.last_time_password_updated, t16.lastname, t16.office_id, t16.password,
> t16.password_never_expires, t16.staff_id, t16.username,
> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
> t18.last_time_password_updated, t18.lastname, t18.office_id, t18.password,
> t18.password_never_expires, t18.staff_id, t18.username,
> t17.activation_date, t17.closedon_userid, t17.closedon_date,
> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
> t19.level_nam