Lot of null (empty) entries showing in List view - Support and Troubleshooting

Lot of null (empty) entries showing in List view Issue  Symptoms When the "sn_sm_finance_request.list" was opened with pagination 50 or 100, observed that list was rendered with entries which shows empty or null in all the columns as shown in the below screenshot,

While loading the above list, observed below exception in session debug,

log16:18:32.843: java.lang.NullPointerException: java.lang.NullPointerException: log16:18:32.845: loadRow failure: java.lang.IllegalStateException: Sparse storage format has one field, sys_id: com.glide.db.meta.SparseStorage.getValue(SparseStorage.java:70) com.glide.db.meta.ATableIterator.getValue(ATableIterator.java:16) com.glide.script.GlideRecordITable.getValue(GlideRecordITable.java:403) com.glide.script.GlideRecord.loadRow0(GlideRecord.java:3583) com.glide.script.GlideRecord.loadRow(GlideRecord.java:3442) com.glide.script.GlideRecord.setLocation(GlideRecord.java:5912) com.glide.script.GlideRecord.setLocation(GlideRecord.java:5892) com.glide.list_v2.ListRecordDefaultTag.doTag(ListRecordDefaultTag.java:85) org.apache.commons.jelly.impl.CustomTagScript.run(CustomTagScript.java:205) org.apache.commons.jelly.TagSupport.invokeBody (TagSupport.java:235) com.glide.ui.jelly.tags.FileinfoTag2.doTag(FileinfoTag2.java:44) org.apache.commons.jelly.impl.CustomTagScript.run (CustomTagScript.java:205) org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146) org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:66) org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:235) com.glide.ui.jelly.tags.FileinfoTag2.doTag(FileinfoTag2.java:44) org.apache.commons.jelly.impl.CustomTagScript.run(CustomTagScript.java:205) org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146) org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:66) org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146) org.apache.commons.jelly.impl.StaticTagScript.run(StaticTagScript.java:66) org.apache.commons.jelly.impl.ScriptBlock.run(ScriptBlock.java:146) org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:235) com.glide.ui.jelly.tags.FileinfoTag2.doTag(FileinfoTag2.java:44) org.apache.commons.jelly.impl.CustomTagScript.run(CustomTagScript.java:205) org.apache.commons.jelly.TagSupport.invokeBody(TagSupport.java:235) org.apache.commons.jelly.tags.core.JellyTag.doTag(JellyTag.java:84) org.apache.commons.jelly.impl.CustomTagScript.run(CustomTagScript.java:205) com.glide.ui.jelly.GlideJellyContext.run(GlideJellyContext.java:668) com.glide.ui.jelly.GlideJellyContext.executeCompiledScript(GlideJellyContext.java:896) com.glide.ui.jelly.GlideJellyContext.runScript(GlideJellyContext.java:749) com.glide.ui.jelly.GlideJellyContext.runScript(GlideJellyContext.java:707) com.glide.ui.GlideFormPhase2.generate(GlideFormPhase2.java:49) com.glide.ui.GlideForm.generatePopulatedForm(GlideForm.java:707) com.glide.ui.GlideForm.generatePopulatedForm(GlideForm.java:692) com.glide.ui.GlideForm.populateForm(GlideForm.java:684) com.glide.ui.GlideForm.getRenderedPage(GlideForm.java:228) com.glide.ui.NavigationTransaction.writeOutput(NavigationTransaction.java:157) com.glide.ui.NavigationTransaction.process(NavigationTransaction.java:128) com.glide.ui.GlideServletUITransaction.process(GlideServletUITransaction.java:110) com.glide.processors.AProcessor.runProcessor(AProcessor.java:532) com.glide.processors.AProcessor.processTransaction(AProcessor.java:230) 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:2091) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:748) log16:18:32.845: [0:00:00.318] ListRecordDefault complete: sn_sm_finance_request Release Any supported release.

Cause Identified few sn_sm_finance_request record which was having sys_id with capital letters in it. This was breaking the list rendering functionality.

Resolution Please raise a case in HI , we will review and perform a change to correct the affected sys_ids.

Additional Information Lists