US and Worldwide: +1 (866) 660-7555
Results 1 to 7 of 7

Thread: Exception: pos 64 exceeds capacity 64

  1. #1
    Join Date
    Dec 2009
    Posts
    11

    Default Exception: pos 64 exceeds capacity 64

    Hi all,

    I get the following exception, when trying to use a rather huge (18 dimensions) OLAP Cube:

    JPivot had an error ...


    javax.servlet.jsp.JspException: java.lang.IllegalArgumentException: pos 64 exceeds capacity 64

    javax.servlet.jsp.JspException: java.lang.IllegalArgumentException: pos 64 exceeds capacity 64
    at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:86)
    [...]
    Caused by: java.lang.IllegalArgumentException: pos 64 exceeds capacity 64
    at mondrian.rolap.BitKey$Small.set(BitKey.java:436)
    at mondrian.rolap.RolapCubeLevel.init(RolapCubeLevel.java:118)
    at mondrian.rolap.RolapHierarchy.init(RolapHierarchy.java:349)
    Has anyone got an idea what to change or to adjust to avoid this exception?

    I'm looking forward to your answers and would be really happy if anyone could help me.

    Kind regards,
    Matt

  2. #2
    Join Date
    Dec 2009
    Posts
    11

    Default

    Hi there,

    has no one an idea how to cope with this error? I'd be really grateful!

    Best regards,
    Matt

  3. #3
    Join Date
    Mar 2011
    Posts
    140

    Default

    Perhaps you should post your mdx query so people can review it ?

  4. #4

    Default

    I would suggest running your SQL generated by Mondrian directly in the db first to confirm nothing is wrong with the table schema itself.

  5. #5
    Join Date
    Dec 2009
    Posts
    11

    Default

    Thank you very much for your suggestions!

    According to my MySQL Log, there is no SQL generated by Mondrian in this case. (At least not one single query that contains any of the corresponding table-names.) Thus I cannot test, whether the SQL works outside Mondrian.

    Here is the MDX:
    Code:
    select Hierarchize(Union(Crossjoin({[Measures].[Count]}, {[Process Chain Interoperability].[All Process Chain Interoperabilitys]}), Crossjoin({[Measures].[Count]}, [Process Chain Interoperability].[All Process Chain Interoperabilitys].Children))) ON COLUMNS, Hierarchize(Union({[Type of the Research Result].[All Type of the Research Results]}, [Type of the Research Result].[All Type of the Research Results].Children)) ON ROWS from [research_result]
    And this is the Schema File:
    Code:
    <?xml version="1.0"?>
    <Schema name="research_result">
        <Cube name="research_result" cache="true" enabled="true">
            <Table name="fact_research_result_3205"/>
            <Dimension name="Process Chain Interoperability" caption="Prozessketteninteroperabilit&#xE4;t" foreignKey="dim_29">
                <Hierarchy hasAll="true" allMemberCaption="Alle Prozessketteninteroperabilit&#xE4;t" primaryKey="tid">
                    <Table name="dim_3205_29"/>
                    <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                        <Closure parentColumn="parent" childColumn="child">
                            <Table name="dim_3205_29_closure"/>
                        </Closure>
                    </Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="Type of the Research Result" caption="Forschungsergebnistyp" foreignKey="dim_18">
                <Hierarchy hasAll="true" allMemberCaption="Alle Forschungsergebnistyp" primaryKey="tid">
                    <Table name="dim_3205_18"/>
                    <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                        <Closure parentColumn="parent" childColumn="child">
                            <Table name="dim_3205_18_closure"/>
                        </Closure>
                    </Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="Level of Realisation" caption="Forschungsstatus" foreignKey="dim_3">
                <Hierarchy hasAll="true" allMemberCaption="Alle Forschungsstatus" primaryKey="tid">
                    <Table name="dim_3205_3"/>
                    <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                        <Closure parentColumn="parent" childColumn="child">
                            <Table name="dim_3205_3_closure"/>
                        </Closure>
                    </Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="Phases of Process Management" caption="Phasen des Prozessmanagements" foreignKey="dim_30">
                <Hierarchy hasAll="true" allMemberCaption="Alle Phasen des Prozessmanagements" primaryKey="tid">
                    <Table name="dim_3205_30"/>
                    <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                        <Closure parentColumn="parent" childColumn="child">
                            <Table name="dim_3205_30_closure"/>
                        </Closure>
                    </Level>
                </Hierarchy>
            </Dimension>
            <Dimension name="Operational Use / Experience" caption="Praxiserprobung bzw. -einsatz" foreignKey="dim_6">
            <Hierarchy hasAll="true" allMemberCaption="Alle Praxiserprobung bzw. -einsatz" primaryKey="tid">
                <Table name="dim_3205_6"/>
                <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                    <Closure parentColumn="parent" childColumn="child">
                        <Table name="dim_3205_6_closure"/>
                    </Closure>
                </Level>
            </Hierarchy>
        </Dimension>
        <Dimension name="Addressed Companies" caption="Adressierte Unternehmen" foreignKey="dim_27">
            <Hierarchy hasAll="true" allMemberCaption="Alle Adressierte Unternehmen" primaryKey="tid">
                <Table name="dim_3205_27"/>
                <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                    <Closure parentColumn="parent" childColumn="child">
                        <Table name="dim_3205_27_closure"/>
                    </Closure>
                </Level>
            </Hierarchy>
        </Dimension>
        <Dimension name="Field of Research" caption="Forschungsfeld" foreignKey="dim_28">
            <Hierarchy hasAll="true" allMemberCaption="Alle Forschungsfeld" primaryKey="tid">
                <Table name="dim_3205_28"/>
                <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                    <Closure parentColumn="parent" childColumn="child">
                        <Table name="dim_3205_28_closure"/>
                    </Closure>
                </Level>
            </Hierarchy>
        </Dimension>
        <Dimension name="Practice Sectors" caption="Anwendungsbranchen" foreignKey="dim_9">
            <Hierarchy hasAll="true" allMemberCaption="Alle Anwendungsbranchen" primaryKey="tid">
                <Table name="dim_3205_9"/>
                <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                    <Closure parentColumn="parent" childColumn="child">
                        <Table name="dim_3205_9_closure"/>
                    </Closure>
                </Level>
            </Hierarchy>
        </Dimension>
        <Dimension name="Standardisation" caption="Standardisierungsverfahren/-organisation" foreignKey="dim_10">
        <Hierarchy hasAll="true" allMemberCaption="Alle Standardisierungsverfahren/-organisation" primaryKey="tid">
        <Table name="dim_3205_10"/>
        <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
            <Closure parentColumn="parent" childColumn="child">
                <Table name="dim_3205_10_closure"/>
            </Closure>
        </Level>
    </Hierarchy>
    </Dimension>
    <Dimension name="Objective of Research" caption="Ziel des Forschungsergebnisses" foreignKey="dim_23">
        <Hierarchy hasAll="true" allMemberCaption="Alle Ziel des Forschungsergebnisses" primaryKey="tid">
            <Table name="dim_3205_23"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_23_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Relevance" caption="Fachlichkeit" foreignKey="dim_24">
        <Hierarchy hasAll="true" allMemberCaption="Alle Fachlichkeit" primaryKey="tid">
            <Table name="dim_3205_24"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_24_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Relevance to Federal / Laender Level" caption="Fachlichkeit auf Bundes- und Landesebene" foreignKey="dim_33">
    <Hierarchy hasAll="true" allMemberCaption="Alle Fachlichkeit auf Bundes- und Landesebene" primaryKey="tid">
        <Table name="dim_3205_33"/>
        <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
            <Closure parentColumn="parent" childColumn="child">
                <Table name="dim_3205_33_closure"/>
            </Closure>
        </Level>
    </Hierarchy>
    </Dimension>
    <Dimension name="Process Chain Extract" caption="Prozesskettenausschnitt" foreignKey="dim_25">
        <Hierarchy hasAll="true" allMemberCaption="Alle Prozesskettenausschnitt" primaryKey="tid">
            <Table name="dim_3205_25"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_25_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Addressed Directive" caption="Adressierte Richtlinien und Verordnungen" foreignKey="dim_26">
        <Hierarchy hasAll="true" allMemberCaption="Alle Adressierte Richtlinien und Verordnungen" primaryKey="tid">
            <Table name="dim_3205_26"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_26_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Relevance to Communal Level" caption="Fachlichkeit auf kommunaler Ebene" foreignKey="dim_34">
        <Hierarchy hasAll="true" allMemberCaption="Alle Fachlichkeit auf kommunaler Ebene" primaryKey="tid">
            <Table name="dim_3205_34"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_34_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Value Chain" caption="Wertfluss" foreignKey="dim_35">
        <Hierarchy hasAll="true" allMemberCaption="Alle Wertfluss" primaryKey="tid">
            <Table name="dim_3205_35"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_35_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Standards" caption="Standards" foreignKey="dim_36">
        <Hierarchy hasAll="true" allMemberCaption="Alle Standards" primaryKey="tid">
            <Table name="dim_3205_36"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_36_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Dimension name="Perspective" caption="Perspektivenintegration" foreignKey="dim_37">
        <Hierarchy hasAll="true" allMemberCaption="Alle Perspektivenintegration" primaryKey="tid">
            <Table name="dim_3205_37"/>
            <Level name="Dimension ID" column="tid" nameColumn="name" ordinalColumn="weight" parentColumn="parent" nullParentValue="0" uniqueMembers="true" captionColumn="caption">
                <Closure parentColumn="parent" childColumn="child">
                    <Table name="dim_3205_37_closure"/>
                </Closure>
            </Level>
        </Hierarchy>
    </Dimension>
    <Measure name="Count" column="nid" aggregator="distinct count" caption="Anzahl"/>
    </Cube>
    </Schema>
    I'd be happy if anyone has got further ideas.

    Best regards,
    Matt

  6. #6
    Join Date
    Sep 2011
    Posts
    26

    Default

    I am facing the same error. I am running Pentaho BI Server CE 3.8 and you can reproduce it by creating a cube with 24 or more dimensions (my case), one of them being a parent-child. When you create a new analysis view and pentaho tries to load the initial query, it gives an error. If there are other cubes in the schema, they won't work either.

    The funny thing is that if you remove the parent-child dimension, it works. And if you keep the parent-child but you reduce the number of dimensions to 23 (including the parent-child) it also works.

    Any ideas, workaround?
    Last edited by xgumara; 12-23-2011 at 07:48 AM.

  7. #7
    Join Date
    Nov 2010
    Posts
    17

    Default

    It seems that this is fixed in Mondrian 3.4, may I know which class this was fixed? I am using Mondrian 3.3 and I couldn't upgrade it to 3.4. I am thinking of copying the fix into 3.3.

    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •