FineReport报表问题- SET LOGSIZE FAILED 解决

1.问题描述

Oops!!!非常抱歉，您当前无法访问此页。
发生的问题是：CREATE EMB-DB: SET LOGSIZE FAILED!
详细信息
java.lang.RuntimeException: CREATE EMB-DB: SET LOGSIZE FAILED!<br> at com.fr.data.core.db.DBUtils.getEmbeddedDB(Unknown Source)<br> at com.fr.data.core.db.DBUtils.getEmbeddedDB(Unknown Source)<br> at com.fr.web.core.db.FineDB.refreshDB(Unknown Source)<br> at com.fr.web.core.db.FineDB.getDB(Unknown Source)<br> at com.fr.web.core.db.PlatformDB.refreshDB(Unknown Source)<br> at com.fr.web.core.db.PlatformDB.getDB(Unknown Source)<br> at com.fr.print.db.PrintDBHelper$1.createDatabaseConnection(Unknown Source)<br> at com.fr.print.db.PrintDBHelper.getJDBCDAOManager(Unknown Source)<br> at com.fr.print.db.PrintDBHelper.createDAOSession(Unknown Source)<br> at com.fr.print.PrinterOffsetAction.listByFieldValue(Unknown Source)<br> at com.fr.print.PrinterOffsetAction.getList(Unknown Source)<br> at com.fr.web.core.A.QB.A(Unknown Source)<br> at com.fr.web.core.A.QB.A(Unknown Source)<br> at com.fr.web.core.A.QB.B(Unknown Source)<br> at com.fr.web.core.A.QB.actionCMD(Unknown Source)<br> at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)<br> at ......
Caused by: java.sql.SQLException: error in script file line: 143 S1000 General error java.lang.NegativeArraySizeException in statement [SET TABLE FR_EXCEL_SUBMIT_TASK INDEX'17342 17342 3']<br> at com.fr.third.org.hsqldb.jdbc.Util.sqlException(Unknown Source)<br> at com.fr.third.org.hsqldb.jdbc.jdbcConnection.&lt;init&gt;(Unknown Source)<br> at com.fr.third.org.hsqldb.jdbcDriver.getConnection(Unknown Source)<br> at com.fr.third.org.hsqldb.jdbcDriver.connect(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidDataSource.init(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(Unknown Source)<br> at com.fr.third.alibaba.druid.pool.DruidDataSource.getConnection(Unknown Source)<br> at com.fr.data.pool.MemoryConnection.create(Unknown Source)<br> at com.fr.data.impl.JDBCDatabaseConnection.createConnection(Unknown Source)<br> ... 63 more<br>


java.sql.SQLException: error in script file line: 69 S1000 General error java.lang.NegativeArraySizeException in statement [SET TABLE FR_T_PLATFORMMANAGEMODULE INDEX'15282 15234 12314']
	at com.fr.third.org.hsqldb.jdbc.Util.sqlException(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.org.hsqldb.jdbcDriver.getConnection(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.org.hsqldb.jdbcDriver.connect(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(Unknown Source) ~[fr-third-8.0.jar!/:na]
	at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(Unknown Source) [fr-third-8.0.jar!/:na]

2.问题分析

该问题是因为 FineReport 中 插入或更新数据时有脏数据造成

3.解决方案：

只要有标明是哪一行出error的, 可以备份后, 用编辑器打开WEB_INF/finedb/db.script临时先删掉这一行.比如上述日志中的 69 行我们可以先删除

java.sql.SQLException: error in script file line: 69 S1000 General error 

如果没有这一行, finedb里没有重要数据的话，恢复一下备份finedb，重启工程。