This discussion is archived
3 Replies Latest reply: Nov 11, 2012 6:46 AM by dbcapoeira RSS

I encountered a bag in Column Selector

skulll.r Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I meet a same error today, anybody help me ?? :(
  • 3. Re: I encountered a bag in Column Selector
    dbcapoeira Newbie
    Currently Being Moderated
    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points