[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1089
  • Last Modified:

Openreports error while running query reports

Error on Query reports

I am getting the following errors while opening a report which contains a simple query.
(database is mysql and its jdbc driver is already added)
 
javax.servlet.ServletException: /QueryReport.jsp(36,59) Attribute value report.getName() + ".pdf" is quoted with " which must be escaped when used within the value
 
My system specifications
 
OS- RHEL 5
Java - 1.6 jdk
apache- tomcat 5.5

The same openreports work on my centos 5 distribution without any troubles.
 
Please help me to fix it as soon as possible.
 
 
Regards,
 
Alias
0
crapidontwant
Asked:
crapidontwant
  • 4
  • 2
1 Solution
 
UmeshCommented:
Set the value of org.apache.jasper.compiler. Parser.STRICT_QUOTE_ESCAPING to false in Apache Tomcat configuration.

Thanks,
Umesh
0
 
crapidontwantAuthor Commented:
Thanks for your steps.

Can u give the file name on which this should be done?

I check my server.xml file and didn't find a keywork you mentioned.


Regards,

Alias
0
 
UmeshCommented:
I'm not 100% sure where to add.. locate setenv.sh and see if they are any settings then add accordingly

-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
to setenv.sh

or

org.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false
to setenv.sh.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
crapidontwantAuthor Commented:
yes, I add
CATALINA_OPTS=-Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false variable on catalina.sh file and openreports can now query the output.

Thanks for your valuable input.

Regards,

Alias
0
 
UmeshCommented:
Anytime..

Thanks,
Umesh
0
 
UmeshCommented:
From the author comments it seems my comments helped him(11.18.2008 at 05:01PM IST, ID: 22983569)

Thanks,
Umesh
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now