CABI reports-error 28 from storage engine

Document ID : KB000125123
Last Modified Date : 23/01/2019
Show Technical Document Details
Issue:
When running a CABI 6.x report, you can see errors displayed in the screen, similar to the ones below:

net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Most_Alarms_Group. at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:874) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:536) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:411) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:386) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1066) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1025) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:286) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:122) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:580) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:924) at 
.
.
.
.
Caused by: java.sql.SQLException: Got error 28 from storage engine at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:136)
Environment:
Spectrum 10.x
CABI 6.x
Cause:
The "error 28" means "no space left on device". This could be about no free disk space on SRM server, at "$SPECROOT/mysql/data/reporting" directory or temporary directory.
Resolution:
Increase disk space in SRM server / related filesystem.