Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g; Export to PDF blank page

Received Response
101
Views
11
Comments
Johan (South Africa)
Johan (South Africa) Rank 3 - Community Apprentice

Hi all

I am exporting a OBIEE 11.1.1.7 dashboard page to PDF by making use of the Print -> Printable PDF functionality. The export however results in one blank page.

The dashboard page consists of 2 pivots. One is +- 300 lines and the other +- 10 lines across 8 columns. So the data volumes are not large at all.

The smaller of the two pivots exports to PDF without any issues. This means that volume is the issue.

We have another environment where the export works and I have duplicated all parameters in the <pivot> tag in the InstanceConfig.xml file to the environment where it does not work and restart the BIServer and Presentation Services components but with no success.

I do not see any errors being reported in the Presentations Services log file.

Does anyone know where else I can investigate this issue? Below is an extract of the Pivot tag in the InstanceConfig.xml file.

<Pivot>

<!-- This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control -->

<DefaultRowsDisplayedInDelivery>40000</DefaultRowsDisplayedInDelivery>

<!-- This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control -->

<DefaultRowsDisplayedInDownload>100000</DefaultRowsDisplayedInDownload>

<!-- This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control -->

<DisableAutoPreview>false</DisableAutoPreview>

<MaxVisibleColumns>50000</MaxVisibleColumns>

<MaxVisiblePages>1048400</MaxVisiblePages>

<MaxVisibleRows>500000</MaxVisibleRows>

<MaxCells>1500000</MaxCells>

<MaxVisibleSections>55000</MaxVisibleSections>

</Pivot>

Thank you

Johan

«1

