Thank you Steve. On Mon, Jun 11, 2018 at 5:25 PM, Steve Conrad <[email protected]> wrote:
> 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.MethodInvokingJobDetailFactory >> Bean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactory >> Bean.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(ChainedPersistenceExceptionTra >> nslator.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.PersistenceExceptionTranslatio >> nInterceptor.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$CrudMethodMetadataPopulatingMe >> thodIntercceptor.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.MethodInvokingJobDetailFactory >> Bean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactory >> Bean.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.PersistenceExceptionTranslatio >> nInterceptor.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.MethodInvokingJobDetailFactory >> Bean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactory >> Bean.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 > > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > Mifos-developer mailing list > [email protected] > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer >
