Null Pointer Exception While Reading from Datatable

Good day,

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, as entityId from m_savings_product as p WHERE = 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.dataqueries.service.ReadWriteNonCoreDataServiceImpl.retrieveDataTableGenericResultSet(

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

hello, kindly were u able to resolve this issue as i have the same issue now and i have no clue how to resolve it.