Don't see my list of on-demand reports

Products

• Network Observability
• CA Performance Management

Issue/Introduction

My list of on-demand reports is not populating for my user

Environment

Dx NetOps Performance Management 23.3.12

Cause

Seen in PCService.log

 

Caused by: java.lang.NullPointerException: CreatedOn timestamp can not be null!
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.google.common.base.Preconditions.checkNotNull(Preconditions.java:921) ~[guava-32.1.2-jre.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.api.services.interfaces.reporting.ReportDefinition.setCreatedOn(ReportDefinition.java:305) ~[portal-api-impl.services.interfaces-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.api.services.reporting.ReportDefinitionService.createReportFromDataRow(ReportDefinitionService.java:345) ~[portal-api-impl.services.impl-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.api.services.reporting.ReportDefinitionService.getReports(ReportDefinitionService.java:298) ~[portal-api-impl.services.impl-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.site.models.ReportListModel.getTable(ReportListModel.java:163) ~[portal.console.site-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.render.desktop.report.GridRenderer.getDataResponse(GridRenderer.java:905) ~[portal.console.render.desktop-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at com.ca.im.portal.render.desktop.report.GridRenderer.getInitialResponse(GridRenderer.java:875) ~[portal.console.render.desktop-23.3.12-RELEASE-1.jar:?]
INFO   | jvm 1    | 2024/09/26 18:22:27 |     at org.apache.jsp.report.grid_002dextjs_002dtemplate_jsp._jspService(grid_002dextjs_002dtemplate_jsp.java:492) ~[classes/:?]

Resolution

1. select UserID,Name from user_definitions where Name ='affected username';

2. Note the userid

3. Run select * from report_definitions where userid=<affected user id>\G;

... check the CreatedOn value for each for the various reports.  If they are null you could do:

4. update report_definitions set CreatedOn=<unix time> where userid=<affected userid> and ReportID=##;

You can use https://www.unixtimestamp.com/, to get the current unix time

The on-demand reports should now populate