Notifications

144 views

Symptoms


Intermittently, following exception is logged in syslog.

No matching records: com.glideapp.report.charting_v2.exceptions.ChartDataGenException: No matching records: com.glideapp.report.charting_v2.datagen.single.score.json.SingleScoreJSONBuilder.buildResponseJSON(SingleScoreJSONBuilder.java:41)
com.glideapp.report.charting_v2.datagen.json.JSONBuilder.build(JSONBuilder.java:17)
com.glideapp.report.charting_v2.datagen.single.score.SingleScoreGenerator.generateJSONResponse(SingleScoreGenerator.java:42)
com.glideapp.report.charting_v2.datagen.single.score.SingleScoreGenerator.generate(SingleScoreGenerator.java:29)
com.glide.processors.report.run.SingleScoreRunProcessor.processRequest(SingleScoreRunProcessor.java:23)
com.glide.processors.report.run.ReportRunProcessor.process(ReportRunProcessor.java:44)
com.glide.processors.XMLHttpProcessor.processJavaAJAX(XMLHttpProcessor.java:151)
com.glide.processors.XMLHttpProcessor.process(XMLHttpProcessor.java:104)
com.glide.processors.AProcessor.runProcessor(AProcessor.java:483)
com.glide.processors.AProcessor.processTransaction(AProcessor.java:205)
com.glide.processors.ProcessorRegistry.process0(ProcessorRegistry.java:178)
com.glide.processors.ProcessorRegistry.process(ProcessorRegistry.java:167)
com.glide.ui.GlideServletTransaction.process(GlideServletTransaction.java:31)
com.glide.sys.Transaction.run(Transaction.java:2038)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)

Release


Any supported release.

Cause


Single score records are not configured with "Display Zero ( Show Zero)" to "true" ( tick on the check box) as shown in the below screenshot and hence  when there is no matching record system is displaying "no matching records" message and logging the exception. 

Resolution


For the Single score reports, make sure "Display Zero" is set to "true" (checkbox ticked) so that system will display 0 instead of logging exception when there is no match. 

On the sys_report.list, "Display zero" field is called with column name "Show zero". This will be useful, when you wanted to do list edit bulk amount of single score reports.

(you can find the affected single score reports via url,

https://<Instance name>/sys_report_list.do?sysparm_query=type%3Dsingle_score%5Eshow_zero%3Dfalse)

Additional Information


Single score report

Article Information

Last Updated:2018-08-21 07:51:42
Published:2018-08-21