3 Replies Latest reply: Nov 11, 2012 8:46 AM by dbcapoeira RSS

    I encountered a bag in Column Selector

    skulll.r
      I do any Column Selector and have error INVALID_EXPRESSION_ERR: DOM XPath Exception 51.
      I use BI EE 11.1.1.6.1
      The reports that worked in 11.1.1.5 are not workin in 11.1.1.6

      Does anybody encountere the same problem?
        • 1. Re: I encountered a bag in Column Selector
          dbcapoeira
          I have the exact same error. Since this is a new implementation for us, 11.1.1.6, don't have any history of this ever working. Mine error occurs in the Headcount Demographics section on the HR Analytics.
          • 2. Re: I encountered a bag in Column Selector
            FPT ERP Team
            I meet a same error today, anybody help me ?? :(
            • 3. Re: I encountered a bag in Column Selector
              dbcapoeira
              You will need to modify your config.xml and instanceconfig.xml files. Then go into OEM and max out the setting for these two sections:
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDownload>140000</DefaultRowsDisplayedInDownload>
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

              Instanceconfig.xml: Find the <Views> section and try these values ->
              <Views>
              <Pivot>
              <!--Start Added by XXXX 10-30-2012 -->

              <MaxCells>4000000</MaxCells>
              <MaxVisibleRows>140000</MaxVisibleRows>
              <!--End Added by XXXX 10-30-2012 -->

              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDownload>140000</DefaultRowsDisplayedInDownload>
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DisableAutoPreview>false</DisableAutoPreview>
              </Pivot>
              <Table>
              <!--Start Added by XXXX 10-30-2012 -->
              <MaxCells>4000000</MaxCells>
              <MaxVisibleRows>140000</MaxVisibleRows>
              <!--End Added by XXXX 10-30-2012 -->

              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
              <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
              <DefaultRowsDisplayedInDownload>140000</DefaultRowsDisplayedInDownload>
              </Table>
              <!--Start Added by XXXX 10-30-2012 -->
              <Charts>
              <MaxVisibleColumns>2000</MaxVisibleColumns>
              <MaxVisiblePages>1000</MaxVisiblePages>
              <MaxVisibleRows>140000</MaxVisibleRows>
              <MaxVisibleSections>25</MaxVisibleSections>
              <JavaHostReadLimitInKB>8192</JavaHostReadLimitInKB>
              </Charts>
              <Cube>
              <CubeMaxRecords>5000000</CubeMaxRecords>
              <CubeMaxPopulatedCells>15000000</CubeMaxPopulatedCells>
              </Cube>
              <!--End Added by XXXX 10-30-2012 -->
              </Views>


              config.xml
              <XMLP>
              <InputStreamLimitInKB>819200</InputStreamLimitInKB>
              <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>
              </XMLP>


              <DVT>
              <InputStreamLimitInKB>819200</InputStreamLimitInKB>
              </DVT>