Comment 6 for bug 496539

When I select an alternative view in the GUI, the following shows up in the log:

where [Measures].[CHSI Indicator Value (String)]

[gho] 15 12 18:21:15 DEBUG mondrian.mdx execute - 0: exec: 355 ms
[gho] 15 12 18:21:34 ERROR mondrian.xmla.XmlaServlet doPost - Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error
        at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2666)
        at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:545)
        at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:410)
        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:303)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Caused by: mondrian.olap.MondrianException: Mondrian Error:Internal error: while counting members of level '[Clinic Visit].[Clinic Visit]; sql=[select
 count(*) as `c0` from (select distinct `CLINIC_VISIT_CODES`.`TYPE_NAME` as `c0` from `CLINIC_VISIT_CODES` as `CLINIC_VISIT_CODES` where (CLINIC_VISIT
_CODES.type_code <> 'NOA')) as `init`]
        at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:785)
        at mondrian.olap.Util.newInternal(Util.java:1435)
        at mondrian.olap.Util.newError(Util.java:1451)
        at mondrian.rolap.SqlStatement.handle(SqlStatement.java:211)
        at mondrian.rolap.SqlStatement.execute(SqlStatement.java:142)
        at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:243)
        at mondrian.rolap.RolapUtil.executeQuery(RolapUtil.java:204)
        at mondrian.rolap.SqlMemberSource.getMemberCount(SqlMemberSource.java:98)
        at mondrian.rolap.SqlMemberSource.getLevelMemberCount(SqlMemberSource.java:92)
        at mondrian.rolap.SmartMemberReader.getLevelMemberCount(SmartMemberReader.java:150)
        at mondrian.rolap.RolapSchemaReader.getLevelCardinality(RolapSchemaReader.java:268)
        at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateDimension(RowsetDefinition.java:3889)
        at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateCube(RowsetDefinition.java:3827)
        at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populateCatalog(RowsetDefinition.java:3811)
        at mondrian.xmla.RowsetDefinition$MdschemaDimensionsRowset.populate(RowsetDefinition.java:3790)
        at mondrian.xmla.Rowset.unparse(Rowset.java:152)
        at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2661)
        ... 17 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'WHO_GHO_PROD.CLINIC_VISIT_CODES' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
        at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
        at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
        at mondrian.rolap.SqlStatement.execute(SqlStatement.java:128)
        ... 29 more
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
java.lang.StringIndexOutOfBoundsException: String index out of range: -1
[gho] 15 12 18:21:34 DEBUG mondrian.mdx execute - 1: select NON EMPTY Crossjoin({[Indicator].[All Indicators].[MDG].[MDG_0000000026]}, {[Time Period]
.[Year].Members}) ON COLUMNS,
  {[Region].[All Regions].[AFR], [Region].[All Regions].[AMR], [Region].[All Regions].[EMR], [Region].[All Regions].[EUR], [Region].[All Regions].[SEA
R], [Region].[All Regions].[WPR], [Region].[All Regions].[WHO_WORLD]} ON ROWS
from [Regional Yearly Core Sums]

[gho] 15 12 18:21:34 DEBUG mondrian.mdx execute - 1: exec: 25 ms