org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException: Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory

Pentaho BI Platform Tracking | Mauro Patroni | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    In Pentaho 5.0.1 CE environment using CDE plugin, I build datasource to HIVE (Hadoop 2.0). The execution of this datasource to load data in a chart return this error: 2013-12-09 20:32:28,280 ERROR [org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory] Data-source used for query 'query' does not provide metadata. Caching will be disabled. org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException: Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory at org.pentaho.reporting.engine.classic.core.metadata.DataFactoryRegistry.getMetaData(DataFactoryRegistry.java:123) at org.pentaho.reporting.engine.classic.core.AbstractDataFactory.getMetaData(AbstractDataFactory.java:140) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.isFreeFormQueryDataFactory(CompoundDataFactory.java:139) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:444) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:454) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.createCacheKey(CachingDataFactory.java:358) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:307) at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:137) at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:136) at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:272) at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:137) at pt.webdetails.cda.CdaEngine.doExportQuery(CdaEngine.java:162) at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:84) at pt.webdetails.cda.CdaUtils.doQueryInternal(CdaUtils.java:113) at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:124) at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:108 .....

    Pentaho BI Platform Tracking | 3 years ago | Mauro Patroni
    org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException: Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory
  2. 0

    In Pentaho 5.0.1 CE environment using CDE plugin, I build datasource to HIVE (Hadoop 2.0). The execution of this datasource to load data in a chart return this error: 2013-12-09 20:32:28,280 ERROR [org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory] Data-source used for query 'query' does not provide metadata. Caching will be disabled. org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException: Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory at org.pentaho.reporting.engine.classic.core.metadata.DataFactoryRegistry.getMetaData(DataFactoryRegistry.java:123) at org.pentaho.reporting.engine.classic.core.AbstractDataFactory.getMetaData(AbstractDataFactory.java:140) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.isFreeFormQueryDataFactory(CompoundDataFactory.java:139) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:444) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:454) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.createCacheKey(CachingDataFactory.java:358) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:307) at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:137) at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:136) at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:272) at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:137) at pt.webdetails.cda.CdaEngine.doExportQuery(CdaEngine.java:162) at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:84) at pt.webdetails.cda.CdaUtils.doQueryInternal(CdaUtils.java:113) at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:124) at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:108 .....

    Pentaho BI Platform Tracking | 3 years ago | Mauro Patroni
    org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException: Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory

    Root Cause Analysis

    1. org.pentaho.reporting.engine.classic.core.metadata.MetaDataLookupException

      Unable to locate metadata for data-factory type org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.sql.SQLReportDataFactory

      at org.pentaho.reporting.engine.classic.core.metadata.DataFactoryRegistry.getMetaData()
    2. org.pentaho.reporting
      CachingDataFactory.queryData
      1. org.pentaho.reporting.engine.classic.core.metadata.DataFactoryRegistry.getMetaData(DataFactoryRegistry.java:123)
      2. org.pentaho.reporting.engine.classic.core.AbstractDataFactory.getMetaData(AbstractDataFactory.java:140)
      3. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.isFreeFormQueryDataFactory(CompoundDataFactory.java:139)
      4. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:444)
      5. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.getDataFactoryForQuery(CompoundDataFactory.java:454)
      6. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.createCacheKey(CachingDataFactory.java:358)
      7. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryData(CachingDataFactory.java:307)
      7 frames
    3. pt.webdetails.cda
      CdaUtils.doQuery
      1. pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:137)
      2. pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:136)
      3. pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:272)
      4. pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:137)
      5. pt.webdetails.cda.CdaEngine.doExportQuery(CdaEngine.java:162)
      6. pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:84)
      7. pt.webdetails.cda.CdaUtils.doQueryInternal(CdaUtils.java:113)
      8. pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:124)
      8 frames