on 01-13-2015 4:36 AM
Hi,
We have a few crystal reports which we are displaying on jsp(Crystal Reports Viewer) page. Some of the crystal reports are locking out the DB account while trying to render the report and its occuring randomly. I have following code in my jsp and the account gets locked out when a call is made to processHttpRequest method.
//Create the CrystalReportViewer object
com.crystaldecisions.report.web.viewer.CrystalReportViewer crystalReportViewer = new com.crystaldecisions.report.web.viewer.CrystalReportViewer();
crystalReportViewer.setDatabaseLogonInfos(connections);
//Set the reportsource property of the viewer
crystalReportViewer.setReportSource(reportSource);
//Set viewer attributes
crystalReportViewer.setOwnPage(true);
crystalReportViewer.setOwnForm(true);
crystalReportViewer.setEnableParameterPrompt(false);
crystalReportViewer.refresh();
//Set the CrystalReportViewer print mode
crystalReportViewer.setPrintMode(com.crystaldecisions.report.web.viewer.CrPrintMode.PDF);
crystalReportViewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);
We are using Crystal Reports XI and using the eclipse plugin to set the datasource values for the reports. The reports are connecting to Oracle 11g database.
Any help in overcoming this issue is really appreciated.
Hi Ajay
Problem is that CR XI (assumption is that you are meaning v. 11.0.x(?), never supported Oracle 11 g.
Your best bet is to download the latest CR from here:
http://www.businessobjects.com/campaigns/forms/downloads/crystal/eclipse/datasave.asp
and see how that works out for you.
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
OK. So let's now go back to square one. The following will need to be defined a bit more:
Some of the crystal reports are locking out the DB account while trying to render the report and its occuring randomly.
If it is some of the reports, what is the difference? Look at the tables / SPs the reports use. Subreport differences?
Define randomly. E.g.; do some reports work consistently, some cause lock at random times?
How is the lock exhibited? Errors? Behavior?
- Ludek
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.