[
https://issues.apache.org/jira/browse/FINERACT-1625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17540622#comment-17540622
]
Francis Guchie commented on FINERACT-1625:
------------------------------------------
[~ikimbrah] [~mkaitesi] [~rrpawar]
I have been looking at the logs and noticed some jobs not going fine due to the
sql statements. Probably these are some of the areas in apache-fineract that
most of us ignore until we really need to see them functioning well. [~rrpawar]
if you can quickly identify the path of this sql code i can quickly provide a
working script for you to make a pr for it
> Slow Query Error(s) - PreparedStatementCallback; bad SQL grammar
> -----------------------------------------------------------------
>
> Key: FINERACT-1625
> URL: https://issues.apache.org/jira/browse/FINERACT-1625
> Project: Apache Fineract
> Issue Type: Bug
> Reporter: Francis Guchie
> Assignee: Rahul Pawar
> Priority: Major
>
> This is one of the Slow query errors i have noticed in the logs
> bad SQL grammar [select s.id as id,s.office_id as officeId, o.name as
> officeName, s.firstname as firstname, s.lastname as lastname, s.display_name
> as displayName, s.is_loan_officer as isLoanOfficer, s.external_id as
> externalId, s.mobile_no as mobileNo, s.is_active as isActive, s.joining_date
> as joiningDate from m_staff s join m_office o on o.id = s.office_id WHERE
> s.is_loan_officer is ? AND s.is_active = ? AND o.hierarchy like ? order
> by s.lastname ]; nested exception is java.sql.SQLSyntaxErrorException: You
> have an error in your SQL syntax; check the manual that corresponds to your
> MySQL server version for the right syntax to use near '' true ' AND
> s.is_active = 1 AND o.hierarchy like '.%' order by s.lastname' at line 1
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
