Skip to Content
avatar image
Former Member

Crystal report locking out DB account

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 13, 2015 at 04:02 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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