11 Replies Latest reply on Apr 12, 2017 5:25 AM by Arūnas

    OBIEE 11g; Export to PDF blank page

    Johan (South Africa)

      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. Re: OBIEE 11g; Export to PDF blank page
          Madasamy-Oracle

          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

          • 2. Re: OBIEE 11g; Export to PDF blank page
            Johan (South Africa)

            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

            • 3. Re: OBIEE 11g; Export to PDF blank page
              Johan (South Africa)

              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

              • 4. Re: OBIEE 11g; Export to PDF blank page
                FTisiot

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

                I would also check javahost for errors

                • 5. Re: OBIEE 11g; Export to PDF blank page
                  Johan (South Africa)

                  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

                  • 6. Re: OBIEE 11g; Export to PDF blank page
                    Madasamy-Oracle

                    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

                     

                     

                    • 7. Re: OBIEE 11g; Export to PDF blank page
                      Johan (South Africa)

                      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

                      • 8. Re: OBIEE 11g; Export to PDF blank page
                        Johan (South Africa)

                        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

                        • 9. Re: OBIEE 11g; Export to PDF blank page
                          Sherry George

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

                          • 10. Re: OBIEE 11g; Export to PDF blank page
                            Johan (South Africa)

                            This issue has been resolved.

                            • 11. Re: OBIEE 11g; Export to PDF blank page
                              Arūnas

                              Could You please share the solution?