[FINERACT-1149] IllegalArgumentException at SQLBuilder.addCriteria() at StaffReadPlatformServiceImpl.retrieveAllLoanOfficersInOfficeById()

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.5.0
• Assignee: Michael Vorburger
• Reporter: Michael Vorburger
• Created: 11/Sep/20 19:20
• Updated: 25/Feb/21 08:11
• Resolved: 12/Sep/20 15:17

Description

See FINERACT-932 for general background; I've found this in logs of https://www.fineract.dev:

 java.lang.IllegalArgumentException: criteria column name must match [a-zA-Z_][a-zA-Z0-9_-]*\.)?[a-zA-Z_-][a-zA-Z0-9_-]* : is_loan_officer= =

        at org.apache.fineract.infrastructure.security.utils.SQLBuilder.addCriteria (SQLBuilder.java:79)
        at org.apache.fineract.organisation.staff.service.StaffReadPlatformServiceImpl.retrieveAllLoanOfficersInOfficeById (StaffReadPlatformServiceImpl.java:164)
        at org.apache.fineract.portfolio.loanaccount.service.LoanReadPlatformServiceImpl.retrieveAllowedLoanOfficers (LoanReadPlatformServiceImpl.java:1478)
        at org.apache.fineract.portfolio.loanaccount.api.LoansApiResource.template (LoansApiResource.java:444)

Manthan FYI would you perhaps want to create an integration test for this? Just a thought.

I'll raise a PR to fix it (as it seems to be a trivial problem).

Issue Links

• Blocked: FINERACT-1305 Release Apache Fineract v1.5.0
• blocks: FINERACT-932 Parent Issue for Error Logs seeing during "normal" usage (e.g. on fineract.dev)
• links to: GitHub Pull Request #1323