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)


Unable to find Unknown column 't9.previous_run_status.

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


On Sat, Jun 9, 2018 at 10:55 PM, Steve Conrad <sconrad1@xxxxxxxxx> wrote:

> Hi Emmanuel -
>
> One more quick note. I realized that I had already made that change as a
> part of my MySQL-5.7 fixes. You are correct that the stretchy_reports query
> will fail if ONLY_FULL_GROUP_BY is enabled (which it is by default in MySQL
> 5.7).
>
> You can either disable that option in your MySQL 5.5 instance, or you can
> update that row in the stretchy_reports table to address this issue.
> Thanks,
> Steve
>
>
> On Sat, Jun 9, 2018 at 3:59 PM Steve Conrad <sconrad1@xxxxxxxxx> wrote:
>
>> Hi Emmanuel -
>>
>> This query is one of the stretchy reports, which is found in the
>> stretchy_report table. However, I am able to run the original query without
>> errors on both MySQL 5.6 and 5.7. I would need to understand more about
>> your environment to know why it is failing for you.
>>
>> If you would like to change the report SQL in your environment, you would
>> do something like:
>>
>> update stretchy_report set report_sql=`<your updated sql>` where
>> report_name='ClientSummary'
>>
>> On Sat, Jun 9, 2018 at 3:02 PM Emmanuel Njoku <einjoku@xxxxxxxxx> wrote:
>>
>>> Dear  Steve,
>>>
>>> I am having the same error on mysql 5.5. i download the latest code
>>> using git clone https://github.com/openMF/incubator-fineract.git.
>>> please what is the solution to this error message.
>>>
>>> select x.* from (SELECT x.* FROM m_client c, m_office o,
>>> (SELECT a.loanCycle, a.activeLoans, b.lastLoanAmount, d.activeSavings,
>>> d.totalSavings FROM
>>>   (SELECT IFNULL(MAX(l.loan_counter),0) AS loanCycle, COUNT(l.id) AS
>>> activeLoans FROM m_loan l
>>>   WHERE l.loan_status_id=300 AND l.client_id=10) a,
>>>   (SELECT count(l.id), IFNULL(l.principal_amount,0) AS 'lastLoanAmount'
>>> FROM m_loan l WHERE l.client_id=10
>>>   AND l.disbursedon_date = (SELECT IFNULL(MAX(disbursedon_date),NOW())
>>> FROM
>>> m_loan where client_id=10 and loan_status_id=300)) b,
>>>  (SELECT COUNT(s.id) AS 'activeSavings',
>>> IFNULL(SUM(s.account_balance_derived),0) AS 'totalSavings'
>>>  FROM m_savings_account s WHERE s.status_enum=300 AND s.client_id=10) d
>>> ) x
>>> WHERE c.id=10 AND o.id = c.office_id AND o.hierarchy LIKE CONCAT('.',
>>> '%'))
>>> x
>>>
>>>
>>> On Sat, Jun 9, 2018 at 5:30 PM, Steve Conrad <sconrad1@xxxxxxxxx> wrote:
>>>
>>> > Hi Emmanuel -
>>> >
>>> > We do have a project that allows us to work with MySQL 5.7 and fixes
>>> all
>>> > of the group by clauses in Fineract. But that code has not been pushed
>>> into
>>> > any of the active branches as far as I know. I think we had identified
>>> a
>>> > large testing task for this summer's GSoC to make sure we had covered
>>> > everything.
>>> >
>>> > If you want to use MySQL 5.7, you can pull from my fork:
>>> > https://github.com/conradsp/fineract/tree/mysql-5.7
>>> > Otherwise, you'll have to use MySQL 5.6
>>> >
>>> > Thanks,
>>> > Steve
>>> >
>>> >
>>> > On Sat, Jun 9, 2018 at 11:07 AM, Emmanuel Njoku <einjoku@xxxxxxxxx>
>>> wrote:
>>> >
>>> >> The solution is below query
>>> >>
>>> >> select x.* from (SELECT x.* FROM m_client c, m_office o,
>>> >> (SELECT a.loanCycle, a.activeLoans, b.lastLoanAmount, d.activeSavings,
>>> >> d.totalSavings FROM
>>> >>   (SELECT IFNULL(MAX(l.loan_counter),0) AS loanCycle, COUNT(l.id) AS
>>> >> activeLoans FROM m_loan l WHERE l.loan_status_id=300 AND
>>> l.client_id=8) a,
>>> >>   (SELECT count(l.id), IFNULL(l.principal_amount,0) AS
>>> 'lastLoanAmount'
>>> >> FROM m_loan l WHERE l.client_id=8
>>> >>   AND l.disbursedon_date = (SELECT IFNULL(MAX(disbursedon_date),
>>> NOW())
>>> >> FROM
>>> >> m_loan where client_id=8 and loan_status_id=300) group by
>>> >> l.principal_amount) b,
>>> >>  (SELECT COUNT(s.id) AS 'activeSavings',
>>> >> IFNULL(SUM(s.account_balance_derived),0) AS 'totalSavings'
>>> >>  FROM m_savings_account s WHERE s.status_enum=300 AND s.client_id=8)
>>> d) x
>>> >> WHERE c.id=8 AND o.id = c.office_id AND o.hierarchy LIKE CONCAT('.',
>>> >> '%'))
>>> >> x;
>>> >>
>>> >> But i need the class where it was defined so that it can be update.
>>> >>
>>> >> Regards
>>> >>
>>> >> On Sat, Jun 9, 2018 at 4:54 PM, Emmanuel Njoku <einjoku@xxxxxxxxx>
>>> wrote:
>>> >>
>>> >> > please assist on this request. I have identify the issue and
>>> solution to
>>> >> > it but i am seriously looking on the code "incubator-fineract" so
>>> that i
>>> >> > can update it. There is no "group by" on the Mysql query.
>>> >> >
>>> >> > Caused by: com.mysql.jdbc.exceptions.jdbc4.
>>> MySQLSyntaxErrorException:
>>> >> In
>>> >> > aggregated query without GROUP BY, expression #2 of SELECT list
>>> contains
>>> >> > nonaggregated column 'mifostenant-default.l.principal_amount';
>>> this is
>>> >> > incompatible with sql_mode=only_full_group_by
>>> >> >
>>> >> >
>>> >> > /v1/runreports/ClientSummary","parameters":{"genericResultSe
>>> >> t":["false"],"
>>> >> > R_clientId":["10"]}}
>>> >> > 197280 [http-bio-443-exec-1] ERROR o.s.b.context.web.ErrorPageFilter
>>> -
>>> >> > Forwarding to error page from request [/api/v1/runreports/ClientSumm
>>> >> ary]
>>> >> > due to exception [StatementCallback; bad SQL grammar [select x.*
>>> from
>>> >> > (SELECT x.* FROM m_client c, m_office o,
>>> >> > (
>>> >> >        SELECT a.loanCycle, a.activeLoans, b.lastLoanAmount,
>>> >> > d.activeSavings, d.totalSavings FROM
>>> >> >   (SELECT IFNULL(MAX(l.loan_counter),0) AS loanCycle, COUNT(l.id)
>>> AS
>>> >> > activeLoans FROM m_loan l WHERE l.loan_status_id=300 AND
>>> >> l.client_id=10) a,
>>> >> >   (SELECT count(l.id), IFNULL(l.principal_amount,0) AS
>>> 'lastLoanAmount'
>>> >> > FROM m_loan l WHERE l.client_id=10 AND l.disbursedon_date = (SELECT
>>> >> > IFNULL(MAX(disbursedon_date),NOW()) FROM m_loan where client_id=10
>>> and
>>> >> > loan_status_id=300)) b,
>>> >> >  (SELECT COUNT(s.id) AS 'activeSavings',
>>> IFNULL(SUM(s.account_balance_d
>>> >> erived),0)
>>> >> > AS 'totalSavings' FROM m_savings_account s WHERE s.status_enum=300
>>> AND
>>> >> > s.client_id=10) d
>>> >> > ) x
>>> >> > WHERE c.id=10 AND o.id = c.office_id AND o.hierarchy LIKE
>>> CONCAT('.',
>>> >> > '%')) x]; nested exception is com.mysql.jdbc.exceptions.jdbc
>>> >> 4.MySQLSyntaxErrorException:
>>> >> > In aggregated query without GROUP BY, expression #2 of SELECT list
>>> >> contains
>>> >> > nonaggregated column 'mifostenant-default.l.principal_amount';
>>> this is
>>> >> > incompatible with sql_mode=only_full_group_by]
>>> >> > org.springframework.jdbc.BadSqlGrammarException:
>>> StatementCallback; bad
>>> >> > SQL grammar [select x.* from (SELECT x.* FROM m_client c, m_office
>>> o,
>>> >> > (
>>> >> >        SELECT a.loanCycle, a.activeLoans, b.lastLoanAmount,
>>> >> > d.activeSavings, d.totalSavings FROM
>>> >> >   (SELECT IFNULL(MAX(l.loan_counter),0) AS loanCycle, COUNT(l.id)
>>> AS
>>> >> > activeLoans FROM m_loan l WHERE l.loan_status_id=300 AND
>>> >> l.client_id=10) a,
>>> >> >   (SELECT count(l.id), IFNULL(l.principal_amount,0) AS
>>> 'lastLoanAmount'
>>> >> > FROM m_loan l WHERE l.client_id=10 AND l.disbursedon_date = (SELECT
>>> >> > IFNULL(MAX(disbursedon_date),NOW()) FROM m_loan where client_id=10
>>> and
>>> >> > loan_status_id=300)) b,
>>> >> >  (SELECT COUNT(s.id) AS 'activeSavings',
>>> IFNULL(SUM(s.account_balance_d
>>> >> erived),0)
>>> >> > AS 'totalSavings' FROM m_savings_account s WHERE s.status_enum=300
>>> AND
>>> >> > s.client_id=10) d
>>> >> > ) x
>>> >> > WHERE c.id=10 AND o.id = c.office_id AND o.hierarchy LIKE
>>> CONCAT('.',
>>> >> > '%')) x]; nested exception is com.mysql.jdbc.exceptions.jdbc
>>> >> 4.MySQLSyntaxErrorException:
>>> >> > In aggregated query without GROUP BY, expression #2 of SELECT list
>>> >> contains
>>> >> > nonaggregated column 'mifostenant-default.l.principal_amount';
>>> this is
>>> >> > incompatible with sql_mode=only_full_group_by
>>> >> >         at org.springframework.jdbc.support.
>>> SQLExceptionSubclassTransla
>>> >> tor
>>> >> > .doTranslate(SQLExceptionSubclassTranslator.java:91)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.springframework.jdbc.support.
>>> AbstractFallbackSQLExceptio
>>> >> nTr
>>> >> > anslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.springframework.jdbc.support.
>>> AbstractFallbackSQLExceptio
>>> >> nTr
>>> >> > anslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.springframework.jdbc.core.
>>> JdbcTemplate.execute(JdbcTempl
>>> >> ate.java:413)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.springframework.jdbc.core.
>>> JdbcTemplate.query(JdbcTemplat
>>> >> e.java:468)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.springframework.jdbc.core.
>>> JdbcTemplate.queryForRowSet(Jd
>>> >> bcTemplate.java:523)
>>> >> > ~[spring-jdbc-4.0.7.RELEASE.jar:4.0.7.RELEASE]
>>> >> >         at org.apache.fineract.infrastructure.dataqueries.service.
>>> >> > GenericDataServiceImpl.fillGenericResultSet(GenericDataServi
>>> >> ceImpl.java:59)
>>> >> > ~[classes/:na]
>>> >> >         at org.apache.fineract.infrastructure.dataqueries.service.
>>> >> > ReadReportingServiceImpl.retrieveGenericResultset(
>>> >> > ReadReportingServiceImpl.java:181) ~[classes/:na]
>>> >> >         at org.apache.fineract.infrastructure.dataqueries.
>>> >> > api.RunreportsApiResource.runReport(RunreportsApiResource.java:121)
>>> >> > ~[classes/:na]
>>> >> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
>>> Method)
>>> >> > ~[na:1.8.0_171]
>>> >> >         at sun.reflect.NativeMethodAccessorImpl.invoke(
>>> >> > NativeMethodAccessorImpl.java:62) ~[na:1.8.0_171]
>>> >> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
>>> >> > DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_171]
>>> >> >         at java.lang.reflect.Method.invoke(Method.java:498)
>>> >> > ~[na:1.8.0_171]
>>> >> >         at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.
>>> invo
>>> >> ke(
>>> >> > JavaMethodInvokerFactory.java:60) ~[jersey-server-1.17.jar:1.17]
>>> >> >         at com.sun.jersey.server.impl.model.method.dispatch.
>>> >> > AbstractResourceMethodDispatchProvider$ResponseOutInvoker._
>>> dispatch(
>>> >> > AbstractResourceMethodDispatchProvider.java:205)
>>> >> > ~[jersey-server-1.17.jar:1.17]
>>> >> >
>>> >> >
>>> >> >
>>> >> > On Sat, Jun 9, 2018 at 3:25 PM, Ed Cable <edcable@xxxxxxxxx> wrote:
>>> >> >
>>> >> >> Emmanuel,
>>> >> >>
>>> >> >> Please start a new message thread if you have a different support
>>> >> query.
>>> >> >> You can do so my creating a new email with a relevant subject line
>>> and
>>> >> >> sending it to the respective mailing list.
>>> >> >>
>>> >> >> We need to keep each discussion thread relevant and on-topic.
>>> Thank you
>>> >> >> for using the mailing lists though!
>>> >> >>
>>> >> >> Cheers,
>>> >> >>
>>> >> >> Ed
>>> >> >>
>>> >> >> On Sat, Jun 9, 2018 at 3:00 AM Emmanuel Njoku <einjoku@xxxxxxxxx>
>>> >> wrote:
>>> >> >>
>>> >> >>> who can assist me on this error message. I obtain this message
>>> after
>>> >> >>> creation of new Data table mapped to client*.*
>>> >> >>>
>>> >> >>>
>>> >> >>> Jun 09, 2018 10:45:22 AM com.sun.jersey.spi.container.C
>>> >> ontainerResponse
>>> >> >>> mapMappableContainerException
>>> >> >>> SEVERE: The RuntimeException could not be mapped to a response,
>>> >> >>> re-throwing
>>> >> >>> to the HTTP container
>>> >> >>> java.lang.NullPointerException
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.security.utils.SQLInjecti
>>> >> >>> onValidator.validateSQLInput(SQLInjectionValidator.java:36)
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.security.utils.ColumnVali
>>> >> >>> dator.validateSqlInjection(ColumnValidator.java:95)
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.dataqueries.service.ReadW
>>> >> >>> riteNonCoreDataServiceImpl.retrieveDataTableGenericResultSet
>>> >> >>> (ReadWriteNonCoreDataServiceImpl.java:1190)
>>> >> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> >> >>> at
>>> >> >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>> >> >>> ssorImpl.java:62)
>>> >> >>> at
>>> >> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>> >> >>> thodAccessorImpl.java:43)
>>> >> >>> at java.lang.reflect.Method.invoke(Method.java:498)
>>> >> >>> at
>>> >> >>> org.springframework.aop.support.AopUtils.invokeJoinpointUsin
>>> >> >>> gReflection(AopUtils.java:317)
>>> >> >>> at
>>> >> >>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(
>>> >> >>> JdkDynamicAopProxy.java:201)
>>> >> >>> at com.sun.proxy.$Proxy148.retrieveDataTableGenericResult
>>> Set(Unknown
>>> >> >>> Source)
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.dataqueries.api.
>>> >> >>> DatatablesApiResource.getDatatable(DatatablesApiResource.java:
>>> 174)
>>> >> >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>> >> >>> at
>>> >> >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
>>> >> >>> ssorImpl.java:62)
>>> >> >>> at
>>> >> >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>> >> >>> thodAccessorImpl.java:43)
>>> >> >>> at java.lang.reflect.Method.invoke(Method.java:498)
>>> >> >>> at
>>> >> >>> com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invo
>>> >> >>> ke(JavaMethodInvokerFactory.java:60)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.model.method.dispatch.AbstractRes
>>> >> >>> ourceMethodDispatchProvider$TypeOutInvoker._dispatch(Abstr
>>> >> >>> actResourceMethodDispatchProvider.java:185)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.model.method.dispatch.ResourceJav
>>> >> >>> aMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(
>>> >> >>> HttpMethodRule.java:302)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accep
>>> >> >>> t(RightHandPathRule.java:147)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accep
>>> >> >>> t(ResourceClassRule.java:108)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accep
>>> >> >>> t(RightHandPathRule.java:147)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule
>>> >> >>> .accept(RootResourceClassesRule.java:84)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.application.WebApplicationImpl._h
>>> >> >>> andleRequest(WebApplicationImpl.java:1511)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.application.WebApplicationImpl._h
>>> >> >>> andleRequest(WebApplicationImpl.java:1442)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.application.WebApplicationImpl.ha
>>> >> >>> ndleRequest(WebApplicationImpl.java:1391)
>>> >> >>> at
>>> >> >>> com.sun.jersey.server.impl.application.WebApplicationImpl.ha
>>> >> >>> ndleRequest(WebApplicationImpl.java:1381)
>>> >> >>> at
>>> >> >>> com.sun.jersey.spi.container.servlet.WebComponent.service(We
>>> >> >>> bComponent.java:416)
>>> >> >>> at
>>> >> >>> com.sun.jersey.spi.container.servlet.ServletContainer.servic
>>> >> >>> e(ServletContainer.java:538)
>>> >> >>> at
>>> >> >>> com.sun.jersey.spi.container.servlet.ServletContainer.servic
>>> >>
>>> >> >>> e(ServletContainer.java:716)
>>> >> >>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>> >> >>> lter(ApplicationFilterChain.java:303)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>> >> >>> licationFilterChain.java:208)
>>> >> >>> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilte
>>> >> >>> r.java:52)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>> >> >>> lter(ApplicationFilterChain.java:241)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>> >> >>> licationFilterChain.java:208)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.intercept.FilterSecu
>>> >> >>> rityInterceptor.invoke(FilterSecurityInterceptor.java:108)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.intercept.FilterSecu
>>> >> >>> rityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>> >> >>> lter(ApplicationFilterChain.java:241)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>> >> >>> licationFilterChain.java:208)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:330)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.intercept.FilterSecu
>>> >> >>> rityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.intercept.FilterSecu
>>> >> >>> rityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.ExceptionTranslation
>>> >> >>> Filter.doFilter(ExceptionTranslationFilter.java:113)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.authentication.AnonymousAut
>>> >> >>> henticationFilter.doFilter(AnonymousAuthenticationFilter.
>>> java:113)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.servletapi.SecurityContextH
>>> >> >>> olderAwareRequestFilter.doFilter(SecurityContextHolder
>>> >> >>> AwareRequestFilter.java:154)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.security.filter.TwoFactor
>>> >> >>> AuthenticationFilter.doFilter(TwoFactorAuthenticationFilter.
>>> java:122)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.context.request.async.WebAs
>>> >> >>> yncManagerIntegrationFilter.doFilterInternal(WebAsyncManag
>>> >> >>> erIntegrationFilter.java:50)
>>> >> >>> at
>>> >> >>> org.springframework.web.filter.OncePerRequestFilter.doFilter
>>> >> >>> (OncePerRequestFilter.java:107)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.authentication.www.BasicAut
>>> >> >>> henticationFilter.doFilter(BasicAuthenticationFilter.java:201)
>>> >> >>> at
>>> >> >>> org.apache.fineract.infrastructure.security.filter.TenantAwa
>>> >> >>> reBasicAuthenticationFilter.doFilter(TenantAwareBasicAuthe
>>> >> >>> nticationFilter.java:153)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.context.SecurityContextPers
>>> >> >>> istenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.access.channel.ChannelProce
>>> >> >>> ssingFilter.doFilter(ChannelProcessingFilter.java:144)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy$VirtualFil
>>> >> >>> terChain.doFilter(FilterChainProxy.java:342)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy.doFilterIn
>>> >> >>> ternal(FilterChainProxy.java:192)
>>> >> >>> at
>>> >> >>> org.springframework.security.web.FilterChainProxy.doFilter(F
>>> >> >>> ilterChainProxy.java:160)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>> >> >>> lter(ApplicationFilterChain.java:241)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>> >> >>> licationFilterChain.java:208)
>>> >> >>> at
>>> >> >>> org.springframework.boot.context.web.ErrorPageFilter.doFilte
>>> >> >>> r(ErrorPageFilter.java:108)
>>> >> >>> at
>>> >> >>> org.springframework.boot.context.web.ErrorPageFilter.access$
>>> >> >>> 000(ErrorPageFilter.java:58)
>>> >> >>> at
>>> >> >>> org.springframework.boot.context.web.ErrorPageFilter$1.doFil
>>> >> >>> terInternal(ErrorPageFilter.java:87)
>>> >> >>> at
>>> >> >>> org.springframework.web.filter.OncePerRequestFilter.doFilter
>>> >> >>> (OncePerRequestFilter.java:107)
>>> >> >>> at
>>> >> >>> org.springframework.boot.context.web.ErrorPageFilter.doFilte
>>> >> >>> r(ErrorPageFilter.java:100)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.internalDoFi
>>> >> >>> lter(ApplicationFilterChain.java:241)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.ApplicationFilterChain.doFilter(App
>>> >> >>> licationFilterChain.java:208)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.StandardWrapperValve.invoke(Standar
>>> >> >>> dWrapperValve.java:219)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.StandardContextValve.invoke(Standar
>>> >> >>> dContextValve.java:110)
>>> >> >>> at
>>> >> >>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(A
>>> >> >>> uthenticatorBase.java:506)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.StandardHostValve.invoke(StandardHo
>>> >> >>> stValve.java:169)
>>> >> >>> at
>>> >> >>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo
>>> >> >>> rtValve.java:103)
>>> >> >>> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogVa
>>> >> >>> lve.java:962)
>>> >> >>> at
>>> >> >>> org.apache.catalina.core.StandardEngineValve.invoke(Standard
>>> >> >>> EngineValve.java:116)
>>> >> >>> at
>>> >> >>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd
>>> >> >>> apter.java:445)
>>> >> >>> at
>>> >> >>> org.apache.coyote.http11.AbstractHttp11Processor.process(Abs
>>> >> >>> tractHttp11Processor.java:1115)
>>> >> >>> at
>>> >> >>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler
>>> >> >>> .process(AbstractProtocol.java:637)
>>> >> >>> at
>>> >> >>> org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(
>>> >> >>> JIoEndpoint.java:318)
>>> >> >>> at
>>> >> >>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPool
>>> >> >>> Executor.java:1149)
>>> >> >>> at
>>> >> >>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo
>>> >> >>> lExecutor.java:624)
>>> >> >>> at
>>> >> >>> org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.
>>> >> >>> run(TaskThread.java:61)
>>> >> >>> at java.lang.Thread.run(Thread.java:748)
>>> >> >>>
>>> >> >>> On Sat, Jun 9, 2018 at 7:20 AM, Raunak Sett <
>>> sett.raunak@xxxxxxxxx>
>>> >> >>> wrote:
>>> >> >>>
>>> >> >>> > We should use Angular Material. We should have consistent
>>> experience
>>> >> >>> > across all platforms and given that we are already following
>>> >> material
>>> >> >>> > design guidelines on a lot of our android clients as well as
>>> web.
>>> >> So it
>>> >> >>> > would be easier if we just have a common UI/UX guidelines for
>>> the
>>> >> >>> > consistency.
>>> >> >>> >
>>> >> >>> > On Fri, Jun 8, 2018 at 10:13 PM Abhay Chawla <
>>> >> abhay.chawla97@xxxxxxxxx
>>> >> >>> >
>>> >> >>> > wrote:
>>> >> >>> >
>>> >> >>> >> Hello everyone,
>>> >> >>> >>
>>> >> >>> >> After some discussion, Anwesh and I have a come up with the
>>> >> following
>>> >> >>> >> points regarding the decision to use Angular Material or
>>> bootswatch
>>> >> >>> and
>>> >> >>> >> ng-bootstrap for the new MifosX Web App (Angular 6):
>>> >> >>> >>
>>> >> >>> >> 1) ng-bootstrap is a wrapper over bootstrap.js which contains a
>>> >> set of
>>> >> >>> >> Angular Directives that can be implemented without any
>>> >> dependencies on
>>> >> >>> >> jQuery or popper.js  https://ng-bootstrap.github.io/#/home
>>> >> >>> >> 2) Bootswatch provides a collection of themes(21 + 1 default)
>>> for
>>> >> >>> >> Bootstrap  https://github.com/thomaspark/bootswatch/
>>> >> >>> >> 3) Bootswatch provides with an API which can be integrated
>>> with the
>>> >> >>> >> platform for theme configuration easily and provide the
>>> >> organizations
>>> >> >>> with
>>> >> >>> >> a choice from these 21 themes  https://bootswatch.com/api/4.
>>> json
>>> >> >>> >> 4) We are currently using the bootswatch material theme to
>>> compete
>>> >> and
>>> >> >>> >> provide with a similar kind of look as by angular-material
>>> >> >>> >> 5) New themes if required can be configured easily using
>>> bootstrap,
>>> >> >>> as a
>>> >> >>> >> simple example I have created a demonstration here:
>>> >> >>> https://abhaychawla.
>>> >> >>> >> github.io/angular-theme/
>>> >> >>> >> 6) We can also provide instructions so that the organizations
>>> will
>>> >> be
>>> >> >>> >> able to clone the project, create their own custom theme,
>>> build the
>>> >> >>> app and
>>> >> >>> >> use that theme.
>>> >> >>> >> 7) Overall, ng-bootstrap and bootswatch built on top of
>>> bootstrap
>>> >> are
>>> >> >>> >> easy to implement and could be modified and used to suit our
>>> needs
>>> >> >>> >>
>>> >> >>> >> 8) On the other hand, angular-material provides with 4 inbuilt
>>> >> >>> material
>>> >> >>> >> themes to chose from  https://material.angular.io/
>>> >> >>> >> 9) More custom themes can be configured according to
>>> organizations
>>> >> >>> needs
>>> >> >>> >> using angular-material as well but it will be a bit more
>>> complex
>>> >> >>> >> 10) Overall, angular-material will be more time consuming and a
>>> >> little
>>> >> >>> >> difficult to implement
>>> >> >>> >>
>>> >> >>> >> We would like to share this with the community and get their
>>> >> opinion
>>> >> >>> >> regarding our choice of design framework so that we can
>>> finalize
>>> >> the
>>> >> >>> same
>>> >> >>> >> as soon as possible in the initial stage of the project.
>>> >> >>> >>
>>> >> >>> >> Looking forward to your responses.
>>> >> >>> >>
>>> >> >>> >> Thanks
>>> >> >>> >> Abhay.
>>> >> >>> >>
>>> >> >>> >> --
>>> >> >>> >> You received this message because you are subscribed to the
>>> Google
>>> >> >>> Groups
>>> >> >>> >> "Mifos Google Summer of Code 2018" group.
>>> >> >>> >> To unsubscribe from this group and stop receiving emails from
>>> it,
>>> >> >>> send an
>>> >> >>> >> email to gsoc-2018+unsubscribe@xxxxxxxxx.
>>> >> >>> >>
>>> >> >>> >
>>> >> >>> >
>>> >> >>> > --
>>> >> >>> > Raunak Sett
>>> >> >>> >
>>> >> >>> > ------------------------------------------------------------
>>> >> >>> > ------------------
>>> >> >>> > 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
>>> >> >>> >
>>> >> >>>
>>> >> >>
>>> >> >>
>>> >> >> --
>>> >> >> *Ed Cable*
>>> >> >> President/CEO, Mifos Initiative
>>> >> >> edcable@xxxxxxxxx | Skype: edcable | Mobile: +1.484.477.8649
>>> >> >>
>>> >> >> *Collectively Creating a World of 3 Billion Maries | *
>>> http://mifos.org
>>> >> >> <http://facebook.com/mifos>  <http://www.twitter.com/mifos>
>>> >> >>
>>> >> >>
>>> >> >
>>> >>
>>> >
>>> >
>>> > ------------------------------------------------------------
>>> > ------------------
>>> > 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
>>> >
>>>
>>
> ------------------------------------------------------------
> ------------------
> 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
>