OSDir


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

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


Thank you Steve.

On Mon, Jun 11, 2018 at 5:25 PM, Steve Conrad <sconrad1@xxxxxxxxx> 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 <einjoku@xxxxxxxxx> wrote:
>
>> Unable to find Unknown column 't9.previous_run_status.
>>
>> 104659 [Scheduler1_Worker-1] ERROR org.quartz.core.JobRunShell - Job
>> DEFAULT.Execute EmailJobDetail1 threw an unhandled Exception:
>> org.springframework.scheduling.quartz.JobMethodInvocationFailedException:
>> Invocation of method 'sendEmailMessage' on target class [class
>> com.sun.proxy.$Proxy188] failed; nested exception is
>> org.springframework.orm.jpa.JpaSystemException: Unknown column
>> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT
>> t0.id,
>> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
>> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
>> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
>> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
>> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
>> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
>> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name
>> ,
>> t3.opening_date, t3.parent_id, t1.office_joining_date,
>> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
>> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
>> t1.reopened_on_date, t1.default_savings_account,
>> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
>> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
>> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
>> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
>> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
>> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
>> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
>> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
>> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
>> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
>> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
>> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
>> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
>> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
>> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
>> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
>> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
>> t12.id, t12.is_active, t12.display_name, t12.email_address,
>> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
>> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
>> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
>> t10.username, t9.approvedon_date, t13.id, t13.core_report,
>> t13.description,
>> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
>> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
>> t14.id,
>> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
>> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
>> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
>> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
>> t14.username, t9.closedon_date, t9.email_attachment_file_format,
>> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
>> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
>> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
>> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
>> t15.description, t15.report_category, t15.report_name, t15.report_sql,
>> t15.report_subtype, t15.report_type, t15.use_report,
>> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
>> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
>> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
>> t16.last_time_password_updated, t16.lastname, t16.office_id,
>> t16.password,
>> t16.password_never_expires, t16.staff_id, t16.username,
>> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
>> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
>> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
>> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
>> t18.last_time_password_updated, t18.lastname, t18.office_id,
>> t18.password,
>> t18.password_never_expires, t18.staff_id, t18.username,
>> t17.activation_date, t17.closedon_userid, t17.closedon_date,
>> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
>> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
>> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
>> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
>> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
>> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
>> t21.is_loan_officer, t21.mobile_no, t21.office_id,
>> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
>> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
>> t22.id, t22.is_active, t22.display_name, t22.email_address,
>> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
>> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
>> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
>> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_
>> outbound
>> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
>> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
>> JOIN
>> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
>> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
>> LEFT
>> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
>> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
>> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
>> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
>> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
>> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
>> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
>> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
>> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
>> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
>> t20.id
>> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
>> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
>> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
>> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
>> t11
>> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
>> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]; nested
>> exception is <openjpa-2.4.1-r422266:1730418 fatal general error>
>> org.apache.openjpa.persistence.PersistenceException: Unknown column
>> 't9.previous_run_status' in 'field list' {prepstmnt 378212349 SELECT
>> t0.id,
>> t0.campaign_name, t1.id, t1.account_no, t1.activatedon_userid,
>> t1.activation_date, t1.client_classification_cv_id, t1.client_type_cv_id,
>> t1.closedon_userid, t1.closedon_date, t1.closure_reason_cv_id,
>> t1.date_of_birth, t1.display_name, t1.email_address, t1.external_id,
>> t1.firstname, t1.fullname, t1.gender_cv_id, t2.id, t2.location,
>> t2.storage_type_enum, t1.is_staff, t1.lastname, t1.legal_form_enum,
>> t1.middlename, t1.mobile_no, t3.id, t3.external_id, t3.hierarchy, t3.name
>> ,
>> t3.opening_date, t3.parent_id, t1.office_joining_date,
>> t1.reactivated_on_date, t1.reactivated_on_userid, t1.rejectedon_userid,
>> t1.rejectedon_date, t1.reject_reason_cv_id, t1.reopened_by_userid,
>> t1.reopened_on_date, t1.default_savings_account,
>> t1.default_savings_product, t4.id, t4.is_active, t4.display_name,
>> t4.email_address, t4.external_id, t4.firstname, t5.id, t5.location,
>> t5.storage_type_enum, t4.joining_date, t4.lastname, t4.is_loan_officer,
>> t4.mobile_no, t6.id, t6.external_id, t6.hierarchy, t6.name,
>> t6.opening_date, t6.parent_id, t7.id, t7.is_active, t7.display_name,
>> t7.email_address, t7.external_id, t7.firstname, t7.image_id,
>> t7.joining_date, t7.lastname, t7.is_loan_officer, t7.mobile_no,
>> t7.office_id, t7.organisational_role_enum, t4.organisational_role_enum,
>> t1.status_enum, t1.sub_status, t1.submittedon_userid, t1.submittedon_date,
>> t8.id, t8.external_id, t8.hierarchy, t8.name, t8.opening_date,
>> t8.parent_id, t1.updated_by, t1.updated_on, t1.withdrawn_on_date,
>> t1.withdraw_reason_cv_id, t1.withdraw_on_userid, t0.email_address, t9.id,
>> t10.id, t10.nonexpired, t10.nonlocked, t10.nonexpired_credentials,
>> t10.is_deleted, t10.email, t10.enabled, t10.firsttime_login_remaining,
>> t10.firstname, t10.is_self_service_user, t10.last_time_password_updated,
>> t10.lastname, t11.id, t11.external_id, t11.hierarchy, t11.name,
>> t11.opening_date, t11.parent_id, t10.password, t10.password_never_expires,
>> t12.id, t12.is_active, t12.display_name, t12.email_address,
>> t12.external_id, t12.firstname, t12.image_id, t12.joining_date,
>> t12.lastname, t12.is_loan_officer, t12.mobile_no, t12.office_id,
>> t12.organisational_role_parent_staff_id, t12.organisational_role_enum,
>> t10.username, t9.approvedon_date, t13.id, t13.core_report,
>> t13.description,
>> t13.report_category, t13.report_name, t13.report_sql, t13.report_subtype,
>> t13.report_type, t13.use_report, t9.campaign_name, t9.campaign_type,
>> t14.id,
>> t14.nonexpired, t14.nonlocked, t14.nonexpired_credentials, t14.is_deleted,
>> t14.email, t14.enabled, t14.firsttime_login_remaining, t14.firstname,
>> t14.is_self_service_user, t14.last_time_password_updated, t14.lastname,
>> t14.office_id, t14.password, t14.password_never_expires, t14.staff_id,
>> t14.username, t9.closedon_date, t9.email_attachment_file_format,
>> t9.email_message, t9.email_subject, t9.is_visible, t9.last_trigger_date,
>> t9.next_trigger_date, t9.param_value, t9.previous_run_error_log,
>> t9.previous_run_error_message, t9.previous_run_status, t9.recurrence,
>> t9.recurrence_start_date, t9.status_enum, t15.id, t15.core_report,
>> t15.description, t15.report_category, t15.report_name, t15.report_sql,
>> t15.report_subtype, t15.report_type, t15.use_report,
>> t9.stretchy_report_param_map, t16.id, t16.nonexpired, t16.nonlocked,
>> t16.nonexpired_credentials, t16.is_deleted, t16.email, t16.enabled,
>> t16.firsttime_login_remaining, t16.firstname, t16.is_self_service_user,
>> t16.last_time_password_updated, t16.lastname, t16.office_id,
>> t16.password,
>> t16.password_never_expires, t16.staff_id, t16.username,
>> t9.submittedon_date, t0.email_subject, t0.error_message, t17.id,
>> t17.account_no, t18.id, t18.nonexpired, t18.nonlocked,
>> t18.nonexpired_credentials, t18.is_deleted, t18.email, t18.enabled,
>> t18.firsttime_login_remaining, t18.firstname, t18.is_self_service_user,
>> t18.last_time_password_updated, t18.lastname, t18.office_id,
>> t18.password,
>> t18.password_never_expires, t18.staff_id, t18.username,
>> t17.activation_date, t17.closedon_userid, t17.closedon_date,
>> t17.closure_reason_cv_id, t17.external_id, t19.id, t19.can_have_clients,
>> t19.level_name, t19.parent_id, t19.recursable, t19.super_parent,
>> t17.hierarchy, t17.display_name, t20.id, t20.external_id, t20.hierarchy,
>> t20.name, t20.opening_date, t20.parent_id, t17.parent_id, t21.id,
>> t21.is_active, t21.display_name, t21.email_address, t21.external_id,
>> t21.firstname, t21.image_id, t21.joining_date, t21.lastname,
>> t21.is_loan_officer, t21.mobile_no, t21.office_id,
>> t21.organisational_role_parent_staff_id, t21.organisational_role_enum,
>> t17.status_enum, t17.submittedon_userid, t17.submittedon_date, t0.message,
>> t22.id, t22.is_active, t22.display_name, t22.email_address,
>> t22.external_id, t22.firstname, t22.image_id, t22.joining_date,
>> t22.lastname, t22.is_loan_officer, t22.mobile_no, t22.office_id,
>> t22.organisational_role_parent_staff_id, t22.organisational_role_enum,
>> t0.status_enum, t0.submittedon_date FROM scheduled_email_messages_
>> outbound
>> t0 LEFT OUTER JOIN m_client t1 ON t0.client_id = t1.id LEFT OUTER JOIN
>> scheduled_email_campaign t9 ON t0.email_campaign_id = t9.id LEFT OUTER
>> JOIN
>> m_group t17 ON t0.group_id = t17.id LEFT OUTER JOIN m_staff t22 ON
>> t0.staff_id = t22.id LEFT OUTER JOIN m_image t2 ON t1.image_id = t2.id
>> LEFT
>> OUTER JOIN m_office t3 ON t1.office_id = t3.id LEFT OUTER JOIN m_staff t4
>> ON t1.staff_id = t4.id LEFT OUTER JOIN m_office t8 ON
>> t1.transfer_to_office_id = t8.id LEFT OUTER JOIN m_appuser t10 ON
>> t9.approvedon_userid = t10.id LEFT OUTER JOIN stretchy_report t13 ON
>> t9.businessRule_id = t13.id LEFT OUTER JOIN m_appuser t14 ON
>> t9.closedon_userid = t14.id LEFT OUTER JOIN stretchy_report t15 ON
>> t9.stretchy_report_id = t15.id LEFT OUTER JOIN m_appuser t16 ON
>> t9.submittedon_userid = t16.id LEFT OUTER JOIN m_appuser t18 ON
>> t17.activatedon_userid = t18.id LEFT OUTER JOIN m_group_level t19 ON
>> t17.level_id = t19.id LEFT OUTER JOIN m_office t20 ON t17.office_id =
>> t20.id
>> LEFT OUTER JOIN m_staff t21 ON t17.staff_id = t21.id LEFT OUTER JOIN
>> m_image t5 ON t4.image_id = t5.id LEFT OUTER JOIN m_office t6 ON
>> t4.office_id = t6.id LEFT OUTER JOIN m_staff t7 ON
>> t4.organisational_role_parent_staff_id = t7.id LEFT OUTER JOIN m_office
>> t11
>> ON t10.office_id = t11.id LEFT OUTER JOIN m_staff t12 ON t10.staff_id =
>> t12.id WHERE (t0.status_enum = ?)} [code=1054, state=42S22]
>> at
>> org.springframework.scheduling.quartz.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
> mifos-developer@xxxxxxxxxxxxxxxxxxxxx
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
>