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 <[email protected]> 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
