![](http://content.invisioncic.com/i328763/set_resources_3/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
Joe_123
-
Posts
4 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by Joe_123
-
-
Hi,
what is the class of the parameter in iReport? It should be Collections.
How do you refer to the parameter in query?
-
Hi All,
I've got 24 schedulers in JasperServer which run an export job every day, every scheduler runs at a different time (with a few minutes of delay).
The schedulers are exporting csv files to the file system, but not every scheduler executes succesfully. Some csv files are always missing (not the same, always different exported reports are missing).
For example: The first scheduled job is executed successfully, then the second fails, then the rest of the 20 schedulers are executed successfully..
The catalina log says:
2017-11-01 01:08:19,842 ERROR ReportExecutionJob,quartzScheduler_Worker-1:363 - The report was not completed. An error occurred while executing it. (Error UID: 05c86be7-d68d-405b-81f8-0fefb40469d6)
com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection
Arguments:
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1784)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1130)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1059)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:954)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:932)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:649)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.executeReportUnitRequest(EngineServiceImpl.java:2045)
at com.jaspersoft.jasperserver.api.engine.jasperreports.domain.impl.ReportUnitRequest.execute(ReportUnitRequest.java:67)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.execute(EngineServiceImpl.java:529)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.runReport(ReportExecutionJob.java:847)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:814)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeReport(ReportExecutionJob.java:711)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:496)
at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:245)
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)
Caused by: java.sql.SQLException: monetdbd: an internal error has occurred 'cannot connect: Connection refused', refer to the logs for details, please try again later
at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:289)
at nl.cwi.monetdb.jdbc.MonetDriver.connect(MonetDriver.java:166)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:76)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56)
... 18 more
Caused by: nl.cwi.monetdb.mcl.MCLException: monetdbd: an internal error has occurred 'cannot connect: Connection refused', refer to the logs for details, please try again later
at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:317)
at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:401)
at nl.cwi.monetdb.mcl.net.MapiSocket.connect(MapiSocket.java:258)
at nl.cwi.monetdb.jdbc.MonetConnection.<init>(MonetConnection.java:268)
... 28 more
DB log:
2017-11-01 01:07:56 MSG merovingian[1595]: database 'motors' (22338) was killed by signal SIGKILL
2017-11-01 01:08:19 MSG merovingian[1595]: database 'motors' has crashed after start on 2017-11-01 01:05:15, attempting restart, up min/avg/max: 15m/1h/6h, crash average: 1.00 0.80 0.73 (30-8=22)
2017-11-01 01:08:19 MSG motors[31527]: arguments: /usr/bin/mserver5 --dbpath=/var/lib/monetdb/motors --set merovingian_uri=mapi:monetdb://statics:50000/motors --set mapi_open=false --set mapi_port=0 --set mapi_usock=/var/lib/monetdb/motors/.mapi.sock --set monet_vault_key=/var/lib/monetdb/motors/.vaultkey --set gdk_nr_threads=5 --set max_clients=64 --set sql_optimizer=default_pipe --set monet_daemon=yes
2017-11-01 01:08:19 MSG merovingian[1595]: proxying client localhost:49102 for database 'motors' to mapi:monetdb:///var/lib/monetdb/motors/.mapi.sock?database=motors
2017-11-01 01:08:19 MSG merovingian[1595]: starting a proxy failed: cannot connect: Connection refused
2017-11-01 01:08:19 ERR control[1595]: !monetdbd: an internal error has occurred 'cannot connect: Connection refused'
2017-11-01 01:08:21 MSG motors[31527]: # MonetDB 5 server v11.25.23 "Dec2016-SP5"
2017-11-01 01:08:21 MSG motors[31527]: # Serving database 'motors', using 5 threads
2017-11-01 01:08:21 MSG motors[31527]: # Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers
2017-11-01 01:08:21 MSG motors[31527]: # Found 11.735 GiB available main-memory.
2017-11-01 01:08:21 MSG motors[31527]: # Copyright © 1993-July 2008 CWI.
2017-11-01 01:08:21 MSG motors[31527]: # Copyright © August 2008-2017 MonetDB B.V., all rights reserved
2017-11-01 01:08:21 MSG motors[31527]: # Visit http://www.monetdb.org/ for further information
2017-11-01 01:08:21 MSG motors[31527]: # Listening for UNIX domain connection requests on mapi:monetdb:///var/lib/monetdb/motors/.mapi.sock
2017-11-01 01:08:21 MSG motors[31527]: # MonetDB/SQL module loaded
2017-11-01 01:08:24 ERR merovingian[1595]: client error: cannot connect: Connection refused
2017-11-01 01:09:00 MSG merovingian[1595]: proxying client localhost:49113 for database 'motors' to mapi:monetdb:///var/lib/monetdb/motors/.mapi.sock?database=motors
2017-11-01 01:09:00 MSG merovingian[1595]: target connection is on local UNIX domain socket, passing on filedescriptor instead of proxying
2017-11-01 01:10:41 ERR discovery[1595]: cannot retrieve name info: Temporary failure in name resolution
...The report query:
select date, time, id, engine_type, engine_code, capacity, bore_stroke_rat, valve_gear, max_power_out, spec_out, max_torque, spec_torque, sump, compression_ratio, fuel_system, bmep, max_rpm, coolant, unitary_capacity, aspiration, compressor, intercooler, catalytic_inverter, acceleration60, acceleration80, acceleration100, acceleration160, max_speed, power_to_weight_rat, weight_to_power_rat, fuel_consumption, litres100km, km_litre, uk_mpg, us_mpg, carbon_dioxid_emiss, carfolio_calc_co2, ved_band, engine_position, engine_layout, drive_wheels, steering, brakes, gearbox, rac
from motors.datas
where date = date_to_str(cast($P{param_date} as date), '%Y-%m-%d')
and $X{IN, engine_type, param_engine_type}
order by date, timeIf I execute the reports in JasperServer, everything is correct, the reports run successfully.
Can anybody help me with this issue?
Kind regard,
joe_
-
Hi!
I would like to use my Custom Data Source (Custom implementation of JRDataSource) in JasperReports Server.
In Jasper Studio it works fine but I can't upload it with the report to JasperReports Server.
How would I be able to do this?
Thanks!
Parameter is not prompting
in Products
Posted
Hi himanshu17sept,
have you tried to set the nested type of family_LOV parameter to string?