RAS SDK : limit to amount of data for export?

[Former Member]

Hi all,

I've encountered a problem with a crystal report that I'm refreshing and exporting to xls with the java RAS SDK.

Depending on the value of the parameters, I'm getting 1, 65 or 339 pages after the refresh.

When I'm trying to export the report with few pages (1 or 65 for example), no problem. But with the report of 339 pages, I'm getting an exception and an error (Cannot create temp file : generic error) at that line :

InputStream byteIS = (InputStream) crystalDocument.getPrintOutputController().export(neededFormat);

If I'm refreshing and exporting the report with InfowView, I've no problem and my excel file contains a little bit more than 22.000 lines.

So my question is :

- Is there any value I need to change to admit more lines?

- Is there any attributes I need to set in one particular object?

Thanks in advance !

[Former Member · Accepted solution]

Solution to the problem here :

Increase the value in the ReportApplicationServer Services in the CMC for "Number of database records to read when previewing or refreshing a report". In my case I put 30000 and it was sufficient.

The value -1 is possible but not recommended for performance.

[Former Member]

Precision : it's not depending on the file type, it's going wrong with xls AND pdf export :s But only when there is a lot of data.

[aasavaribhave]

Try increasing java heap size on RAS server:

Locate CRConfig.xml and the JVMMax and Min Heap entries. 

<JVMMaxHeap>64000000</JVMMaxHeap>

<JVMMinHeap>32000000</JVMMinHeap>

Try 128 MB for max, try varying this number and see if that helps.

[Former Member]

Do I have to put this file somewhere specially?

[aasavaribhave]

You don't have to put this file anywhere. It should be on your server where BOE\BI is installed at:

XI 3.1

Windows Installations: <Business Objects Home>\common\4.0\java

AIX\ Linux\ Unix\ Solaris Installations: <BOBJ Home>/bobje/java

BI 4.0

Windows Installations: <Business Objects Home>\SAP BusinessObjects Enterprise XI 4.0\java

AIX\ Linux\ Unix\ Solaris Installations: <BOBJ Home>/bobje/java

[Former Member]

Does it need a restart of BO?

[Former Member]

I tried to change the value in the indicated file and restart the BO services but no change in the problem :s.

[Former Member]

I tried with 128 and 256 Mo for the Max (and 512)