[FINERACT-1344] Table 'fineract_default.ppi_poverty_line' doesn't exist in `/api/v1/survey/surveyName/clientId`

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Joseph Makara
• Created: 10/Apr/21 19:12
• Updated: 11/Apr/21 08:16

Description

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

[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 = ?]; 

nested exception is java.sql.SQLSyntaxErrorException: Table 'fineract_default.ppi_poverty_line' doesn't exist

Test: 

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

Results

{
  "timestamp": 1618076928835,
  "status": 500,
  "error": "Internal Server Error",
  "message": "",
  "path": "/fineract-provider/api/v1/survey/sub-rates/1"
}

Issue Links

• blocks: FINERACT-1343 PART 2 - Use prepared statements instead of string concatenated SQL everywhere