JasperServer-Scheduled Jobs-Saving to n/w drive
Posted on September 24, 2008 at 5:20pm
I have created a JasperReport, deployed it on to JASPERSERVER & now i want to schedule it & save the EXCEL & PDF exports to a shared network drive. Is it possible with JASPERSERVER? I am able to save it to a folder on JASPERSERVER's root, but i want to save it to Shared network drive like M:drive in my office where in everybody has access to it. Any help is appreciated.
Posted on September 25, 2008 at 6:40am
Saving report job output to a file system (local or remote) is not supported in JasperServer. It can be implemented as a JasperServer customization, which would of course involve coding.
Posted on September 25, 2008 at 9:26am
oh....can you give me any sample links to customize the Server Code like where exactly i need to change in the code, like can you throw some light on it?
Posted on September 25, 2008 at 10:51am
You should start by getting the JasperServer sources and checking the following Java class: jasperserver-api-impl/engine/src/main/java/com/jaspersoft/jasperserver/api/engine/scheduling/quartz/ReportExecutionJob.java
Posted on September 25, 2008 at 7:29pm
If it doesn't save to the file system, where does it save the reports to? A database table in mysql?
Posted on September 26, 2008 at 12:48am
Exactly. The entire JasperServer repository (including report job output files) is persisted into a database.
Report job output files are saved into a table named JIContentResource.
Posted on September 26, 2008 at 1:45pm
Huh, that explains why JasperServer gets so slow and even starts breaking after a while, as saved reports start accumulating.
Too bad I haven't programmed on Java or I would be able to help.
Posted on October 29, 2008 at 3:12pm
Saving of generated report content to the repository does not break things normally or effect performance. Gabriel - what have you been seeing?
Posted on October 29, 2008 at 4:25pm
Well, as my users start saving PDF outputs, other reports start to fail. It's almost like MySql performance is affected by report outputs. The same happens with CSV and Excel reports, although at a slower rate than PDF. I am forced to delete saved reports manually every once in a while, or many reports will stop running and scheduled reports will not be e-mailed out.
Posted on December 1, 2009 at 12:31am
Is Saving report job output to a file system (local or remote) not supported in latest version of JasperServer also?
please reply soon.
Posted on December 1, 2009 at 12:59am
i think not as this is not the idea behind web based reporting.. you might want to try to schedule e-mails containing the reports, and auto planting them in a UNC folder
Posted on December 9, 2009 at 4:19pm
Correct - there has been no change in this area.
Posted on March 28, 2012 at 4:11am
Over these past years, was there any improvement concerning this issue?
I'm using JasperServer 4.5.0. I would like to know if there's any way to store reports into the filesystem. Wich file should I have to make changes to store sthe reports in the file system instead of the database.
In this post You say that reports are stored in th database in a table called JIContnetResource. I can't find that table... In the version, are they stored in a different table?
Thanks in advance,
Posted on May 14, 2012 at 9:14pm
Where that JIContentResource table is allocated? any hint any idea? I didn't find any table or any other database in jasperserver. Once anybody give me the hint where this table exists or in which table this data is stored I will code it to store at the local file system. Please help
Posted on May 16, 2012 at 9:49pm
I have a workaround for this: pull your report from JS and save it to the file system using a cron job.
My report is generated once a day as a PDF. I need this pdf to be on a web server - and don't want it to be regenerated everytime a user wants to see it & our jasper instance is not accessable from outside our domain but this report needs to be.
Previously I had configured anonymous access to the generated pdf file and used php (fopen) to read the file (using http://jasperserver:8080/jasperserver/fileview/fileview/foldername/filename.pdf) and dispatch it on request.
But after upgrade to 4.5 this broke with a NPE. I changed it now using a cron job to pull the file via wget to the web server every morning after the report is generated.
The report could be stored on any share the cron owner can write to... this would work locally on the server running jasper server as well...
Post Edited by franzkrauth at 17/05/2012 15:13