Recibo el error que se menciona a continuación.
max_allowed_packet Se ha aumentado el tamaño de max_allowed_packet en el lado de mysql para la estructura especificada.
A pesar del aumento, se produce el error correspondiente.
No tengo idea de qué hacer con otros errores.
Después del error especificado, después del reinicio de mysqld el error se corrige, pero después de unos días vuelve a ocurrir.
Me gustaría su apoyo.
> Server Error
>
> The server has encountered an error. Please excuse the inconvenience.
>
> **Error Message Error filling report**
>
> **Error Trace** com.jaspersoft.jasperserver.api.JSException: Error filling
> report at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1266)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:210)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:134)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745) Caused by:
> net.sf.jasperreports.engine.JRException: Error executing SQL statement
> for: VHSingleTractors. at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> ... 11 more Caused by: com.mysql.jdbc.PacketTooBigException: Packet
> for query is too large (3842 > 1024). You can change this value on the
> server by setting the max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> ... 17 more
>
> **Error Message** net.sf.jasperreports.engine.JRException: Error executing
> SQL statement for: VHSingleTractors.
>
> **Error Trace** net.sf.jasperreports.engine.JRException: Error executing
> SQL statement for: VHSingleTractors. at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745) Caused by:
> com.mysql.jdbc.PacketTooBigException: Packet for query is too large
> (3842 > 1024). You can change this value on the server by setting the
> max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> ... 17 more
>
> **Error Message** com.mysql.jdbc.PacketTooBigException: Packet for query
> is too large (3842 > 1024). You can change this value on the server by
> setting the max_allowed_packet' variable.
>
> **Error Trace** com.mysql.jdbc.PacketTooBigException: Packet for query is
> too large (3842 > 1024). You can change this value on the server by
> setting the max_allowed_packet' variable. at
> com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3552) at
> com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429) at
> com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594) at
> com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
> at
> com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
> at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
> at
> net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1129)
> at
> net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:696)
> at
> net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)
> at
> net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:519)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:890)
> at
> net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:164)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:846)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1735)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912)
> at
> com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:745)