Joseph Makara created FINERACT-1344:
---------------------------------------
Summary: Table 'fineract_default.ppi_poverty_line' doesn't exist
in `/api/v1/survey/surveyName/clientId`
Key: FINERACT-1344
URL: https://issues.apache.org/jira/browse/FINERACT-1344
Project: Apache Fineract
Issue Type: Bug
Reporter: Joseph Makara
https://demo.fineract.dev/fineract-provider/swagger-ui/index.html#/Survey/getClientSurveyOverview
API: /survey/\{surveyName}/\{clientId}
Requested URL:
https://localhost:8443/fineract-provider/api/v1/survey/sub-rates/1
Error while calling
Forwarding to error page from request [/api/v1/survey/sub-rates/1] due to
exception [PreparedStatementC allback; bad SQL grammar
{code:java}
[SELECT sub-rates as surveyName, tz.id, lkh.name, lkh.code, poverty_line,
tz.date, tz.score FROM `sub-rates` tz JOIN ppi_likelihoods_ppi lkp on
lkp.ppi_name = 'sub\-rates' AND ena
bled = ? JOIN ppi_scores sc on score_from <= tz.score AND score_to >=tz.score
JOIN ppi_poverty_line pvl on pvl.likelihood_ppi_id = lkp.id AND pvl.score_id =
sc.id JOIN ppi_likelihoods lkh on lkh.id = lkp
.likelihood_id WHERE client_id = ?];
{code}
nested exception is java.sql.SQLSyntaxErrorException: Table
'fineract_default.ppi_poverty_line' doesn't exist
Test:
{code:java}
curl -X GET
"https://localhost:8443/fineract-provider/api/v1/survey/sub-rates/1"; -H
"accept: application/json" -H "Authorization: Basic bWlmb3M6cGFzc3dvcmQ=" -H
"fineract-platform-tenantid: default" --insecure
{code}
Results
{code:java}
{
"timestamp": 1618076928835,
"status": 500,
"error": "Internal Server Error",
"message": "",
"path": "/fineract-provider/api/v1/survey/sub-rates/1"
}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
