Miscellaneous exception jpivot.tags.OlapModelProxy

[sampathku]

I have a simple schema xml and a simple OLAP query

select {[Measures].[Ticket Count]} on columns, {[Product Category].[All Product Categories]} on ROWS from [TroubleTicket]

 

When I execute the analysis, I get the following excepton. There is no error pointing to my MDX syntax. Any pointers would be really helpful.

javax.servlet.jsp.el.ELException: An error occurred while getting property "result" from an instance of class com.tonbeller.jpivot.tags.OlapModelProxy

 

Thanks,

Sampath

Code:

<?xml version="1.0"?><Schema name="Ticket">	<Dimension name="Call Type">		<Hierarchy hasAll="true" primaryKey="CALLTYPECODE">			<Table name="calltype"/>			<Level name="Call Type Name" column="CALLTYPENAME" uniqueMembers="true"/>			<!-- Level name="Call Type Descr" column="CALLTYPEDESC" uniqueMembers="true"/ -->		</Hierarchy>	</Dimension>	<Dimension name="Product Category">		<Hierarchy hasAll="true" allMemberName="All Product Categories" primaryKey="PRODUCTCATEGORYCODE">			<Table name="productcategory"/>			<Level name="Product Category Name" column="PRODUCTCATEGORYCODENAME" uniqueMembers="true"/>			<!-- Level name="Product Category Descr" column="PRODUCTCATEGORYCODEDESC" uniqueMembers="true"/ -->		</Hierarchy>	</Dimension>		<Dimension name="Trouble Ticket">		<Hierarchy hasAll="true" primaryKey="TICKETID">			<Table name="troubleticket"/>			<Level name="Date Opened" column="WHENOPENED" uniqueMembers="false"/>			<!-- <Level name="Ticket Title" column="TITLE" uniqueMembers="true"/>			<Level name="Priority" column="PRIORITY" uniqueMembers="true"/>			<Level name="Equipment Name" column="EQUIPMENTTYPENAME" uniqueMembers="true"/>			<Level name="Ticket Status" column="TICKETSTATUSDESC" uniqueMembers="true"/> -->		</Hierarchy>	</Dimension>		<Cube name="TroubleTicket">		<Table name="troubleticket"/>		<DimensionUsage name="Trouble Ticket" source="Trouble Ticket" foreignKey="TICKETID"/>		<DimensionUsage name="Call Type" source="Call Type" foreignKey="CALLTYPECODE"/>		<DimensionUsage name="Product Category" source="Product Category" foreignKey="PRODUCTCATEGORYCODE"/>		<Measure name="Ticket Count" column="TICKETID" aggregator="count" formatString="#,###"/>	</Cube></Schema>

[swood]

Did this work in the schema workbench?

 

If the schema does work in the workbench, can you restart the server and try again? There may be some caching issues.

 

Sherman

Jaspersoft