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

Pentaho BI Platform Tracking | Carlos Lopez | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Please see attached video: https://pentaho.box.com/s/kaw9b9gt69uzw1nulh62zc68q0sdodf1 In the video you can see the following elements are loaded in the same folder: ktr_query.ktr Sample KTR Query.prpt As shown in the video you can see the report returns data when executed on-demand but when trying to schedule the report to run on the background the Pentaho.log shows the following stacktrace: {noformat} ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 1923623266: Report processing failed. 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:273) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:110) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:217) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:331) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:481) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) at org.pentaho.reporting.platform.plugin.output.FastStreamJcrHtmlOutput.generate(FastStreamJcrHtmlOutput.java:51) at org.pentaho.reporting.platform.plugin.SimpleReportingAction._execute(SimpleReportingAction.java:920) at org.pentaho.reporting.platform.plugin.SimpleReportingAction.execute(SimpleReportingAction.java:838) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140) at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException: Unable to create key: No loader was able to handle the given key data: ktr_query.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.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) ... 26 more {noformat} Please find attached Sample report and transformation to replicate the issue.

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

    Please see attached video: https://pentaho.box.com/s/kaw9b9gt69uzw1nulh62zc68q0sdodf1 In the video you can see the following elements are loaded in the same folder: ktr_query.ktr Sample KTR Query.prpt As shown in the video you can see the report returns data when executed on-demand but when trying to schedule the report to run on the background the Pentaho.log shows the following stacktrace: {noformat} ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 1923623266: Report processing failed. 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:273) at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:110) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505) at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182) at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296) at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:217) at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:331) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:481) at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713) at org.pentaho.reporting.platform.plugin.output.FastStreamJcrHtmlOutput.generate(FastStreamJcrHtmlOutput.java:51) at org.pentaho.reporting.platform.plugin.SimpleReportingAction._execute(SimpleReportingAction.java:920) at org.pentaho.reporting.platform.plugin.SimpleReportingAction.execute(SimpleReportingAction.java:838) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173) at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267) at org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140) at org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39) at org.quartz.core.JobRunShell.run(JobRunShell.java:199) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546) Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceKeyCreationException: Unable to create key: No loader was able to handle the given key data: ktr_query.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.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) ... 26 more {noformat} Please find attached Sample report and transformation to replicate the issue.

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

    Root Cause Analysis

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

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

      at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.createKey()
    2. org.pentaho.reporting
      SimpleReportingAction.execute
      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.resourceloader.ResourceManager.createKey(ResourceManager.java:151)
      4. org.pentaho.reporting.libraries.resourceloader.ResourceManager.createKey(ResourceManager.java:137)
      5. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.createKey(KettleTransFromFileProducer.java:118)
      6. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:138)
      7. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:273)
      8. org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:110)
      9. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:205)
      10. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
      11. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:505)
      12. org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:181)
      13. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:200)
      14. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:182)
      15. org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:69)
      16. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:296)
      17. org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:217)
      18. org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:331)
      19. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:481)
      20. org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1713)
      21. org.pentaho.reporting.platform.plugin.output.FastStreamJcrHtmlOutput.generate(FastStreamJcrHtmlOutput.java:51)
      22. org.pentaho.reporting.platform.plugin.SimpleReportingAction._execute(SimpleReportingAction.java:920)
      23. org.pentaho.reporting.platform.plugin.SimpleReportingAction.execute(SimpleReportingAction.java:838)
      23 frames
    3. org.pentaho.platform
      BlockingQuartzJob.execute
      1. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:241)
      2. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob$1.call(ActionAdapterQuartzJob.java:181)
      3. org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:173)
      4. org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:162)
      5. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.invokeAction(ActionAdapterQuartzJob.java:267)
      6. org.pentaho.platform.scheduler2.quartz.ActionAdapterQuartzJob.execute(ActionAdapterQuartzJob.java:140)
      7. org.pentaho.platform.scheduler2.quartz.BlockingQuartzJob.execute(BlockingQuartzJob.java:39)
      7 frames
    4. quartz
      SimpleThreadPool$WorkerThread.run
      1. org.quartz.core.JobRunShell.run(JobRunShell.java:199)
      2. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:546)
      2 frames