When you try to create big PDF files in OBIEE after a certain size you will get an error like:
A fatal error occurred while processing the request. The server responded with: Error while executing PDFRpcCall.processMessage com.siebel.analytics.utils.InputStreamWithLimit$ReadOverTheLimitException at com.siebel.analytics.utils.InputStreamWithLimit.incTotalBytes(InputStreamWithLimit.java:58) at ...............
Basicly it means that the FOP processor is running out of workspace. The workspace is controlled from the instanceconfig.xml JavaHost part. Instead of enlarging the default value of 1024 kb you could also consider setting this to unlimited.
<JavaHost>
<PDF>
<InputStreamLimitInKB>0</InputStreamLimitInKB>
</PDF>
</JavaHost>
Till next Time
13 comments:
Hi,
if we want to adjust the width of a certain column, where we can change it?
Thanks
Daniela, Portugal
Hi Daniela,
Formatting of the PDF documents is controlled both css and fst control files. Best you define the column widt in your report.
regards John
John,
Do you know if there's a similar setting for excel document size?
Thanks,
Kyle
Hi Kyle
The number of rows to excel are controlled by DefaultRowsDisplayedInDownload Tag
and the version of excel you are using. Formatting Excell is pretty dogdy since OBIEE uses MHTML as trasportformat.
regards John
Hi John,
thanks for your answer. But the problem is in the report the column it's fine, but when I export/print to PDF the column turns smaller.
Thanks,
Daniela
Hi Daniela,
Did try editing the FST file? This controls the PDF rendering.
regards John
Hi John,
I tried to change in pdfstyle.fst and in the pivot.fst but i don't understand where exactly I have to change the width of the columns. I only could change the padding and borders size.
Thanks, Daniela
Hi Daniela,
I just checked the CSS width is dominant to the FST width. Try adding the width "hard coded" in the report column properties or add it to custom.css.
regards
John
Hi John,
I get the following message when trying to PDF an 11 page dashboard I created recently:
"Sax parser returned an exception. Message: Expected entity name for reference, Entity publicId: , Entity systemId: , Line number: 9218, Column number: 29
Error Details
Error Codes: UH6MBRBC"
Is this related? Any ideas?
Thanks for your help!
Hi Tom,
Please check if your .NET framework is up to date. Also create an SR with Oracle, there might be an patch availible.
regards
Thanks John,
I actually managed to find out that the error message was a result of having static text in one of the queries containing a "&".
Hopefully this has been patched.
Hi, we are seeing the following error in sawserver.out.log while starting obi after a fersh install of 10.1.3.4.1
[Util Logger] Exception occured:
Severity:Not set
Type:PKN3saw9ExceptionE
File:/net/sdchs20n530/vol1/users/anabuild/views/nightly/Tue/101341/SS_Linux/vobs/090414.1900/analytics_web/main/project/webxml/saxreader.cpp
Line:559
Message:Sax parser returned an exception.
Message: Expected an element name, Entity publicId: //oracleBIdata/web/config/instanceconfig.xml, Entity systemId: , Line number: 5, Column number: 80
Appreciate your help. Thanks.
@Anonymous,
Looks like you instanceconfig is corupt.
regards
John
Post a Comment