Dietmar Aust

daust ·

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...

Hi Tullio,

yes. It will work with pretty much any APEX version because it is "just" a pl/sql API that communicates with the J2EE server running the custom war file jri.war.

There is an APEX test application, though. This application helps you to chec...

Hi @msami07,

I designed the integration for a single Oracle db-connection, your use case is not expected.
Can you use database links to your SQL Server database? This is the typical workaround in those cases in the "Oracle world".

• https://duckdu...

Ah ok. Thank you for the clarification. :thumbsup:

Good that you have it working but I don't understand what you have changed and how you are running it.
Anyhow, glad you could fix it.

Best
~Dietmar.