org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to load Kettle-Transformation

Pentaho BI Platform Tracking | Bryce Lobdell | 2 years ago
  1. 0

    Something happens in PRD which causes it to be unable to read data from or otherwise use a PDI (ie., .ktr) data source. I haven't been able to figure out exactly when it happens, though I'll add to this ticket if I can figure it out. Here is the setup: (1) I have a report with a main query and parameters sourced from a PDI (ie., .ktr) data source. (2) Periodically, when something causes PRD to refresh the report (ie., reload the data from the main query, and reload the parameter values), I will receive a popup error message with the following stack trace. Once this has happened I cannot access the PDI data sources for metadata or data unless I restart PRD: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to load Kettle-Transformation at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:159) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:203) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:121) at org.pentaho.reporting.ui.datasources.kettle.KettleDataSourceDialog$KettlePreviewWorker.run(KettleDataSourceDialog.java:592) at java.lang.Thread.run(Thread.java:744) Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException: Unable to create key: No loader was able to handle the given key data: get_metertype_options.ktr at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.createKey(DefaultResourceManagerBackend.java:74) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:151) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:137) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.createKey(KettleTransFromFileProducer.java:118) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:138) ... 4 more

    Pentaho BI Platform Tracking | 2 years ago | Bryce Lobdell
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to load Kettle-Transformation
  2. 0

    Something happens in PRD which causes it to be unable to read data from or otherwise use a PDI (ie., .ktr) data source. I haven't been able to figure out exactly when it happens, though I'll add to this ticket if I can figure it out. Here is the setup: (1) I have a report with a main query and parameters sourced from a PDI (ie., .ktr) data source. (2) Periodically, when something causes PRD to refresh the report (ie., reload the data from the main query, and reload the parameter values), I will receive a popup error message with the following stack trace. Once this has happened I cannot access the PDI data sources for metadata or data unless I restart PRD: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to load Kettle-Transformation at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:159) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:203) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:121) at org.pentaho.reporting.ui.datasources.kettle.KettleDataSourceDialog$KettlePreviewWorker.run(KettleDataSourceDialog.java:592) at java.lang.Thread.run(Thread.java:744) Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException: Unable to create key: No loader was able to handle the given key data: get_metertype_options.ktr at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.createKey(DefaultResourceManagerBackend.java:74) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:151) at org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:137) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.createKey(KettleTransFromFileProducer.java:118) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:138) ... 4 more

    Pentaho BI Platform Tracking | 2 years ago | Bryce Lobdell
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Unable to load Kettle-Transformation
  3. 0

    Unable to use PDI transform with XSL step as data source in PRD3.5

    pentaho.com | 3 months ago
    org.pentaho.reporting.engine.classic.core.ReportDataFactoryException: Caught Kettle Exception: Check your configuration
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException

      Unable to create key: No loader was able to handle the given key data: get_metertype_options.ktr

      at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.createKey()
    2. org.pentaho.reporting
      KettleDataSourceDialog$KettlePreviewWorker.run
      1. org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.createKey(DefaultResourceManagerBackend.java:74)
      2. org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89)
      3. org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89)
      4. org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.createKey(BundleResourceManagerBackend.java:89)
      5. org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:151)
      6. org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:137)
      7. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.createKey(KettleTransFromFileProducer.java:118)
      8. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:138)
      9. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:203)
      10. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:121)
      11. org.pentaho.reporting.ui.datasources.kettle.KettleDataSourceDialog$KettlePreviewWorker.run(KettleDataSourceDialog.java:592)
      11 frames
    3. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:744)
      1 frame