Extra Pages

▼

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

at

13 comments:

  1. AnonymousJanuary 9, 2009 at 6:17 PM

    Hi,

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

    ReplyDelete
  2. John MinkjanJanuary 9, 2009 at 9:24 PM

    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

    ReplyDelete
  3. UnknownJanuary 9, 2009 at 10:29 PM

    John,

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

    Thanks,
    Kyle

    ReplyDelete
  4. John MinkjanJanuary 9, 2009 at 11:04 PM

    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

    ReplyDelete
  5. AnonymousJanuary 12, 2009 at 7:00 PM

    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

    ReplyDelete
  6. John MinkjanJanuary 12, 2009 at 7:18 PM

    Hi Daniela,

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

    regards John

    ReplyDelete
  7. AnonymousJanuary 12, 2009 at 7:40 PM

    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

    ReplyDelete
  8. John MinkjanJanuary 12, 2009 at 9:41 PM

    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

    ReplyDelete
  9. Tom LovedayJune 16, 2010 at 6:33 PM

    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!

    ReplyDelete
  10. John MinkjanJune 17, 2010 at 7:42 AM

    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

    ReplyDelete
  11. Tom LovedayJune 18, 2010 at 11:10 AM

    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.

    ReplyDelete
  12. AnonymousFebruary 24, 2011 at 4:16 PM

    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.

    ReplyDelete
  13. John MinkjanFebruary 25, 2011 at 9:43 AM

    @Anonymous,

    Looks like you instanceconfig is corupt.

    regards

    John

    ReplyDelete

Note: Only a member of this blog may post a comment.