Skip to Content
author's profile photo Former Member
Former Member

Get error "com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: An error occured while exporting the report---- Error code:-2147467259 Error code name:failed"

Post Author: dkm1982

CA Forum: JAVA

Hi Friends,

I have a web application which uses Crystal to generate reports with Oracle as the database. The Crystal exports report in PDF format and writes this report into a temporary file on Server. It runs perfectly in development environment. But in Production where data in database reaches large volume like 100 million, I get following error:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: An error occured while exporting the report---- Error code:-2147467259 Error code name:failed

Please suggest clue to find the sollution. Is it possible that reason some thing other than large amount of data?

Thank you. Best Regards, Deepak

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2008 at 08:48 AM

    Post Author: prakash_kishan

    CA Forum: JAVA

    Hi,

    I am also facing the same problem. I think this is due to memory

    shortage\memory is not getting released..., Some changes to be done at

    CMS setup. As a temproary solution, you can restart RAS each time this problem occurs. but it needs to be automated when you run SDK.

    Hope some BO experts will give solution to this issue...Regards,Prakash.K

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I am also facing similar issue. I tried to generate report. The report pulls 498000 records from database. The Report generation gets failed after 3 minutes. The records were pulled from database with in 30 seconds.

      Crytal Report Runtime version - 11.8.8.1541

      Java version - IBM Java 1.6.0.

      The report only getting failed in AIX environment , in windows this works fine and a report of size 30 MB got created.

      Thhe Exception stack trace does not give clear direction to the root cause.

      Please help me to resolve this issue.

      Regards

      Jyothish

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2012 at 01:40 PM

    Hi,

    Have you tried to use the recent runtimes to test the application? here is the link:

    http://downloads.businessobjects.com/akdlm/crystalreportsforeclipse/2_0/crjava-runtime_12.2.214.zip

    Also which type of connectivity used to connect to the database?

    In case you are using a JDBC connection, you can try to increase the heapsize (JVMMaxHeap) through the CRConfig.xml and see how it goes (default location of CRConfig.xml in windows is: C:\Program Files\Business Objects\Common\4.0\java).

    This configuration file contains some other parameters that you can try also such as JavaServerTimeout. For more info about the tag(s) in CRConfig.xml, refer to:

    http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/en/JRC_SDK/jrc_java_dg_doc/doc/jrcsdk_java_dg/CRDBJavaServer_Ref2.html#60055

    The last thing you can do is to log4j your application to check the backgroung processing of the report.

    Here is a sample log4j.properties:

    #==============================================================

    # To change this template, choose Tools | Templates
    # and open the template in the editor.
    # log4j.properties

    # Default log location
    log4j.debug = true
    log4j.rootLogger=DEBUG, A1
    #crystal.logs.home=C:/jrclog

    log4j.appender.A1=org.apache.log4j.RollingFileAppender
    # number of log files to keep before deleting the oldest one
    log4j.appender.A1.MaxBackupIndex=30
    log4j.appender.A1.MaxFileSize=500KB
    log4j.appender.A1.ImmediateFlush = true
    log4j.appender.A1.Threshold = DEBUG
    log4j.appender.A1.file=C:/jrclog/jpe.log
    #log4j.appender.jpeAppender.file=${crystal.logs.home}/jpe.log
    #log4j.appender.jpeAppender.file=./jpe.log
    # Log message layout: date-time [thread] priority category - message lineTerminator
    log4j.appender.A1.layout=org.apache.log4j.PatternLayout
    log4j.appender.A1.layout.ConversionPattern=%d{dd MMM yyyy HH:mm:ss} [%t] %-5p %c - %m%n

    # ---> More specific loggers can go here
    # Log levels used by Log4j in ascending order are:
    # debug, info, warn, error, and fatal
    # Covers all of the reporting engine
    log4j.logger.com.crystaldecisions.reports=DEBUG, A1
    log4j.logger.com.crystaldecisions.threedg=DEBUG, A1
    log4j.logger.com.crystaldecisions.common=DEBUG, A1
    # Examples
    log4j.logger.com.crystaldecisions.reports.formulas=DEBUG, A1

    #=============================================================

    Thanks

    Alphonse

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Since the JRC uses the System property of the Java Virtual Machine (JVM) to determine the location of the temp directory, what if you specify that in your code using this statement:

      System.setProperty("java.io.tmpdir","your temporary directory here");

      Thanks

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.