search

daust / JasperReportsIntegration

JasperReportsIntegration provides an interface to use the JasperReports reporting engine in an Oracle database application, specifically with Oracle Application Express (Oracle APEX).
BSD 3-Clause "New" or "Revised" License
55 stars 23 forks source link

Error when running from APEX 21.2.8 #120

Closed rv8470 closed 1 year ago

rv8470 commented 1 year ago

Hello,

I am trying to get the kit working on our environment. We have SSL security and the check runs fine. When I want to execute it from an APEX app the system comes back with an error: Error: SyntaxError: Unexpected token '<', " <!-- Copyr"... is not valid JSON Not sure what is wrong here. We are using Tomcat 9 with JDK 17 on windows server 2019. See for more details some screen shots attached.

Regards, JasperReportsIntegrationError.pdf

Rob

rv8470 commented 1 year ago

Solved it by using http settings instead of https

daust commented 1 year ago

This is strange, was this the only thing you changed, switching from https to http? It looks a little bit like the issue when pages are not submitted but only processed using an AJAX call.

Setting the page configuration parameter Reload on Submit = Always fixes that ... but causes issues with Interactive Grids for example. image

daust commented 1 year ago

Hi Rob, I did just check in my environment and it all works with https. Can you test it using https and then run one of the demo reports? Thank you.

Like this: image

image

image

rv8470 commented 1 year ago

Hi Dietmar,

Thanks for your replies.

In the first place I started with the generation of PDF outputs using PL/SQL, that was fixed with the http setting. The other issue with the APEX error was indeed fixed by the "Reload on Submit" setting for displaying the output in the browser. I was informed by another developer, he had experienced the same issue.

So it's working fine now

Thanks

daust commented 1 year ago

Wonderful. Glad that you have it working now :)