[
https://issues.apache.org/jira/browse/RANGER-5545?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rakesh Gupta resolved RANGER-5545.
----------------------------------
Fix Version/s: 3.0.0
Resolution: Fixed
> Ranger UI Dashboard charts failing to render: 400 Error in audit metrics API
> post-Postgres upgrade
> --------------------------------------------------------------------------------------------------
>
> Key: RANGER-5545
> URL: https://issues.apache.org/jira/browse/RANGER-5545
> Project: Ranger
> Issue Type: Sub-task
> Components: Ranger
> Reporter: Rakesh Gupta
> Assignee: Rakesh Gupta
> Priority: Major
> Fix For: 3.0.0
>
>
> *Failure is seen in below API :*
> #
> {{/service/audit/days-audit-admin-metrics?objectClassTypes=1020&olderThanInDays=7}}
> Response code : 400
> Response message :
> {{}}
> {code:java}
> `Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.7.12.v20230209-e5c4074ef3):
> org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception:
> org.postgresql.util.PSQLException: ERROR: relation
> "vx_audit_admin_metrics_by_days" does not exist\n Position: 221\nError Code:
> 0\nCall: SELECT class_type, SUM(CASE WHEN action = 'create' THEN audit_count
> ELSE 0 END), SUM(CASE WHEN action = 'update' THEN audit_count ELSE 0 END),
> SUM(CASE WHEN action = 'delete' THEN audit_count ELSE 0 END), aud…type IN (?)
> AND action IN (?,?,?) GROUP BY class_type, auditDate ORDER BY
> auditDate\n\tbind => [5 parameters bound]\nQuery: DataReadQuery(sql="SELECT
> class_type, SUM(CASE WHEN action = 'create' THEN audit_count ELSE 0 END),
> SUM(CASE WHEN action = 'update' THEN audit_count ELSE 0 END), SUM(CASE WHEN
> action = 'delete' THEN audit_count ELSE 0 END), auditDate FROM
> vx_audit_admin_metrics_by_days WHERE auditDate >= ? AND class_type IN (?) AND
> action IN (?,?,?) GROUP BY class_type, auditDate ORDER BY auditDate")` {code}
> {{}}
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
