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

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.4.0
    • 4.8.0
    • None
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: