[Mondrian] Error in Role (Mondrian 2.4)

[miguel]

What so.

I have already located the problem and in fact if he is bug in they
mondrian; after reviewing my data base, schema, the permissions, the
consultations and logs,
finally I found that the problem was the consultation that towards
within the file .jsp, which is: 

SELECT
NON EMPTY { [Etapa].Members } ON COLUMNS,
NON EMPTY { [Rutas] } ON ROWS
FROM [Oportunidad]

Testing several encontre that: 

----- FAULT -----
SELECT
NON EMPTY { [Etapa] } ON COLUMNS,
NON EMPTY { [Rutas] } ON ROWS
FROM [Oportunidad]

----- FAULT -----
SELECT
NON EMPTY { [Etapa].Members } ON COLUMNS,
NON EMPTY { [Rutas] } ON ROWS
FROM [Oportunidad]

--------------------------------------------------------------

----- OK -----
SELECT
NON EMPTY { [Etapa].Members } ON COLUMNS,
NON EMPTY { [Rutas].Members } ON ROWS
FROM [Oportunidad]

----- OK -----
SELECT
NON EMPTY { [Etapa] } ON COLUMNS,
NON EMPTY { [Rutas].Members } ON ROWS
FROM [Oportunidad]

The version of mondrian is: Mondrian 2.4.
The servant of applications that use is: Apache Tomcat 6.0.10.
The version of java is: JDK1.6.0.
The data base is: PostreSQL 8.1.

I hope that this can be used for being able to repair the problem.


El mar, 07-08-2007 a las 20:37 -0500, miguel escribió:
> What so I am updating of mondrian 2,2 to mondrian 2.4.
> My problem appears in the section of roles of my exquema, I I have: 
> 
>  <Dimension name="Force of Sales" caption="%{Opportunity.dimension.3}">
>   <Hierarchy hasAll="false" primaryKey="repr">
>    <Table name="forcesales"/>
>    <Level name="Nivel_0" column="nivel_0" ordinalColumn="nivel_0"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
>    <Level name="Nivel_1" column="nivel_1" ordinalColumn="nivel_1"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
>    <Level name="Nivel_2" column="nivel_2" ordinalColumn="nivel_2"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
>    <Level name="Nivel_3" column="nivel_3" ordinalColumn="nivel_3"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
>    <Level name="Nivel_4" column="nivel_4" ordinalColumn="nivel_4"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="false"/>
>    <Level name="Nivel_5" column="nivel_5" ordinalColumn="nivel_5"
> type="String" hideMemberIf="IfBlankName" uniqueMembers="true"/>
>   </Hierarchy>
>  </Dimension>
> 
> With the next role:
> 
>   <Role name="D000"><!--DIRECTOR-->							
>    <SchemaGrant access="none">
>      <CubeGrant cube="Opportunity" access="all">
> 	 <HierarchyGrant hierarchy="[Force of Sales]" access="custom"
> topLevel="[Force of Sales].[Nivel_1]">
>       <MemberGrant member="[Force of Sales].[ADMINGRAL].[DIRECTOR]"
> access="all"/>
> 	 </HierarchyGrant>
> 	</CubeGrant>						
>    </SchemaGrant>							
>   </Role> 	
> 
> This works well in mondrian 2.2; now in the 2,4 this same one causes the
> following error to me: 
> 
>  javax.servlet.ServletException: javax.servlet.jsp.JspTagException: 
>  javax.servlet.jsp.JspException:
>  An error occurred while evaluating custom action attribute "test" with
> value "${query01.result.overflowOccured}":
>  An error occurred while getting property "result" from an instance of
> class com.tonbeller.jpivot.tags.OlapModelProxy
> (java.lang.NullPointerException)
> 
> I have already updated other cubes and they have not caused any problem
> to me in this section of roles; this cube presents east problem of
> isolated form,
> reason why I was checking by enough short while that the error was not
> mine, but have not been able to locate it or is bug in this version of
> mondrian.
> When I modify the roll and I leave it thus:
> 
>   <Role name="D000"><!--DIRECTOR-->							
>    <SchemaGrant access="none">
>      <CubeGrant cube="Opportunity" access="all">
> 	 <HierarchyGrant hierarchy="[Force of Sales]" access="custom"
> topLevel="[Force of Sales].[Nivel_0]">
>       <MemberGrant member="[Force of Sales].[ADMINGRAL]" access="all"/>
> 	 </HierarchyGrant>
> 	</CubeGrant>						
>    </SchemaGrant>							
>   </Role> 	
> 
> It works well, but adding more levels no.
> Here my table: 
> 
>   nivel_0  | nivel_1  |    nivel_2     |    nivel_3     |  nivel_4  |
> nivel_5  | representantes 
> -----------+----------+----------------+----------------+-----------+----------+----------------
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | PROYECTOS |
> PROY001  | PROY001
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | VENTAS    |
> VTA001   | VTA001
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
> ID001    | ID001
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
> ID002    | ID002
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
> ID003    | ID003
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | INV_DES   |
> ID004    | ID004
>  ADMINGRAL | DIRECTOR | ---            | ---            | ---       |
> D000     | D000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | ---            | ---       |
> A000     | A000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | SOPORTE        | ---       |
> SREAD    | SREAD
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | ---       |
> PROYREAD | PROYREAD
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | ---       |
> VTAREAD  | VTAREAD
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | ---       |
> STAFF000 | STAFF000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | DISTRIBUIDORES | ---       |
> DIST000  | DIST000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | INV_DES_LEC    | ---       |
> IDREAD   | IDREAD
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | MONTERREY      | ---       |
> MTY000   | MTY000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | SOPORTE        | SOP001    |
> SOP001   | SOP001
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | PROYECTOS LEC  | PROYECTOS |
> PROY000  | PROY000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | VENTAS LEC     | VENTAS    |
> VTA000   | VTA000
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | STAFF001  |
> STAFF001 | STAFF001
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | STAFF          | STAFF002  |
> STAFF002 | STAFF002
>  ADMINGRAL | DIRECTOR | ADMINISTRACION | DISTRIBUIDORES | DIST001   |
> DIST001  | DIST001
> 
> I have already checked until the fatigue the roles, even single leaving
> this of isolated form and trying to be able to see beyond nivel_0.
> Somebody can say please to me that I must check or although this if he
> is bug? 
> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian