Symptoms

The "History of All activities for day" page shows blank when clicking any date in the Fitness Analyzer page. This issue was discovered in the most recent Avamar versions with Management Console Server (MCS) hotfix: Avamar MCS: 19.9.0-78_HF338827Avamar MCS: 19.10.0-166_HF338869 Log in to the Avamar User Interface (AUI)Click Fitness AnalyzerThe Fitness Analyzer page opensClick BACKUPClick HISTORYClick any dateThe "History of All activities for day" page shows blankFrom the /usr/local/avamar/var/eagleeye/server_log/eagleeye.log file, the following exception can be seen: 2024-12-24 11:43:54.670 ERROR 3061 --- [ajp-nio-0:0:0:0:0:0:0:1-8109-exec-9] o.s.b.w.servlet.support.ErrorPageFilter : Forwarding to error page from request [/api/summary/calendar/events/details] due to exception [null] java.lang.NullPointerException: null at java.util.concurrent.ConcurrentHashMap.get(ConcurrentHashMap.java:936) at org.springframework.util.ConcurrentLruCache.get(ConcurrentLruCache.java:79) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getParsedSql(NamedParameterJdbcTemplate.java:436) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getPreparedStatementCreator(NamedParameterJdbcTemplate.java:420) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.getPreparedStatementCreator(NamedParameterJdbcTemplate.java:399) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:209) at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.queryForList(NamedParameterJdbcTemplate.java:303) at com.dell.emc.appeng.eagleeye.service.BackupCodeServiceImpl.getBackupHistoryPerday(BackupCodeServiceImpl.java:319) at com.dell.emc.appeng.eagleeye.service.BackupCodeServiceImpl$$FastClassBySpringCGLIB$$333cf12a.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) at com.dell.emc.appeng.eagleeye.service.BackupCodeServiceImpl$$EnhancerBySpringCGLIB$$37df4a66.getBackupHistoryPerday() at com.dell.emc.appeng.eagleeye.controller.BackupCodeController.getBackupHistoryPerday(BackupCodeController.java:78) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)

Cause

This issue is under investigation by Engineering.

Resolution

There is no workaround using Fitness Analyzer. The report can be generated using the Avamar Administrator console. Launch the Avamar AdministratorClick ActivityClick the Activity Report tabClick the Change Filter button and edit the filter accordinglyClick OKClick the Retrieve buttonTo export the report, click Actions > Export Report Another option is using psql command. The following command consults the database of 2024 December 04th and shows the date timestamp, the domain, the client, and the status code. Change the psql command accordingly: admin@avmar-srv:~/>: psql -p 5555 mcdb -U admin -c "select recorded_date_time,domain,client_name,status_code_summary from v_activities_2 where recorded_date_time >= '2024-12-04 00:00:00%' and recorded_date_time recorded_date_time | domain | client_name | status_code_summary -------------------------+----------------------------------+--------------------------------------------+------------------------------------ 2024-12-04 06:05:12.787 | /vCenterLab01/VirtualMachines | win10-desk-01_gE0yj7ZFP8GAnbnKW8Aj7A | Activity failed - client error(s). 2024-12-04 15:05:07.961 | /vCenterLab01/VirtualMachines | win10-desk-01_gE0yj7ZFP8GAnbnKW8Aj7A | Activity failed - client error(s). 2024-12-04 15:10:19.788 | /vCenterLab01/VirtualMachines | oracle-105-_NqZVjpzBOs6dD9iX6AhgIA | Activity completed successfully. (3 rows) admin@avmar-srv:~/>: For available columns for v_activities_2 run: psql -p 5555 mcdb -U admin -c "\d v_activities_2 ;"

Support Cases