Friday, January 9, 2009

OBIEE creating large / huge PDF documents

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:

Anonymous said...

Hi,

if we want to adjust the width of a certain column, where we can change it?
Thanks
Daniela, Portugal

John Minkjan said...

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

Unknown said...

John,

Do you know if there's a similar setting for excel document size?

Thanks,
Kyle

John Minkjan said...

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

Anonymous said...

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

John Minkjan said...

Hi Daniela,

Did try editing the FST file? This controls the PDF rendering.

regards John

Anonymous said...

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

John Minkjan said...

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

Tom Loveday said...

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!

John Minkjan said...

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

Tom Loveday said...

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.

Anonymous said...

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.

John Minkjan said...

@Anonymous,

Looks like you instanceconfig is corupt.

regards

John