Log Analysis page filtering - Show All/Clear or some changes in filter will break Slow Actions by Day results, adding filter to Slow Pages Top 20, breaks the Log Analysis: Daily Page/XOG Views completely with error 500
STEPS TO REPRODUCE:
- On a used test environment, connect to Reports and Jobs and run Tomcat Analyze job for yesterday or any past day that has Clarity activity i.e. on MUX Task module
- Once the job completed go to Administration - Log Analysis
- Filter on the same date and Environment = local
- Now scroll down to portlet Slow Actions by Day
- Note different entries in this portlet for that day
- Select the gear icon - Configure - List Filter Section - layout
- Add all the fields in the Filter to Selected, select Allow Power filter, Save and return
- Repeat the same for portlet Slow Pages Top 20 in Daily Page/XOG Views
- Filter on a URL short in Daily Page/XOG Views
- Now go in the portlet Slow Actions by Day and try to filter on a specific value, i.e. date and url_short =oba.Tasks (make sure the value is already present in all results before filtering)
- Note the result displays at first. Now click Show All & try filtering again
Expected Results: The values to display and portlets to work consistently
Actual Results:
- The value does not always display (There are no items to display)
- Or if you click Show All it would just display no results
- Or Clear and Filter again, again no results
- Or remove and add another date
XOG Slow action portlet will throw error 500 and error in logs is:
\ERROR 2022-07-07 11:56:26,878 [http-nio-1602-exec-1109] union.persistence (clarity:admin:5368060__E75ADBAA-2461-49A6-B336-BE2DEDD5778F:npt.gridFilter) Exception on nsql_internal statement log_clstr_slow_pages_by_period:5047017
java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "MYTAB"."URL_ACTION": invalid identifier