Answers

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    Hello,

    the PDF generation will be submitted to javahost.Can you check the config.xml and xdo.cfg between your servers and match them in case of any differences and try the same.

    If not, you may raise xdodebug.cfg ( google it or KM it ) and trace the javahost during the export and see if there is any error helps us on this.

    -M

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    Hi Madasamy

    Thank you for the reply and your insight.

    Which OBIEE components do I need to restart if I make changes tot the config.xml file. Only the BI Java Host component?

    Regards

    Johan

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    Hi Madasamy

    I will enable xdodebug and send the output files. This seems to be a BIPublisher file. I am experiencing the issue in OBIEE Analytics.

    Regards

    Johan

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    Johan, as already suggested you may need to look in config.xml and restart obijh1

    I would also check javahost for errors

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    I changed the config.xml file to be the same as the one on the environment where the export to PDF is working. It has however not resolved the issue.

       <XMLP>

          <InputStreamLimitInKB>1048400</InputStreamLimitInKB>

          <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing>

       </XMLP>

    The previous value was:      <InputStreamLimitInKB>65536</InputStreamLimitInKB>

    We have also changed the BI Java Host log level to Finest but no errors are reported in the JH.log file when I do the export to PDF.

    Any other suggestions?

    Johan

  • Madasamy -Oracle
    Madasamy -Oracle Rank 6 - Analytics Lead

    Try the below and let us know

    #1 config.xml

    <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB>

    <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP>

    #2 xdo.cfg

    <property name="xlsx-keep-values-in-same-column">true</property>

    And do a restart, check the same.

    You may have to enable xdocebug as mentioned earlier to check the xdo errors

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    Hi Madasamy

    I edited the config.xml file and made the changes as suggested:

    <XMLP> <InputStreamLimitInKB>0</InputStreamLimitInKB>

    <ReadRequestBeforeProcessing>false</ReadRequestBeforeProcessing></XMLP


    In xdo.cfg I also ensured that the below tag was set to true:

    <property name="xlsx-keep-values-in-same-column">true</property>

    I restarted.

    I enabled xdodebug and the 3 files have been created.

    The out file (pdf) is blank as expected.

    The xdo.log file content is below. I don't see any errors, only warnings:

    .

    [031517_153957490][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153957492][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153957494][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor constructor is called.

    [031517_153957775][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor has been initialized without default config.

    [031517_153957775][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.setData(InputStream) is called.

    [031517_153957778][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.setTemplate(InputStream)is called.

    [031517_153957779][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.setConfig(String) is called with '/u01/app/oracle/product/fmw/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/xdo.cfg'.

    [031517_153957781][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.setOutput(OutputStream)is called.

    [031517_153957781][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.setOutputFormat(byte)is called with ID=1.

    [031517_153957951][oracle.xdo.template.FOProcessor][PROCEDURE] Use TMP Directory '/var/tmp' from XDO property 'system-temp-dir'.

    [031517_153957952][oracle.xdo.template.FOProcessor][STATEMENT] Start Memory: max=7680MB, total=7680MB, free=6881MB

    [031517_153957952][oracle.xdo.template.FOProcessor][STATEMENT] FOProcessor.generate() called.

    [031517_153957953][oracle.xdo.template.FOProcessor][STATEMENT]    Log file 'xdo_031517_153957953_fo_out_8debb.out' is created.

    [031517_153957955][oracle.xdo.template.FOProcessor][STATEMENT]    Log file 'xdo_031517_153957953_fo_data_1_.xml' is created.

    [031517_153958033][oracle.xdo.template.fo.FOProcessingEngine][STATEMENT] Using proxy for PDF Generator

    [031517_153958048][oracle.xdo.template.FOProcessor][STATEMENT] Calling FOProcessingEngine.process()

    [031517_153958295][oracle.xdo.common.formula2.impl.DefaultContext][STATEMENT] Missing country code in locale, use country code from JVM default locale.

    [031517_153958296][oracle.xdo.common.formula2.impl.DefaultContext][STATEMENT] Missing country code from JVM default locale. Use USD as currency.

    [031517_153958429][][STATEMENT] Using standard xslt

    [031517_153958499][][STATEMENT] WARNING: Found undetermined AttrKey: xmlns:xml

    [031517_153958521][][STATEMENT] [ PDF GENERATOR ]---------------------------------------------

    [031517_153958522][][STATEMENT] XDO version   = Oracle BI Publisher 11.1.1.7.141014

    [031517_153958523][][STATEMENT] java.home     = /u01/app/oracle/product/fmw/Oracle_BI1/jdk/jre

    [031517_153958524][][STATEMENT] java.version  = 1.6.0_35

    [031517_153958525][][STATEMENT] XDO_TOP       = null

    [031517_153958526][][STATEMENT] Config Path   = null

    [031517_153958526][][STATEMENT] Debug Cfg Path= /u01/app/oracle/product/fmw/Oracle_BI1/jdk/jre/lib/xdodebug.cfg

    [031517_153958527][][STATEMENT] Font dir      = /u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/

    [031517_153958528][][STATEMENT] Locale        = en

    [031517_153958529][][STATEMENT] Fallback font = type1.Helvetica

    [031517_153958530][][STATEMENT] [ PDF GENERATOR PROPERTIES ]----------------------------------

    [031517_153958549][][STATEMENT] digit-substitution=null(not set)

    [031517_153958550][][STATEMENT] font.ALBANY WT J.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTJ.ttf

    [031517_153958551][][STATEMENT] font.ALBANY WT K.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTK.ttf

    [031517_153958552][][STATEMENT] font.ALBANY WT SC.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTS.ttf

    [031517_153958553][][STATEMENT] font.ALBANY WT TC.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTT.ttf

    [031517_153958553][][STATEMENT] font.ALBANY WT.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANYWT.ttf

    [031517_153958554][][STATEMENT] font.ANDALE DUOSPACE WT J.normal.bold=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOJB.ttf

    [031517_153958555][][STATEMENT] font.ANDALE DUOSPACE WT J.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOJ.ttf

    [031517_153958556][][STATEMENT] font.ANDALE DUOSPACE WT K.normal.bold=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOKB.ttf

    [031517_153958557][][STATEMENT] font.ANDALE DUOSPACE WT K.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOK.ttf

    [031517_153958558][][STATEMENT] font.ANDALE DUOSPACE WT SC.normal.bold=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOSCB.ttf

    [031517_153958559][][STATEMENT] font.ANDALE DUOSPACE WT SC.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOSC.ttf

    [031517_153958559][][STATEMENT] font.ANDALE DUOSPACE WT TC.normal.bold=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOTCB.ttf

    [031517_153958560][][STATEMENT] font.ANDALE DUOSPACE WT TC.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOTC.ttf

    [031517_153958561][][STATEMENT] font.ANDALE DUOSPACE WT.normal.bold=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUOB.ttf

    [031517_153958562][][STATEMENT] font.ANDALE DUOSPACE WT.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ADUO.ttf

    [031517_153958563][][STATEMENT] font.CG TIMES.italic.bold=type1.Times-BoldItalic

    [031517_153958564][][STATEMENT] font.CG TIMES.italic.normal=type1.Times-Italic

    [031517_153958565][][STATEMENT] font.CG TIMES.normal.bold=type1.Times-Bold

    [031517_153958565][][STATEMENT] font.CG TIMES.normal.normal=type1.Times-Roman

    [031517_153958566][][STATEMENT] font.COURIER NEW.italic.bold=type1.Courier-BoldOblique

    [031517_153958567][][STATEMENT] font.COURIER NEW.italic.normal=type1.Courier-Oblique

    [031517_153958568][][STATEMENT] font.COURIER NEW.normal.bold=type1.Courier-Bold

    [031517_153958569][][STATEMENT] font.COURIER NEW.normal.normal=type1.Courier

    [031517_153958570][][STATEMENT] font.COURIER.italic.bold=type1.Courier-BoldOblique

    [031517_153958571][][STATEMENT] font.COURIER.italic.normal=type1.Courier-Oblique

    [031517_153958571][][STATEMENT] font.COURIER.normal.bold=type1.Courier-Bold

    [031517_153958572][][STATEMENT] font.COURIER.normal.normal=type1.Courier

    [031517_153958573][][STATEMENT] font.DEFAULT.italic.bold=type1.Helvetica-BoldOblique

    [031517_153958574][][STATEMENT] font.DEFAULT.italic.normal=type1.Helvetica-Oblique

    [031517_153958575][][STATEMENT] font.DEFAULT.normal.bold=type1.Helvetica-Bold

    [031517_153958576][][STATEMENT] font.DEFAULT.normal.normal=type1.Helvetica

    [031517_153958576][][STATEMENT] font.GLFALLBACK.normal.normal=truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTJ.ttf

    [031517_153958577][][STATEMENT] font.HELVETICA.italic.bold=type1.Helvetica-BoldOblique

    [031517_153958578][][STATEMENT] font.HELVETICA.italic.normal=type1.Helvetica-Oblique

    [031517_153958579][][STATEMENT] font.HELVETICA.normal.bold=type1.Helvetica-Bold

    [031517_153958580][][STATEMENT] font.HELVETICA.normal.normal=type1.Helvetica

    [031517_153958581][][STATEMENT] font.MONOSPACE.italic.bold=type1.Courier-BoldOblique

    [031517_153958582][][STATEMENT] font.MONOSPACE.italic.normal=type1.Courier-Oblique

    [031517_153958582][][STATEMENT] font.MONOSPACE.normal.bold=type1.Courier-Bold

    [031517_153958583][][STATEMENT] font.MONOSPACE.normal.normal=type1.Courier

    [031517_153958584][][STATEMENT] font.SANS-SERIF.italic.bold=type1.Helvetica-BoldOblique

    [031517_153958585][][STATEMENT] font.SANS-SERIF.italic.normal=type1.Helvetica-Oblique

    [031517_153958586][][STATEMENT] font.SANS-SERIF.normal.bold=type1.Helvetica-Bold

    [031517_153958587][][STATEMENT] font.SANS-SERIF.normal.normal=type1.Helvetica

    [031517_153958588][][STATEMENT] font.SERIF.italic.bold=type1.Times-BoldItalic

    [031517_153958588][][STATEMENT] font.SERIF.italic.normal=type1.Times-Italic

    [031517_153958589][][STATEMENT] font.SERIF.normal.bold=type1.Times-Bold

    [031517_153958590][][STATEMENT] font.SERIF.normal.normal=type1.Times-Roman

    [031517_153958591][][STATEMENT] font.SYMBOL.normal.normal=type1.Symbol

    [031517_153958592][][STATEMENT] font.TIMES NEW ROMAN.italic.bold=type1.Times-BoldItalic

    [031517_153958593][][STATEMENT] font.TIMES NEW ROMAN.italic.normal=type1.Times-Italic

    [031517_153958593][][STATEMENT] font.TIMES NEW ROMAN.normal.bold=type1.Times-Bold

    [031517_153958594][][STATEMENT] font.TIMES NEW ROMAN.normal.normal=type1.Times-Roman

    [031517_153958595][][STATEMENT] font.TIMES.italic.bold=type1.Times-BoldItalic

    [031517_153958596][][STATEMENT] font.TIMES.italic.normal=type1.Times-Italic

    [031517_153958597][][STATEMENT] font.TIMES.normal.bold=type1.Times-Bold

    [031517_153958598][][STATEMENT] font.TIMES.normal.normal=type1.Times-Roman

    [031517_153958599][][STATEMENT] font.ZAPFDINGBATS.normal.normal=type1.ZapfDingbats

    [031517_153958599][][STATEMENT] hide-bip-version-number=false

    [031517_153958600][][STATEMENT] pdf-changes-allowed=0

    [031517_153958601][][STATEMENT] pdf-compression=true

    [031517_153958602][][STATEMENT] pdf-document-title=null(not set)

    [031517_153958603][][STATEMENT] pdf-dvt-no-opacity-no-gradient-shading=false

    [031517_153958603][][STATEMENT] pdf-enable-accessibility=true

    [031517_153958604][][STATEMENT] pdf-enable-copying=false

    [031517_153958605][][STATEMENT] pdf-encryption-level=2

    [031517_153958606][][STATEMENT] pdf-font-embedding=true

    [031517_153958607][][STATEMENT] pdf-hide-menubar=false

    [031517_153958608][][STATEMENT] pdf-hide-toolbar=false

    [031517_153958609][][STATEMENT] pdf-include-creation-and-mod-date=false

    [031517_153958610][][STATEMENT] pdf-no-accff=false

    [031517_153958610][][STATEMENT] pdf-no-cceda=false

    [031517_153958611][][STATEMENT] pdf-no-changing-the-document=false

    [031517_153958612][][STATEMENT] pdf-no-printing=false

    [031517_153958613][][STATEMENT] pdf-number-of-copies=1

    [031517_153958614][][STATEMENT] pdf-open-password=

    [031517_153958615][][STATEMENT] pdf-pagemode=null(not set)

    [031517_153958616][][STATEMENT] pdf-permissions=0

    [031517_153958617][][STATEMENT] pdf-permissions-password=

    [031517_153958618][][STATEMENT] pdf-print-duplex=None

    [031517_153958619][][STATEMENT] pdf-print-scaling=AppDefault

    [031517_153958620][][STATEMENT] pdf-printing-allowed=0

    [031517_153958621][][STATEMENT] pdf-replace-smartquotes=true

    [031517_153958622][][STATEMENT] pdf-security=false

    [031517_153958623][][STATEMENT] pdf-use-one-resources=true

    [031517_153958624][][STATEMENT] pdf-version=0.0

    [031517_153958625][][STATEMENT] ------------------------------------------------------

    [031517_153958639][][STATEMENT] WARNING: Found undetermined AttrKey: desiredWidth

    [031517_153958654][][STATEMENT] WARNING: Found undetermined AttrKey: minimumContent

    [031517_153958655][][STATEMENT] WARNING: Found undetermined AttrKey: percent

    [031517_153958705][][STATEMENT] WARNING: Found undetermined AttrKey: NumberOfRows

    [031517_153958723][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153958723][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153958804][][STATEMENT] startDocument

    [031517_153958806][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153958807][][EXCEPTION] Created new paragraph

    [031517_153958815][][STATEMENT] endDocument: pos=40

    [031517_153958816][][STATEMENT] Writing current object: name=p

    [031517_153958839][][STATEMENT] WARNING: Found undetermined AttrKey: negative_number

    [031517_153958954][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153958956][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153958959][][STATEMENT] startDocument

    [031517_153958960][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153958961][][EXCEPTION] Created new paragraph

    [031517_153958961][][STATEMENT] endDocument: pos=40

    [031517_153958962][][STATEMENT] Writing current object: name=p

    [031517_153959215][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153959217][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153959222][][STATEMENT] startDocument

    [031517_153959224][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153959225][][EXCEPTION] Created new paragraph

    [031517_153959227][][STATEMENT] endDocument: pos=40

    [031517_153959229][][STATEMENT] Writing current object: name=p

    [031517_153959564][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153959565][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153959610][][STATEMENT] startDocument

    [031517_153959612][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153959614][][EXCEPTION] Created new paragraph

    [031517_153959616][][STATEMENT] endDocument: pos=40

    [031517_153959617][][STATEMENT] Writing current object: name=p

    [031517_153959711][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153959712][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153959717][][STATEMENT] startDocument

    [031517_153959719][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153959721][][EXCEPTION] Created new paragraph

    [031517_153959723][][STATEMENT] endDocument: pos=40

    [031517_153959725][][STATEMENT] Writing current object: name=p

    [031517_153959874][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_153959876][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_153959881][][STATEMENT] startDocument

    [031517_153959884][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_153959885][][EXCEPTION] Created new paragraph

    [031517_153959887][][STATEMENT] endDocument: pos=40

    [031517_153959889][][STATEMENT] Writing current object: name=p

    [031517_154000117][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000118][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000122][][STATEMENT] startDocument

    [031517_154000124][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000126][][EXCEPTION] Created new paragraph

    [031517_154000127][][STATEMENT] endDocument: pos=40

    [031517_154000129][][STATEMENT] Writing current object: name=p

    [031517_154000314][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000315][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000320][][STATEMENT] startDocument

    [031517_154000322][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000324][][EXCEPTION] Created new paragraph

    [031517_154000325][][STATEMENT] endDocument: pos=40

    [031517_154000327][][STATEMENT] Writing current object: name=p

    [031517_154000430][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000432][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000437][][STATEMENT] startDocument

    [031517_154000439][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000441][][EXCEPTION] Created new paragraph

    [031517_154000443][][STATEMENT] endDocument: pos=40

    [031517_154000445][][STATEMENT] Writing current object: name=p

    [031517_154000529][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000531][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000537][][STATEMENT] startDocument

    [031517_154000539][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000541][][EXCEPTION] Created new paragraph

    [031517_154000543][][STATEMENT] endDocument: pos=40

    [031517_154000544][][STATEMENT] Writing current object: name=p

    [031517_154000599][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000602][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000672][][STATEMENT] startDocument

    [031517_154000675][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000676][][EXCEPTION] Created new paragraph

    [031517_154000678][][STATEMENT] endDocument: pos=40

    [031517_154000680][][STATEMENT] Writing current object: name=p

    [031517_154000760][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000762][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000767][][STATEMENT] startDocument

    [031517_154000776][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000778][][EXCEPTION] Created new paragraph

    [031517_154000781][][STATEMENT] endDocument: pos=40

    [031517_154000783][][STATEMENT] Writing current object: name=p

    [031517_154000853][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000855][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000859][][STATEMENT] startDocument

    [031517_154000861][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000863][][EXCEPTION] Created new paragraph

    [031517_154000876][][STATEMENT] endDocument: pos=40

    [031517_154000878][][STATEMENT] Writing current object: name=p

    [031517_154000932][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000933][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000938][][STATEMENT] startDocument

    [031517_154000940][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000941][][EXCEPTION] Created new paragraph

    [031517_154000943][][STATEMENT] endDocument: pos=40

    [031517_154000944][][STATEMENT] Writing current object: name=p

    [031517_154000974][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154000976][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154000982][][STATEMENT] startDocument

    [031517_154000985][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154000987][][EXCEPTION] Created new paragraph

    [031517_154000989][][STATEMENT] endDocument: pos=40

    [031517_154000991][][STATEMENT] Writing current object: name=p

    [031517_154001078][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154001080][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154001085][][STATEMENT] startDocument

    [031517_154001087][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154001089][][EXCEPTION] Created new paragraph

    [031517_154001091][][STATEMENT] endDocument: pos=40

    [031517_154001093][][STATEMENT] Writing current object: name=p

    [031517_154001198][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154001200][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154001205][][STATEMENT] startDocument

    [031517_154001207][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154001209][][EXCEPTION] Created new paragraph

    [031517_154001211][][STATEMENT] endDocument: pos=40

    [031517_154001213][][STATEMENT] Writing current object: name=p

    [031517_154001241][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154001243][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154001249][][STATEMENT] startDocument

    [031517_154001267][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154001269][][EXCEPTION] Created new paragraph

    [031517_154001270][][STATEMENT] endDocument: pos=40

    [031517_154001272][][STATEMENT] Writing current object: name=p

    [031517_154001362][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154001364][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154001379][][STATEMENT] startDocument

    [031517_154001382][][STATEMENT] characters: Subscriber Base and Movements Enterprise, pos=0

    [031517_154001383][][EXCEPTION] Created new paragraph

    [031517_154001385][][STATEMENT] endDocument: pos=40

    [031517_154001387][][STATEMENT] Writing current object: name=p

    [031517_154001396][][STATEMENT] Logger.init(): *** DEBUG MODE IS ON. ***

    [031517_154001397][][STATEMENT] Logger.init(): LogDir=/export/home/oracle/SCRIPTS/templogs

    [031517_154001401][][STATEMENT] startDocument

    [031517_154001403][][STATEMENT] characters: Price Plan Category, pos=0

    [031517_154001405][][EXCEPTION] Created new paragraph

    [031517_154001407][][STATEMENT] endDocument: pos=19

    [031517_154001408][][STATEMENT] Writing current object: name=p

    [031517_154001629][oracle.xdo.template.fo.elements.FormattingEngine][STATEMENT]  Rendering page [1]

    [031517_154001785][oracle.xdo.common.font.FontFactory$FontDef][STATEMENT] Type1 font created: Helvetica

    [031517_154001861][oracle.xdo.common.font.FontFactory$FontDef][STATEMENT] TrueType font created: /u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTJ.ttf(0)

    [031517_154001945][][STATEMENT] ImageReader:PNG

    [031517_154001965][oracle.xdo.common.image.PNGImageDecoder][STATEMENT] W:31,H:31,BD:8,CT:6,CM:0,FM:0,IM:0

    [031517_154001972][][STATEMENT] ImageReader:PNG

    [031517_154001973][oracle.xdo.common.image.PNGImageDecoder][STATEMENT] W:31,H:31,BD:8,CT:6,CM:0,FM:0,IM:0

    [031517_154001982][oracle.xdo.common.image.PNGImageDecoder][STATEMENT] IDAT: 1 chunk(s), 2324 bytes

    [031517_154002016][oracle.xdo.common.font.FontFactory$FontDef][STATEMENT] Type1 font created: Helvetica-Bold

    [031517_154003876][oracle.xdo.template.fo.elements.FormattingEngine][STATEMENT] Phase2 time used: 2423 msecs

    [031517_154003878][oracle.xdo.template.fo.elements.FormattingEngine][STATEMENT]  Continue rendering page [1]

    [031517_154003881][][STATEMENT]  Generating page [1]

    [031517_154005006][oracle.xdo.template.fo.elements.FormattingEngine][STATEMENT] Phase2 time used: 1128 msecs

    [031517_154005010][][STATEMENT] Total time used: 6568ms for processing XSL-FO

    [031517_154005097][oracle.xdo.common.font.FontFactory][STATEMENT] type1.Helvetica closed.

    [031517_154005097][oracle.xdo.common.font.FontFactory][STATEMENT] type1.Helvetica-Bold closed.

    [031517_154005098][oracle.xdo.common.font.FontFactory][STATEMENT] truetype./u01/app/oracle/product/fmw/Oracle_BI1/common/fonts/ALBANWTJ.ttf closed.

    [031517_154005099][oracle.xdo.template.FOProcessor][PROCEDURE] FO+Gen time used: 7051 msecs

    [031517_154005100][oracle.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) is called.

    [031517_154005101][oracle.xdo.template.FOProcessor][STATEMENT] clearInputs(Object) done. All inputs are cleared.

    [031517_154005101][oracle.xdo.template.FOProcessor][STATEMENT] End Memory: max=7680MB, total=7680MB, free=6819MB

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    Hi Madasamy

    I created a new analysis with only one column selected and I still get the same issue so it is not an issue specific to the previous analysis, e.g. formatting, font etc.

    Any other suggestions from your side?

    Regards

    Johan

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Just a suggestion, could you check if the pdf reader versions are same between the environments ?

  • Johan (South Africa)
    Johan (South Africa) Rank 3 - Community Apprentice

    This issue has been resolved.