Recently, I deployed the fineractplatform-18.03.01.RELEASE to an ubuntu environment, for development purposes, have been testing all the APIs and everything seems fine until I encountered this issue while trying to read from a datatable.
I was able to save to the datatable and I was able to run query on the datatable from mysql command line, but when I tried to read the content from the API it throws runtime exception.
I will appreciate all helps in the right direction.
Below is a short snippet of the stack trace.
10:19:31.616 [http-bio-443-exec-1] INFO o.a.f.i.d.s.ReadWriteNonCoreDataServiceImpl - data scoped sql: select null as officeId, null as groupId, null as clientId, null as savingsId, null as loanId, p.id as entityId from m_savings_product as p WHERE p.id = 1
10:19:31.618 [http-bio-443-exec-1] DEBUG o.a.f.i.d.s.GenericDataServiceImpl - ::3 Was inside the fill ResultSetColumnHeader
May 27, 2019 10:19:31 AM com.sun.jersey.spi.container.ContainerResponse mapMappableContainerException
SEVERE: The RuntimeException could not be mapped to a response, re-throwing to the HTTP container
at org.apache.fineract.infrastructure.security.utils.SQLInjectionValidator.validateSQLInput(SQLInjectionValidator.java:36) at org.apache.fineract.infrastructure.security.utils.ColumnValidator.validateSqlInjection(ColumnValidator.java:95) at org.apache.fineract.infrastructure.dataqueries.service.ReadWriteNonCoreDataServiceImpl.retrieveDataTableGenericResultSet(ReadWriteNonCoreDataServiceImpl.java:1190) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)