Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3229

java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 4.4.0
    • Fix Version/s: 4.8.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      HBase 1.1.2, Saiku 3.8

      Description

      I am trying to integrate the saiku with phoenix. Phoenix intern connect with HBase. I created a schema and when the Saiku tries to load phoenix schema xml, Am triggered with below error. I am working restless to figure it out. Can any one please suggest am I missing something and what to do.
      This might be wrong place to post the question here. But, couldn't find any solution from any where. That's the reason posting here, to check if it's related to phoenix versions issue.

      java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW'
      at org.apache.phoenix.schema.PTableType.fromValue(PTableType.java:88)
      at org.apache.phoenix.jdbc.PhoenixDatabaseMetaData.getTables(PhoenixDatabaseMetaData.java:1057)
      at org.apache.commons.dbcp.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:604)
      at mondrian.rolap.aggmatcher.JdbcSchema.loadTablesOfType(JdbcSchema.java:1205)
      at mondrian.rolap.aggmatcher.JdbcSchema.loadTables(JdbcSchema.java:1162)
      at mondrian.rolap.aggmatcher.JdbcSchema.load(JdbcSchema.java:1042)
      at mondrian.rolap.RolapSchema$PhysSchema.<init>(RolapSchema.java:976)
      at mondrian.rolap.RolapSchemaLoader.createSyntheticPhysicalSchema(RolapSchemaLoader.java:1479)
      at mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:684)
      at mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:376)
      at mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:336)
      at mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)
      at mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4304)
      at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)
      at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)
      at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)
      at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)
      at mondrian.olap.DriverManager.getConnection(DriverManager.java:112)
      at mondrian.olap.DriverManager.getConnection(DriverManager.java:68)
      at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)
      at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)
      at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)
      at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)
      at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:139)
      at java.sql.DriverManager.getConnection(DriverManager.java:664)
      at java.sql.DriverManager.getConnection(DriverManager.java:247)
      at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:111)
      at org.saiku.datasources.connection.SaikuOlapConnection.connect(SaikuOlapConnection.java:57)
      at org.saiku.datasources.connection.SaikuConnectionFactory.getConnection(SaikuConnectionFactory.java:29)
      at org.saiku.web.core.SecurityAwareConnectionManager.a(SecurityAwareConnectionManager.java:293)
      at org.saiku.web.core.SecurityAwareConnectionManager.getInternalConnection(SecurityAwareConnectionManager.java:109)
      at org.saiku.datasources.connection.AbstractConnectionManager.getConnection(AbstractConnectionManager.java:131)
      at org.saiku.datasources.connection.AbstractConnectionManager.getAllConnections(AbstractConnectionManager.java:158)
      at org.saiku.datasources.connection.AbstractConnectionManager.getAllOlapConnections(AbstractConnectionManager.java:181)
      at org.saiku.olap.discover.OlapMetaExplorer.getAllConnections(OlapMetaExplorer.java:119)
      at org.saiku.service.olap.OlapDiscoverService.getAllConnections(OlapDiscoverService.java:58)
      at org.saiku.web.rest.resources.OlapDiscoverResource.getConnections(OlapDiscoverResource.java:60)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              c.venkatesh.mca@gmail.com Venkatesh C
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: