emcmillan Posted July 24 Share Posted July 24 I am quite new to this; our usual report writer is out of office for a couple of weeks.I believe we are using Jasper Reports Server Pro 8.0. We've created a Jasper report which creates a .csv file, and the file itself writes correctly to the archive, and can be emailed. However, the report is configured to send via ftp, and we receive the following when it runs:BEGIN QUOTESubject:The job failed to execute. Review its parameters.Date:TodayComponent:Report SchedulerMessage:Job: DLT_VesselSchedule_CSV (ID: 1416889) Report unit: /public/reports/Misc/DLT_VesselSchedule/gct_misc_01 Quartz Job: ReportJobs.job_1416889 Quartz Trigger: ReportJobs.trigger_1416887_1 Error Message: report.scheduling.error.upload.to.ftp.server Exceptions: java.net.ConnectException: Connection timed out (Connection timed out) at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at org.apache.commons.net.SocketClient.connect(SocketClient.java:182) at org.apache.commons.net.SocketClient.connect(SocketClient.java:203) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil$FTPServiceClientImpl.<init>(FTPUtil.java:231) at com.jaspersoft.jasperserver.api.engine.common.util.impl.FTPUtil.connectFTP(FTPUtil.java:53) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.saveToFTPServer(ReportExecutionJobFileSavingImpl.java:223) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJobFileSavingImpl.save(ReportExecutionJobFileSavingImpl.java:95) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:516) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:219) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.execute(ReportOptionsExecutionJob.java:45) at org.quartz.core.JobRunShell.run(JobRunShell.java:202) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:5END QUOTEThe report's Output Options > Output to FTP Server > Test Connection indicates "Connection passed". I am able to connect to the recipient ftp server via FileZilla and put the report file directly.Any assistance would be very much appreciated. Link to comment Share on other sites More sharing options...
Mehak Rajkumar Posted July 26 Share Posted July 26 Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times. Link to comment Share on other sites More sharing options...
emcmillan Posted July 26 Author Share Posted July 26 RESOLVED: the error was seen during a manual execution (Run Now), the scheduled report extracts, writes to the archived folder, and transmits via ftp as expected. Link to comment Share on other sites More sharing options...
rpachipu Posted July 27 Share Posted July 27 We are so glad that your problem was solved. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now