[jira] [Commented] (FINERACT-1306) Reporting meta-data entry not found - All reports modules

[Michael Vorburger (Jira)]

    [ 
https://issues.apache.org/jira/browse/FINERACT-1306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17280661#comment-17280661
 ] 

Michael Vorburger commented on FINERACT-1306:
---------------------------------------------

[~francisguchie] and [~rrpawar] I've debugged this, using 
https://github.com/apache/fineract/compare/develop...vorburger:FINERACT-1306, 
and ... I'm not sure yet that I agree it's a regression :D

So it fails when 
org.apache.fineract.infrastructure.dataqueries.api.RunreportsApiResource.runReport()
 calls 
org.apache.fineract.infrastructure.dataqueries.service.ReadReportingServiceImpl.getReportType()
 and that fails by throwing ReportNotFoundException, when it runs "{{SELECT 
ifnull(report_type,'') as report_type FROM `stretchy_report` where report_name 
= 'reportCategoryList' and self_service_user_report = ?}}" (respectively the 
"wrapped" {{select x.* from (SELECT ifnull(report_type,'') as report_type FROM 
`stretchy_report` where report_name = 'reportCategoryList' and 
self_service_user_report = ?) x}}) which returns no results, because indeed in 
the {{stretchy_report}} table there is no report named {{reportCategoryList}}.

So the error "just" means that /runreports could not find a report named 
"reportCategoryList". Is that not the expected behavior?

We can try to revert that commit and debug how it behaved before, to understand 
the difference and what needs to change.

> Reporting meta-data entry not found - All reports modules
> ---------------------------------------------------------
>
>                 Key: FINERACT-1306
>                 URL: https://issues.apache.org/jira/browse/FINERACT-1306
>             Project: Apache Fineract
>          Issue Type: Bug
>          Components: Reports
>    Affects Versions: 1.5.0
>            Reporter: Francis Guchie
>            Assignee: Michael Vorburger
>            Priority: Major
>             Fix For: 1.5.0
>
>         Attachments: image-2021-01-27-09-41-45-780.png
>
>
> [https://ipaddress/fineract-provider/api/v1/runreports/reportCategoryList?R_reportCategory=Fund&genericResultSet=false&parameterType=true|https://diprom.biz/fineract-provider/api/v1/runreports/reportCategoryList?R_reportCategory=Fund&genericResultSet=false&parameterType=true]
> One gets the response payload below 
> {
>  "developerMessage": "The requested resource is not available.",
>  "httpStatusCode": "404",
>  "defaultUserMessage": "The requested resource is not available.",
>  "userMessageGlobalisationCode": "error.msg.resource.not.found",
>  "errors": [
>  {
>  "developerMessage": "Reporting meta-data entry not found.",
>  "defaultUserMessage": "Reporting meta-data entry not found.",
>  "userMessageGlobalisationCode": "error.msg.report.name.not.found",
>  "parameterName": "id",
>  "value": null,
>  "args": [
> { "value": "Report Name: reportCategoryList" }
> ]
>  }
>  ]
>  }



--
This message was sent by Atlassian Jira
(v8.3.4#803005)