[Mondrian] mondrian.rolap.RolapMemberBase cannot be cast tomondrian.rolap.RolapCubeMember
Martijn van den Broek
mjbroek at gmail.com
Mon Nov 22 11:24:44 EST 2010
Attached is some more debug info with backtrace from when the request is
received till the exception occurs. I hope anyone can help us identifying
the problem.
On Fri, Nov 19, 2010 at 11:10 AM, Martijn van den Broek
<mjbroek at gmail.com>wrote:
> Ok i managed to reproduce various times on different platforms using the
> following instructions. I hope you have time to check it out and give us
> feedback what we are doing wrong.. or is it a bug?
>
> * Download and unzip
> http://ws1.clusterix.basesoft.com/~martijn/mondrian/testcase.zip
> * If not done already install tomcat, mondrian and libmysql-java (mysql
> jdbc)
> * If not done already install mysql jdbc driver into tomcat.. for ubuntu
> this is:
> cp /usr/share/java/mysql-connector-java.jar /var/lib/tomcat6/lib/
> * Import turnover.sql into mysql:
> cat turnover.sql | mysql -u root -p
> * Copy (or edit) datasources.xml from testcase to mondrian (be sure to set
> the correct database password):
> cp datasources.xml
> /var/lib/tomcat-6/webapps/mondrian/WEB-INF/datasources.xml
> * Copy turnover cube to mondrian:
> cp turnover.xml
> /var/lib/tomcat-6/webapps/mondrian/WEB-INF/queries/turnover.xml
> * Restart tomcat or reload datasources
> * Run testcase a few times:
> python test_xmla.py
>
> That should give the output:
> exception: The Mondrian XML: mondrian.rolap.RolapMemberBase cannot be cast
> to mondrian.rolap.RolapCubeMember (code: 00HSBE03)
>
>
> On Thu, Nov 18, 2010 at 5:12 PM, Martijn van den Broek <mjbroek at gmail.com>wrote:
>
>> Yeah first thing we tried. It seems the same message indeed. However we
>> have either explicit or default set the
>> mondrian.rolap.EnableRolapCubeMemberCache=true in properties.
>>
>> Is there anything else we can try? How can I give more debug information?
>> I'm still trying to get a testcase together that demonstrates the issue.
>>
>>
>> On Thu, Nov 18, 2010 at 4:55 PM, Julian Hyde <jhyde at pentaho.com> wrote:
>>
>>> Did you search jira for this issue? There are similar ones, e.g.
>>> http://jira.pentaho.com/browse/MONDRIAN-762
>>>
>>> ------------------------------
>>> *From:* mondrian-bounces at pentaho.org [mailto:
>>> mondrian-bounces at pentaho.org] *On Behalf Of *Martijn van den Broek
>>> *Sent:* Thursday, November 18, 2010 12:49 AM
>>> *To:* mondrian at pentaho.org
>>> *Subject:* [Mondrian] mondrian.rolap.RolapMemberBase cannot be cast
>>> tomondrian.rolap.RolapCubeMember
>>>
>>> Hello,
>>>
>>> We are running a mondrian server with multiple datasources configured.
>>> The XMLA protocol is used to execute MDX queries against mondrian with a
>>> simple HTTP client written in python. This all works really well till at
>>> some point the mondrian server wont execute anymore and returns with the
>>> following exception:
>>>
>>> mondrian.rolap.RolapMemberBase cannot be cast to
>>> mondrian.rolap.RolapCubeMember (code: 00HSBE03)
>>>
>>> From that point on we cannot execute the same MDX over XMLA till we clear
>>> the mondrian cache and restart the tomcat server. While XMLA is still broken
>>> we can however execute the MDX successfully in JPivot. Does this mean its a
>>> XMLA problem? Another thing we noticed is that some dimensions are not
>>> accessable anymore if we execute MDSCHEMA_HIERARCHIES.
>>>
>>> The WEB-INF/mondrian.properties has the default config and changing the
>>> 'mondrian.rolap.EnableRolapCubeMemberCache' to true or false doesnt change
>>> the behaviour.
>>>
>>> We are working on a testcase to reproduce the problem but it seems very
>>> hard to trigger. Any suggestions on how to debug this issue are welcome.
>>> Thanks in advance.
>>>
>>>
>>> --
>>> Martijn van den Broek
>>>
>>>
>>> _______________________________________________
>>> Mondrian mailing list
>>> Mondrian at pentaho.org
>>> http://lists.pentaho.org/mailman/listinfo/mondrian
>>>
>>>
>>
>>
>> --
>> Martijn van den Broek
>>
>
>
>
> --
> Martijn van den Broek
>
--
Martijn van den Broek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20101122/c615c087/attachment.html
-------------- next part --------------
0 [http-8080-1] WARN mondrian.xmla.XmlaServlet - Use default character encoding from HTTP client
85 [http-8080-1] WARN mondrian.rolap.RolapUtil - Mondrian: Warning: JDBC driver org.hsqldb.jdbcDriver not found
85 [http-8080-1] WARN mondrian.rolap.RolapUtil - Mondrian: Warning: JDBC driver oracle.jdbc.OracleDriver not found
392 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - RolapSchema.load: content:
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="turnover" >
<Cube name="Omzet gegevens"><Table name="tblTurnover" /><Dimension foreignKey="branch_id" name="Branch"><Hierarchy allMemberName="All Branch" defaultMember="[All Branch]" hasAll="true" primaryKey="id"><Table name="tblBranch" /><Level column="branch" name="Branch" /></Hierarchy></Dimension><Dimension foreignKey="participant_id" name="Deelnemers"><Hierarchy allMemberName="All Deelnemers" defaultMember="[All Deelnemers]" hasAll="true" primaryKey="id"><Table name="tblParticipant" /><Level column="participant" name="Organisatie" /></Hierarchy></Dimension><Dimension foreignKey="product_id" name="Categorie"><Hierarchy allMemberName="All Categorie" defaultMember="[All Categorie]" hasAll="true" primaryKey="id"><Table name="tblProduct" /><Level column="category" name="Categorie" /><Level column="product" name="Product" /></Hierarchy></Dimension><Dimension foreignKey="time_id" name="Tijd"><Hierarchy allMemberName="All Tijd" defaultMember="[All Tijd]" hasAll="true" primaryKey="id"><Table name="tblTime" /><Level column="year" name="Jaar" /><Level column="quarter" name="Kwartaal" /></Hierarchy></Dimension><Measure aggregator="sum" column="turnover" formatString="##.####,##" name="Omzet" /></Cube>
</Schema>
392 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - RolapSchema.load: content:
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="turnover" >
<Cube name="Omzet gegevens"><Table name="tblTurnover" /><Dimension foreignKey="branch_id" name="Branch"><Hierarchy allMemberName="All Branch" defaultMember="[All Branch]" hasAll="true" primaryKey="id"><Table name="tblBranch" /><Level column="branch" name="Branch" /></Hierarchy></Dimension><Dimension foreignKey="participant_id" name="Deelnemers"><Hierarchy allMemberName="All Deelnemers" defaultMember="[All Deelnemers]" hasAll="true" primaryKey="id"><Table name="tblParticipant" /><Level column="participant" name="Organisatie" /></Hierarchy></Dimension><Dimension foreignKey="product_id" name="Categorie"><Hierarchy allMemberName="All Categorie" defaultMember="[All Categorie]" hasAll="true" primaryKey="id"><Table name="tblProduct" /><Level column="category" name="Categorie" /><Level column="product" name="Product" /></Hierarchy></Dimension><Dimension foreignKey="time_id" name="Tijd"><Hierarchy allMemberName="All Tijd" defaultMember="[All Tijd]" hasAll="true" primaryKey="id"><Table name="tblTime" /><Level column="year" name="Jaar" /><Level column="quarter" name="Kwartaal" /></Hierarchy></Dimension><Measure aggregator="sum" column="turnover" formatString="##.####,##" name="Omzet" /></Cube>
</Schema>
413 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - RolapSchema.load: dump xmlschema
Schema
name = "turnover"
description = null
measuresCaption = null
defaultRole = null
annotations: null
parameters: array of 0 values
dimensions: array of 0 values
cubes: array of 1 values
cubes[0]: Cube
name = "Omzet gegevens"
caption = null
description = null
defaultMeasure = null
cache = "true"
enabled = "true"
annotations: null
fact: Table
name = "tblTurnover"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
dimensions: array of 4 values
dimensions[0]: Dimension
type = null
usagePrefix = null
foreignKey = "branch_id"
highCardinality = "false"
name = "Branch"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Branch"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Branch]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblBranch"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 1 values
levels[0]: Level
approxRowCount = null
name = "Branch"
table = null
column = "branch"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[1]: Dimension
type = null
usagePrefix = null
foreignKey = "participant_id"
highCardinality = "false"
name = "Deelnemers"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Deelnemers"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Deelnemers]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblParticipant"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 1 values
levels[0]: Level
approxRowCount = null
name = "Organisatie"
table = null
column = "participant"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[2]: Dimension
type = null
usagePrefix = null
foreignKey = "product_id"
highCardinality = "false"
name = "Categorie"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Categorie"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Categorie]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblProduct"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 2 values
levels[0]: Level
approxRowCount = null
name = "Categorie"
table = null
column = "category"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
levels[1]: Level
approxRowCount = null
name = "Product"
table = null
column = "product"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[3]: Dimension
type = null
usagePrefix = null
foreignKey = "time_id"
highCardinality = "false"
name = "Tijd"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Tijd"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Tijd]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblTime"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 2 values
levels[0]: Level
approxRowCount = null
name = "Jaar"
table = null
column = "year"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
levels[1]: Level
approxRowCount = null
name = "Kwartaal"
table = null
column = "quarter"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
measures: array of 1 values
measures[0]: Measure
name = "Omzet"
column = "turnover"
datatype = null
formatString = "##.####,##"
aggregator = "sum"
formatter = null
caption = null
description = null
visible = null
annotations: null
measureExp: null
memberProperties: array of 0 values
calculatedMembers: array of 0 values
namedSets: array of 0 values
virtualCubes: array of 0 values
namedSets: array of 0 values
roles: array of 0 values
userDefinedFunctions: array of 0 values
413 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - RolapSchema.load: dump xmlschema
Schema
name = "turnover"
description = null
measuresCaption = null
defaultRole = null
annotations: null
parameters: array of 0 values
dimensions: array of 0 values
cubes: array of 1 values
cubes[0]: Cube
name = "Omzet gegevens"
caption = null
description = null
defaultMeasure = null
cache = "true"
enabled = "true"
annotations: null
fact: Table
name = "tblTurnover"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
dimensions: array of 4 values
dimensions[0]: Dimension
type = null
usagePrefix = null
foreignKey = "branch_id"
highCardinality = "false"
name = "Branch"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Branch"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Branch]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblBranch"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 1 values
levels[0]: Level
approxRowCount = null
name = "Branch"
table = null
column = "branch"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[1]: Dimension
type = null
usagePrefix = null
foreignKey = "participant_id"
highCardinality = "false"
name = "Deelnemers"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Deelnemers"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Deelnemers]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblParticipant"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 1 values
levels[0]: Level
approxRowCount = null
name = "Organisatie"
table = null
column = "participant"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[2]: Dimension
type = null
usagePrefix = null
foreignKey = "product_id"
highCardinality = "false"
name = "Categorie"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Categorie"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Categorie]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblProduct"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 2 values
levels[0]: Level
approxRowCount = null
name = "Categorie"
table = null
column = "category"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
levels[1]: Level
approxRowCount = null
name = "Product"
table = null
column = "product"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
dimensions[3]: Dimension
type = null
usagePrefix = null
foreignKey = "time_id"
highCardinality = "false"
name = "Tijd"
caption = null
description = null
annotations: null
hierarchies: array of 1 values
hierarchies[0]: Hierarchy
name = null
hasAll = "true"
allMemberName = "All Tijd"
allMemberCaption = null
allLevelName = null
primaryKey = "id"
primaryKeyTable = null
defaultMember = "[All Tijd]"
memberReaderClass = null
caption = null
description = null
uniqueKeyLevelName = null
annotations: null
relation: Table
name = "tblTime"
schema = null
alias = null
filter: null
aggExcludes: array of 0 values
aggTables: array of 0 values
tableHints: array of 0 values
levels: array of 2 values
levels[0]: Level
approxRowCount = null
name = "Jaar"
table = null
column = "year"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
levels[1]: Level
approxRowCount = null
name = "Kwartaal"
table = null
column = "quarter"
nameColumn = null
ordinalColumn = null
parentColumn = null
nullParentValue = null
type = "String"
uniqueMembers = "false"
levelType = "Regular"
hideMemberIf = "Never"
formatter = null
caption = null
description = null
captionColumn = null
annotations: null
keyExp: null
nameExp: null
ordinalExp: null
parentExp: null
closure: null
properties: array of 0 values
memberReaderParameters: array of 0 values
measures: array of 1 values
measures[0]: Measure
name = "Omzet"
column = "turnover"
datatype = null
formatString = "##.####,##"
aggregator = "sum"
formatter = null
caption = null
description = null
visible = null
annotations: null
measureExp: null
memberProperties: array of 0 values
calculatedMembers: array of 0 values
namedSets: array of 0 values
virtualCubes: array of 0 values
namedSets: array of 0 values
roles: array of 0 values
userDefinedFunctions: array of 0 values
630 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: cube=Omzet gegevens
630 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: cube=Omzet gegevens
660 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Branch
660 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Branch, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Branch, fullName=Branch, foreignKey=branch_id, source=null, level=null, name=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Branch, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Branch, fullName=Branch, foreignKey=branch_id, source=null, level=null, name=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Branch, fullName=Branch, foreignKey=branch_id, source=null, level=null, name=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Branch, fullName=Branch, foreignKey=branch_id, source=null, level=null, name=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Branch
661 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Branch
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Deelnemers, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Deelnemers, fullName=Deelnemers, foreignKey=participant_id, source=null, level=null, name=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Deelnemers, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Deelnemers, fullName=Deelnemers, foreignKey=participant_id, source=null, level=null, name=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Deelnemers, fullName=Deelnemers, foreignKey=participant_id, source=null, level=null, name=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Deelnemers, fullName=Deelnemers, foreignKey=participant_id, source=null, level=null, name=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Deelnemers
662 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Deelnemers
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Categorie, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Categorie, fullName=Categorie, foreignKey=product_id, source=null, level=null, name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Categorie, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Categorie, fullName=Categorie, foreignKey=product_id, source=null, level=null, name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Categorie, fullName=Categorie, foreignKey=product_id, source=null, level=null, name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Categorie, fullName=Categorie, foreignKey=product_id, source=null, level=null, name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Categorie
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Tijd
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube<init>: dimension=Tijd
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Tijd, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Tijd, fullName=Tijd, foreignKey=time_id, source=null, level=null, name=Tijd
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: cube=Omzet gegevens, hierarchy=Tijd, usage=HierarchyUsage: kind=PRIVATE, hierarchyName=Tijd, fullName=Tijd, foreignKey=time_id, source=null, level=null, name=Tijd
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Tijd, fullName=Tijd, foreignKey=time_id, source=null, level=null, name=Tijd
663 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.createUsage: register HierarchyUsage: kind=PRIVATE, hierarchyName=Tijd, fullName=Tijd, foreignKey=time_id, source=null, level=null, name=Tijd
664 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Tijd
664 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Tijd
671 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Branch]
671 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Branch]
675 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Branch]
675 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Branch]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Deelnemers]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Deelnemers]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Deelnemers]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Deelnemers]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Categorie]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Categorie]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Categorie]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Categorie]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Tijd]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Tijd]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Tijd]
683 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Normal cardinality for [Tijd]
723 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Pool.get: create schema "jndi:/localhost/mondrian/WEB-INF/queries/turnover.xml"
723 [http-8080-1] DEBUG mondrian.rolap.RolapSchema - Pool.get: create schema "jndi:/localhost/mondrian/WEB-INF/queries/turnover.xml"
747 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Branch], status=hierUsage == not shared returning elementname=Branch
747 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Branch], status=hierUsage == not shared returning elementname=Branch
750 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Categorie], status=hierUsage == not shared returning elementname=Categorie
750 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Categorie], status=hierUsage == not shared returning elementname=Categorie
751 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Deelnemers], status=hierUsage == not shared returning elementname=Deelnemers
751 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Deelnemers], status=hierUsage == not shared returning elementname=Deelnemers
751 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Measures] returning elementname=Measures
751 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.lookupChild: name=Omzet gegevens, childname=[Measures] returning elementname=Measures
767 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
767 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Branch
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Branch
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Deelnemers
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Deelnemers
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Categorie
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Categorie
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Tijd
768 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Tijd
790 [http-8080-1] DEBUG mondrian.mdx - 0: select NON EMPTY Crossjoin({[Branch].Children}, {[Categorie].Children}) ON COLUMNS,
{[Deelnemers].Children} ON ROWS
from [Omzet gegevens]
where {[Measures].[Omzet]}
790 [http-8080-1] DEBUG mondrian.mdx - 0: select NON EMPTY Crossjoin({[Branch].Children}, {[Categorie].Children}) ON COLUMNS,
{[Deelnemers].Children} ON ROWS
from [Omzet gegevens]
where {[Measures].[Omzet]}
791 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
791 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
794 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
794 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
800 [http-8080-1] DEBUG mondrian.sql - 0: SqlMemberSource.getMemberChildren: executing sql [select `tblBranch`.`branch` as `c0` from `tblBranch` as `tblBranch` group by `tblBranch`.`branch` order by ISNULL(`tblBranch`.`branch`), `tblBranch`.`branch` ASC]
800 [http-8080-1] DEBUG mondrian.sql - 0: SqlMemberSource.getMemberChildren: executing sql [select `tblBranch`.`branch` as `c0` from `tblBranch` as `tblBranch` group by `tblBranch`.`branch` order by ISNULL(`tblBranch`.`branch`), `tblBranch`.`branch` ASC]
803 [http-8080-1] DEBUG mondrian.sql - 0: , exec 0 ms
803 [http-8080-1] DEBUG mondrian.sql - 0: , exec 0 ms
803 [http-8080-1] DEBUG mondrian.sql - 0: , exec+fetch 3 ms, 2 rows
803 [http-8080-1] DEBUG mondrian.sql - 0: , exec+fetch 3 ms, 2 rows
806 [http-8080-1] DEBUG mondrian.sql - 1: SqlMemberSource.getMemberChildren: executing sql [select `tblProduct`.`category` as `c0` from `tblProduct` as `tblProduct` group by `tblProduct`.`category` order by ISNULL(`tblProduct`.`category`), `tblProduct`.`category` ASC]
806 [http-8080-1] DEBUG mondrian.sql - 1: SqlMemberSource.getMemberChildren: executing sql [select `tblProduct`.`category` as `c0` from `tblProduct` as `tblProduct` group by `tblProduct`.`category` order by ISNULL(`tblProduct`.`category`), `tblProduct`.`category` ASC]
807 [http-8080-1] DEBUG mondrian.sql - 1: , exec 1 ms
807 [http-8080-1] DEBUG mondrian.sql - 1: , exec 1 ms
807 [http-8080-1] DEBUG mondrian.sql - 1: , exec+fetch 1 ms, 8 rows
807 [http-8080-1] DEBUG mondrian.sql - 1: , exec+fetch 1 ms, 8 rows
812 [http-8080-1] DEBUG mondrian.sql - 2: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblBranch`.`branch`) as `c0` from `tblBranch` as `tblBranch`]
812 [http-8080-1] DEBUG mondrian.sql - 2: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblBranch`.`branch`) as `c0` from `tblBranch` as `tblBranch`]
812 [http-8080-1] DEBUG mondrian.sql - 2: , exec 0 ms
812 [http-8080-1] DEBUG mondrian.sql - 2: , exec 0 ms
812 [http-8080-1] DEBUG mondrian.sql - 2: , exec+fetch 0 ms, 1 rows
812 [http-8080-1] DEBUG mondrian.sql - 2: , exec+fetch 0 ms, 1 rows
818 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000001
measure=0x0000000000000000000000000000000000000000000000000000000001000000
818 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000001
measure=0x0000000000000000000000000000000000000000000000000000000001000000
820 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblBranch`.`branch` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`branch_id` = `tblBranch`.`id` group by `tblBranch`.`branch`
820 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblBranch`.`branch` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`branch_id` = `tblBranch`.`id` group by `tblBranch`.`branch`
820 [http-8080-1] DEBUG mondrian.sql - 3: Segment.load: executing sql [select `tblBranch`.`branch` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`branch_id` = `tblBranch`.`id` group by `tblBranch`.`branch`]
820 [http-8080-1] DEBUG mondrian.sql - 3: Segment.load: executing sql [select `tblBranch`.`branch` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`branch_id` = `tblBranch`.`id` group by `tblBranch`.`branch`]
823 [http-8080-1] DEBUG mondrian.sql - 3: , exec 3 ms
823 [http-8080-1] DEBUG mondrian.sql - 3: , exec 3 ms
829 [http-8080-1] DEBUG mondrian.sql - 3: , exec+fetch 9 ms, 0 rows
829 [http-8080-1] DEBUG mondrian.sql - 3: , exec+fetch 9 ms, 0 rows
830 [http-8080-1] DEBUG mondrian.sql - 4: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblProduct`.`category`) as `c0` from `tblProduct` as `tblProduct`]
830 [http-8080-1] DEBUG mondrian.sql - 4: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblProduct`.`category`) as `c0` from `tblProduct` as `tblProduct`]
830 [http-8080-1] DEBUG mondrian.sql - 4: , exec 0 ms
830 [http-8080-1] DEBUG mondrian.sql - 4: , exec 0 ms
830 [http-8080-1] DEBUG mondrian.sql - 4: , exec+fetch 0 ms, 1 rows
830 [http-8080-1] DEBUG mondrian.sql - 4: , exec+fetch 0 ms, 1 rows
830 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000100
measure=0x0000000000000000000000000000000000000000000000000000000001000000
830 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000100
measure=0x0000000000000000000000000000000000000000000000000000000001000000
830 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblProduct`.`category` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblProduct` as `tblProduct`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblProduct`.`category`
830 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblProduct`.`category` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblProduct` as `tblProduct`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblProduct`.`category`
830 [http-8080-1] DEBUG mondrian.sql - 5: Segment.load: executing sql [select `tblProduct`.`category` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblProduct` as `tblProduct`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblProduct`.`category`]
830 [http-8080-1] DEBUG mondrian.sql - 5: Segment.load: executing sql [select `tblProduct`.`category` as `c0`, sum(`tblTurnover`.`turnover`) as `m0` from `tblProduct` as `tblProduct`, `tblTurnover` as `tblTurnover` where `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblProduct`.`category`]
832 [http-8080-1] DEBUG mondrian.sql - 5: , exec 2 ms
832 [http-8080-1] DEBUG mondrian.sql - 5: , exec 2 ms
832 [http-8080-1] DEBUG mondrian.sql - 5: , exec+fetch 2 ms, 0 rows
832 [http-8080-1] DEBUG mondrian.sql - 5: , exec+fetch 2 ms, 0 rows
832 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
832 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
834 [http-8080-1] DEBUG mondrian.sql - 6: SqlMemberSource.getMemberChildren: executing sql [select `tblParticipant`.`participant` as `c0` from `tblParticipant` as `tblParticipant` group by `tblParticipant`.`participant` order by ISNULL(`tblParticipant`.`participant`), `tblParticipant`.`participant` ASC]
834 [http-8080-1] DEBUG mondrian.sql - 6: SqlMemberSource.getMemberChildren: executing sql [select `tblParticipant`.`participant` as `c0` from `tblParticipant` as `tblParticipant` group by `tblParticipant`.`participant` order by ISNULL(`tblParticipant`.`participant`), `tblParticipant`.`participant` ASC]
835 [http-8080-1] DEBUG mondrian.sql - 6: , exec 1 ms
835 [http-8080-1] DEBUG mondrian.sql - 6: , exec 1 ms
835 [http-8080-1] DEBUG mondrian.sql - 6: , exec+fetch 1 ms, 16 rows
835 [http-8080-1] DEBUG mondrian.sql - 6: , exec+fetch 1 ms, 16 rows
839 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
839 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
845 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
845 [http-8080-1] DEBUG mondrian.rolap.RolapCube - RolapCube.getUsages: name=Measures
860 [http-8080-1] DEBUG mondrian.sql - 7: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblParticipant`.`participant`) as `c0` from `tblParticipant` as `tblParticipant`]
860 [http-8080-1] DEBUG mondrian.sql - 7: RolapStar.Column.getCardinality: executing sql [select count(distinct `tblParticipant`.`participant`) as `c0` from `tblParticipant` as `tblParticipant`]
860 [http-8080-1] DEBUG mondrian.sql - 7: , exec 0 ms
860 [http-8080-1] DEBUG mondrian.sql - 7: , exec 0 ms
860 [http-8080-1] DEBUG mondrian.sql - 7: , exec+fetch 0 ms, 1 rows
860 [http-8080-1] DEBUG mondrian.sql - 7: , exec+fetch 0 ms, 1 rows
860 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000111
measure=0x0000000000000000000000000000000000000000000000000000000001000000
860 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - NO MATCH: tblTurnover
foreign=0x0000000000000000000000000000000000000000000000000000000000000111
measure=0x0000000000000000000000000000000000000000000000000000000001000000
860 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblBranch`.`branch` as `c0`, `tblParticipant`.`participant` as `c1`, `tblProduct`.`category` as `c2`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover`, `tblParticipant` as `tblParticipant`, `tblProduct` as `tblProduct` where `tblTurnover`.`branch_id` = `tblBranch`.`id` and `tblTurnover`.`participant_id` = `tblParticipant`.`id` and `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblBranch`.`branch`, `tblParticipant`.`participant`, `tblProduct`.`category`
860 [http-8080-1] DEBUG mondrian.rolap.agg.AggregationManager - generateSqlQuery: sql=select `tblBranch`.`branch` as `c0`, `tblParticipant`.`participant` as `c1`, `tblProduct`.`category` as `c2`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover`, `tblParticipant` as `tblParticipant`, `tblProduct` as `tblProduct` where `tblTurnover`.`branch_id` = `tblBranch`.`id` and `tblTurnover`.`participant_id` = `tblParticipant`.`id` and `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblBranch`.`branch`, `tblParticipant`.`participant`, `tblProduct`.`category`
861 [http-8080-1] DEBUG mondrian.sql - 8: Segment.load: executing sql [select `tblBranch`.`branch` as `c0`, `tblParticipant`.`participant` as `c1`, `tblProduct`.`category` as `c2`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover`, `tblParticipant` as `tblParticipant`, `tblProduct` as `tblProduct` where `tblTurnover`.`branch_id` = `tblBranch`.`id` and `tblTurnover`.`participant_id` = `tblParticipant`.`id` and `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblBranch`.`branch`, `tblParticipant`.`participant`, `tblProduct`.`category`]
861 [http-8080-1] DEBUG mondrian.sql - 8: Segment.load: executing sql [select `tblBranch`.`branch` as `c0`, `tblParticipant`.`participant` as `c1`, `tblProduct`.`category` as `c2`, sum(`tblTurnover`.`turnover`) as `m0` from `tblBranch` as `tblBranch`, `tblTurnover` as `tblTurnover`, `tblParticipant` as `tblParticipant`, `tblProduct` as `tblProduct` where `tblTurnover`.`branch_id` = `tblBranch`.`id` and `tblTurnover`.`participant_id` = `tblParticipant`.`id` and `tblTurnover`.`product_id` = `tblProduct`.`id` group by `tblBranch`.`branch`, `tblParticipant`.`participant`, `tblProduct`.`category`]
866 [http-8080-1] DEBUG mondrian.sql - 8: , exec 5 ms
866 [http-8080-1] DEBUG mondrian.sql - 8: , exec 5 ms
870 [http-8080-1] DEBUG mondrian.sql - 8: , exec+fetch 9 ms, 0 rows
870 [http-8080-1] DEBUG mondrian.sql - 8: , exec+fetch 9 ms, 0 rows
889 [http-8080-1] DEBUG mondrian.mdx - 0: exec: 98 ms
889 [http-8080-1] DEBUG mondrian.mdx - 0: exec: 98 ms
895 [http-8080-1] ERROR mondrian.xmla.XmlaServlet - Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Execute unparse results error
at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:697)
at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:551)
at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:426)
at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:329)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.valves.ErrorReportValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.connector.CoyoteAdapter.service(Unknown Source)
at org.apache.coyote.http11.Http11Processor.process(Unknown Source)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Unknown Source)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.ClassCastException: mondrian.rolap.RolapMemberBase cannot be cast to mondrian.rolap.RolapCubeMember
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.readMemberChildren(RolapCubeHierarchy.java:569)
at mondrian.rolap.RolapCubeHierarchy$CacheRolapCubeHierarchyMemberReader.getMemberChildren(RolapCubeHierarchy.java:679)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:176)
at mondrian.rolap.SmartMemberReader.getMemberChildren(SmartMemberReader.java:166)
at mondrian.rolap.RolapMemberBase.getPropertyValue(RolapMemberBase.java:356)
at mondrian.rolap.RolapMemberBase.getPropertyValue(RolapMemberBase.java:282)
at mondrian.rolap.DelegatingRolapMember.getPropertyValue(DelegatingRolapMember.java:105)
at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.writeMember(XmlaHandler.java:2137)
at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axis(XmlaHandler.java:2107)
at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.axes(XmlaHandler.java:1974)
at mondrian.xmla.XmlaHandler$MDDataSet_Multidimensional.unparse(XmlaHandler.java:1784)
at mondrian.xmla.XmlaHandler.execute(XmlaHandler.java:690)
... 17 more
More information about the Mondrian
mailing list