Created
February 22, 2018 06:54
-
-
Save anonymous/55b56496b3df5b3b12d66cfb0b9688d0 to your computer and use it in GitHub Desktop.
Jasper Log
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
2018-02-22 12:18:06,146 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:152 - DB is DB2/NT64 version SQL10057 (10/5) | |
2018-02-22 12:18:06,147 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:156 - driver is IBM Data Server Driver for JDBC and SQLJ version 4.16.53 (4/16) | |
2018-02-22 12:18:06,148 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:160 - jdbc 4/1 | |
2018-02-22 12:18:06,148 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:162 - connection URL is jdbc:db2://172.16.8.77:50000/JSWREPOR | |
2018-02-22 12:18:06,148 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:204 - system timezone is sun.util.calendar.ZoneInfo[id="Asia/Calcutta",offset=19800000,dstSavings=0,useDaylight=false,transitions=6,lastRule=null] | |
2018-02-22 12:18:06,149 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:205 - report timezone is sun.util.calendar.ZoneInfo[id="Asia/Calcutta",offset=19800000,dstSavings=0,useDaylight=false,transitions=6,lastRule=null] | |
2018-02-22 12:18:06,149 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:206 - JDBC timezone parameter is null | |
2018-02-22 12:18:06,149 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:207 - JDBC timezone property is null | |
2018-02-22 12:18:06,149 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:213 - JDBC parameters timezone parameter is null | |
2018-02-22 12:18:06,149 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:225 - JDBC parameters timezone property is null | |
2018-02-22 12:18:06,150 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:232 - parameters timezone null | |
2018-02-22 12:18:06,150 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:238 - JDBC fields timezone parameter is null | |
2018-02-22 12:18:06,150 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:250 - JDBC fields timezone property is null | |
2018-02-22 12:18:06,150 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:257 - fields timezone null | |
2018-02-22 12:18:06,151 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:362 - SQL query string: select * from JSW_LOCATION_MASTER where ID_NO=? | |
2018-02-22 12:18:06,151 DEBUG JRJdbcQueryExecuter,pool-6-thread-5:569 - Parameter #1 (CustometID of type java.lang.Integer): 15 | |
2018-02-22 12:18:06,153 ERROR AsyncJasperPrintAccessor,pool-6-thread-5:321 - Error during report execution | |
net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CrossCheck. | |
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169) | |
at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) | |
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) | |
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) | |
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440) | |
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) | |
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:945) | |
at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:896) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1812) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1143) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1072) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:967) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) | |
at java.lang.Thread.run(Unknown Source) | |
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=db2admin.JSW_LOCATION_MASTER, DRIVER=4.16.53 | |
at com.ibm.db2.jcc.am.fd.a(fd.java:739) | |
at com.ibm.db2.jcc.am.fd.a(fd.java:60) | |
at com.ibm.db2.jcc.am.fd.a(fd.java:127) | |
at com.ibm.db2.jcc.am.to.c(to.java:2771) | |
at com.ibm.db2.jcc.am.to.d(to.java:2759) | |
at com.ibm.db2.jcc.am.to.a(to.java:2192) | |
at com.ibm.db2.jcc.am.uo.a(uo.java:7827) | |
at com.ibm.db2.jcc.t4.ab.h(ab.java:141) | |
at com.ibm.db2.jcc.t4.ab.b(ab.java:41) | |
at com.ibm.db2.jcc.t4.o.a(o.java:32) | |
at com.ibm.db2.jcc.t4.tb.i(tb.java:145) | |
at com.ibm.db2.jcc.am.to.kb(to.java:2161) | |
at com.ibm.db2.jcc.am.uo.wc(uo.java:3657) | |
at com.ibm.db2.jcc.am.uo.b(uo.java:4454) | |
at com.ibm.db2.jcc.am.uo.jc(uo.java:760) | |
at com.ibm.db2.jcc.am.uo.executeQuery(uo.java:725) | |
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) | |
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) | |
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) | |
... 17 more | |
2018-02-22 12:18:06,159 ERROR ErrorPageHandlerAction,http-nio-8080-exec-7:118 - Error UID bfffc554-28d4-4f42-a1e0-48c4d27eeb7f | |
com.jaspersoft.jasperserver.api.JSException: Error filling report | |
Arguments: | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$FillResultListener.reportFillError(EngineServiceImpl.java:1320) | |
at net.sf.jasperreports.engine.fill.BaseFillHandle.notifyError(BaseFillHandle.java:216) | |
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:138) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:945) | |
at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:169) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:896) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1812) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1143) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1072) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:967) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) | |
at java.lang.Thread.run(Unknown Source) | |
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CrossCheck. | |
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:347) | |
at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169) | |
at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113) | |
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245) | |
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723) | |
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:440) | |
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:554) | |
at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123) | |
... 10 more | |
Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=db2admin.JSW_LOCATION_MASTER, DRIVER=4.16.53 | |
at com.ibm.db2.jcc.am.fd.a(fd.java:739) | |
at com.ibm.db2.jcc.am.fd.a(fd.java:60) | |
at com.ibm.db2.jcc.am.fd.a(fd.java:127) | |
at com.ibm.db2.jcc.am.to.c(to.java:2771) | |
at com.ibm.db2.jcc.am.to.d(to.java:2759) | |
at com.ibm.db2.jcc.am.to.a(to.java:2192) | |
at com.ibm.db2.jcc.am.uo.a(uo.java:7827) | |
at com.ibm.db2.jcc.t4.ab.h(ab.java:141) | |
at com.ibm.db2.jcc.t4.ab.b(ab.java:41) | |
at com.ibm.db2.jcc.t4.o.a(o.java:32) | |
at com.ibm.db2.jcc.t4.tb.i(tb.java:145) | |
at com.ibm.db2.jcc.am.to.kb(to.java:2161) | |
at com.ibm.db2.jcc.am.uo.wc(uo.java:3657) | |
at com.ibm.db2.jcc.am.uo.b(uo.java:4454) | |
at com.ibm.db2.jcc.am.uo.jc(uo.java:760) | |
at com.ibm.db2.jcc.am.uo.executeQuery(uo.java:725) | |
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) | |
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) | |
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) | |
... 17 more |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment