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

[Former Member]

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

[Former Member]

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/jrcsd...

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

[Former Member]

Thanks Alphose!

The log4j configuration that you had shared was helpful to trace the issue.

Issue

The /tmp folder in the AIX  box did not had enough space. The report generation was getting failed when the Crytal Report tried to write the Temoprary rpt file.

Solution

We had increased the /tmp size to 1GB and the report got generated.

Once gain thanks for the help!

Regards

Jyothish

[Former Member]

Good to hear that.

Thanks

Alphonse

[Former Member]

Hi Alphonse,

I would like to Extende this discussion.

At present the CrystalReport Runtime uses the 'temp' folder of the underlying Operating System.

Is it possible to configure a different application 'temp' foldder? If possible where can configure this?

Regards

Jyothish

[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

[Former Member]

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

[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