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 !
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.
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.
Do I have to put this file somewhere specially?
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
Does it need a restart of BO?
I tried to change the value in the indicated file and restart the BO services but no change in the problem :s.
I tried with 128 and 256 Mo for the Max (and 512)
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.