Rakesh Gupta created RANGER-5545:
------------------------------------
Summary: 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
*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
(v8.20.10#820010)
