Error message in reports tab
Error:
This was the bug found by the engineering team
RCA:
When a user logs in to the AEUI and navigates to Reports >> Dashboard page, an HTTP call is made to the AE Server to get the list of - (1) dashboards which are created by logged in user and (2) dashboards of it’s tenant which have been marked as public.
In this tenant's case, a reporti dashboard named ""Teste"" was created by user ""uteste"" (user_record_id 7731) and it was marked as public.
Later, on 01-August-2020, this user ""uteste"" was deleted by another user ""rfuchimi"".
A user record got deleted successfully but dashboard records created by this user remained in the database.
So the HTTP call being made from the AEUI was failing with the following error (from logs):
2020-08-12 00:26:29 IST (+05:30) https-jsse-nio-443-exec-204 DEBUG ReportRestController:397 - Request to get dashboards
2020-08-12 00:26:29 IST (+05:30) https-jsse-nio-443-exec-204 DEBUG GenericCRUDImpl:61 - No record found with id 7731 for entity com.automationedge.aeengine.rest.entity.User, returning null.
2020-08-12 00:26:29 IST (+05:30) https-jsse-nio-443-exec-204 ERROR AEBaseRestController:145 - Exception: java.lang.NullPointerException: null
Fix/Solution:
The team has updated the dashboard record and removed its public access. We can also delete this record from the database table (not yet done)."