Dietmar Aust

daust ·

Hi Tobi,

for a situation like this I would use the following code:

DECLARE
   l_blob        BLOB;
   l_mime_type   VARCHAR2 (100);
BEGIN  
   xlib_jasperreports.get_report (p_rep_name => apex_util.url_encode('my_report'),
          p_rep_format      ...

I could reproduce the issue. By replacing the groovy-3.0.7 library with 3.0.12 it seems to work with JDK17. Will be included in the next release.

Hi @jeanomobono,

I am currently looking into this. Also, I will focus on supporting the current LTS JDK releases: https://github.com/daust/JasperReportsIntegration/issues/116

Anyway, I do have a question for you. When looking into the specifi...

Hi @jeanomobono,

I really appreciate your comment - many thanks for that.
I appreciate your approach and I typically do the same - for myself.

Nevertheless, I am here to help also those, who have more trouble adapting and finding alternative ways.I will...

Hi @jeanomobono ,

thank you for trying these different things.
Currently, I am at a conference in Chicago, traveling. I will be back next week.

Anyhow, is has become an increasing challenge to satisfy these different versions of Java, and even T...

Yes,

this is a known issue, please try the new (currently unreleased but already tested) version:

• tar: https://www.dropbox.com/s/awv9u6lelz3rb21/jri-2.9.0-jasper-6.19.1.tar?dl=0
• zip: https://www.dropbox.com/s/735zmcyzbxpdwp0/jri-2.9.0-jasper-6.1...

Hi,

I will have a look at it next week.

Best
~Dietmar.

Hi @flbessa ,

it will be released in a few days.

In the meantime, you can use the following files, they will be identical to what will be released later:

• jri-2.9.0-jasper-6.19.1.zip
• jri-2.9.0-jasper-6.19.1.tar
• jri-2.9.0-jasper-6.19.1-tomcat10...

Great.

If you have any issues, please reach out. It should work.

Great @daxlai,

then please mark this thread/question as "solved".

It will help others to quickly figure out what works or not.

Thank you.

Hi @Darioitaly,

hhhhm, I guess not. I am using UTL_HTTP to call the report, but they only allow APEX_WEB_SERVICE I believe.

Did you ever try it?

Thanks
~Dietmar.

@daxlai , @MohamedHeba does it work now for you? If yes, please mark the question as "solved". Thank you.

I could reproduce it and have created an issue for that: https://github.com/daust/JasperReportsIntegration/issues/111

And I already fixed it in 2.9.0.

Typically, a simple test case is based on USER_OBJECTS or some other data dictionary view because I don't have your data model / tables like fm_erp_interface_ar.

But I can have a look just need to rewrite the query.

Hi Filipe,
can you provide a simple test case ... a test.jrxml file?
Thank you.

Hi Peter,

please check: https://github.com/daust/JasperReportsIntegration/blob/main/src/doc/github/installation-full.md#install.installation.installDB

There is a script to install the ACLs for your schema.

Best
~Dietmar.

Hi Peter,

this is difficult to troubleshoot.

I would recommend to download the latest version and upgrade as per instructions: https://github.com/daust/JasperReportsIntegration/blob/main/src/doc/github/installation-upgrade.md

If you should encounter a...

It works. Please see: https://github.com/daust/JasperReportsIntegration/blob/main/src/doc/github/installation-full.md / section 2.3 Configure your database access for details:

Hi Fayas,

great, that you could figure it out yourself.

Yes, you also have to activate the printing in the application.properties file as well (this is done for obvious security reasons):

#============================================================...

Hi Fayas,

please send me a message via email to dietmar.aust@opal-consulting.de, then we can schedule a quick look.

Thanks
~Dietmar.

Hi Bala,

JRI tries to recompile the .jrxml file into .jasper and hits a compilation problem:

Offending resource: URL [jar:file:/u01/app/tomcat/apache-tomcat-9.0.29/webapps/jri/WEB-INF/lib/jasperreports-chart-themes-6.16.0.jar!/net/sf/jasperreports/...

Wonderful, glad it works now.

Keep in mind, when you deploy files (source .jrxml and compiled .jasper file) the timestamps will be checked. If the .jrxml is newer than the .jasper file OR the .jasper files does not exist, the .jrxml will be used and t...

Don't see any issue.

Please

• post the url that is generated (without the hostname for security)
• run the test.jrxml which is included in the distribution
• post a screenshot of the output
• post the logfile from rendering the test.jrxml

Thankx

Hi @charlyschmid,

with that little information, it is really hard to troubleshoot. Could be so many different issues, even typos.

Typically, the report is sent to the queue ... things can go wrong from there.

In order to troubleshoot, I would

...

Hi @LSoriana,

please pardon my late response.

Did you figure it out?
If not, please do also post a screenshot of the output from the printer diagnostics.
Also, check the logfile on the Tomcat, i.e. catalina.out, if you can see anything there.

Thank you~Di...