Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Report wont open/run from User Console

  1. #1
    Join Date
    Apr 2016
    Posts
    5

    Default Report wont open/run from User Console

    Forgive me, I am very new.
    Having created a report using Report Designer and publishing it to the User console, I get the following error.
    "Unable to read Kettle - Transformation".
    I have seen some historic posts indicating similar error messages but which appear to have been fixed.

    The input source for Report Designer was created using Kettle and then published to the repository.

    If I create the same report from within the User Console- using the kettle output, all works fine.

    Am I doing something foolish....?

    I an using Version 17.1.0.0.12 for PUC, Kettle and Report Designer.

    Any help is appreciated.
    Tony Johnson

  2. #2
    Join Date
    May 2014
    Posts
    358

    Default

    What does the server log say? Is the Kettle transformation deployed in the repository as well, in the correct folder?

  3. #3
    Join Date
    Apr 2016
    Posts
    5

    Default

    Hi Lukfi, thanks for the reply.
    Yes the kettle transformation is in the repository (I assume you mean that the output of the transformation is in the repository?) It is available under thew Admin folder. I have installed 2 instances (windows) one from the community and one from the Pentaho Eval site using the wizard (so the folder structure should be correct?) I am not sure if I have all in the correct structure of folders for the community installation (though it works).. I get the same results whichever version I use.
    Below is some of the log file from C:\pentaho71\server\pentaho-server\logs.

    2017-09-12 08:55:45,048 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:55:48,974 INFO [org.pentaho.platform.osgi.OSGIBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
    2017-09-12 08:55:55,173 INFO [org.pentaho.platform.osgi.KarafInstance]
    *******************************************************************************
    *** Karaf Instance Number: 1 at C:\pentaho71\server\pentaho-server\pentaho- ***
    *** solutions\system\karaf\caches\default\data-1 ***
    *** Karaf Port:8802 ***
    *** OSGI Service Port:9051 ***
    *** JMX RMI Registry Port:11099 ***
    *** RMI Server Port:44445 ***
    *******************************************************************************
    2017-09-12 08:56:15,051 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:56:45,054 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:57:15,081 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:57:45,114 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:58:15,176 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:58:36,475 INFO [org.pentaho.di] 2017/09/12 08:58:36 - General - Logging plugin type found with ID: CheckpointLogTable
    2017-09-12 08:58:45,322 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:59:15,330 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 08:59:45,379 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 09:00:15,383 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 09:00:45,400 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 09:01:15,435 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] Caution, the system is initializing. Do not shut down or restart the system at this time.
    2017-09-12 09:01:23,841 INFO [org.pentaho.platform.engine.core.system.status.PeriodicStatusLogger] The system has finished initializing.
    2017-09-12 10:00:08,249 INFO [org.pentaho.di] 2017/09/12 10:00:08 - output.0 - Connected to database [Hibernate] (commit=1000)
    2017-09-12 10:00:08,298 INFO [org.pentaho.di] 2017/09/12 10:00:08 - csvinput.0 - Header row skipped in file 'C:\pentaho71\server\pentaho-server\pentaho-solutions\system\tmp\admin-7487397694277071226.tmp'
    2017-09-12 10:00:08,312 INFO [org.pentaho.di] 2017/09/12 10:00:08 - csvinput.0 - Finished processing (I=91, O=0, R=0, W=90, U=0, E=0)
    2017-09-12 10:00:08,518 INFO [org.pentaho.di] 2017/09/12 10:00:08 - output.0 - Finished processing (I=0, O=90, R=90, W=90, U=0, E=0)
    2017-09-12 10:25:43,602 ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 81097289: 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:139)
    at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:230)
    at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:96)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:408)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:151)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:168)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:251)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
    at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:318)
    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:442)
    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1433)
    at org.pentaho.reporting.platform.plugin.output.CachingPageableHTMLOutput.produceCacheablePages(CachingPageableHTMLOutput.java:279)
    at org.pentaho.reporting.platform.plugin.output.CachingPageableHTMLOutput.regenerateCache(CachingPageableHTMLOutput.java:245)
    at org.pentaho.reporting.platform.plugin.output.CachingPageableHTMLOutput.generate(CachingPageableHTMLOutput.java:171)
    at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:942)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution$1.call(PentahoAsyncReportExecution.java:102)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution$1.call(PentahoAsyncReportExecution.java:88)
    at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:175)
    at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:164)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution.call(PentahoAsyncReportExecution.java:88)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution.call(PentahoAsyncReportExecution.java:40)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceLoadingException: exception while getting file with id "/home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr"


    Reference number: 532d8fdb-48ae-44a3-87c1-40a30372dc35
    at org.pentaho.reporting.platform.plugin.RepositoryResourceData.getResourceAsStream(RepositoryResourceData.java:93)
    at org.pentaho.reporting.libraries.resourceloader.loader.AbstractResourceData.getResource(AbstractResourceData.java:83)
    at org.pentaho.reporting.libraries.docbundle.bundleloader.ZipResourceBundleLoader.loadBundle(ZipResourceBundleLoader.java:71)
    at org.pentaho.reporting.libraries.resourceloader.DefaultResourceManagerBackend.loadResourceBundle(DefaultResourceManagerBackend.java:321)
    at org.pentaho.reporting.libraries.docbundle.BundleResourceManagerBackend.loadResourceBundle(BundleResourceManagerBackend.java:157)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.loadResourceBundle(ResourceManager.java:248)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.load(ResourceManager.java:264)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:362)
    at org.pentaho.reporting.libraries.resourceloader.ResourceManager.create(ResourceManager.java:334)
    at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleTransFromFileProducer.loadTransformation(KettleTransFromFileProducer.java:124)
    ... 28 more
    Caused by: org.pentaho.platform.api.repository2.unified.UnifiedRepositoryException: exception while getting file with id "/home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr"


    Reference number: 532d8fdb-48ae-44a3-87c1-40a30372dc35
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:512)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.getFileById(ExceptionLoggingDecorator.java:284)
    at org.pentaho.reporting.platform.plugin.RepositoryResourceData.getResourceAsStream(RepositoryResourceData.java:78)
    ... 37 more
    Caused by: org.springframework.extensions.jcr.JcrSystemException: Repository access exception; nested exception is javax.jcr.RepositoryException: invalid identifier: /home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr
    at org.springframework.extensions.jcr.SessionFactoryUtils.translateException(SessionFactoryUtils.java:223)
    at org.springframework.extensions.jcr.JcrAccessor.convertJcrAccessException(JcrAccessor.java:58)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.pentahoConvertJcrAccessException(PentahoJcrTemplate.java:102)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.execute(PentahoJcrTemplate.java:68)
    at org.springframework.extensions.jcr.JcrTemplate.execute(JcrTemplate.java:115)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao.internalGetFileById(JcrRepositoryFileDao.java:386)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao.getFileById(JcrRepositoryFileDao.java:351)
    at org.pentaho.platform.repository2.unified.DefaultUnifiedRepository.getFileById(DefaultUnifiedRepository.java:109)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:69)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:280)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    at com.sun.proxy.$Proxy112.getFileById(Unknown Source)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$23.call(ExceptionLoggingDecorator.java:286)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator$23.call(ExceptionLoggingDecorator.java:284)
    at org.pentaho.platform.repository2.unified.ExceptionLoggingDecorator.callLogThrow(ExceptionLoggingDecorator.java:489)
    ... 39 more
    Caused by: javax.jcr.RepositoryException: invalid identifier: /home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr
    at org.apache.jackrabbit.core.SessionImpl.getNodeByIdentifier(SessionImpl.java:1100)
    at sun.reflect.GeneratedMethodAccessor126.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.CredentialsStrategySessionFactory$LogoutSuppressingInvocationHandler.invoke(CredentialsStrategySessionFactory.java:656)
    at com.sun.proxy.$Proxy111.getNodeByIdentifier(Unknown Source)
    at org.pentaho.platform.repository2.unified.jcr.JcrRepositoryFileDao$4.doInJcr(JcrRepositoryFileDao.java:392)
    at org.pentaho.platform.repository2.unified.jcr.sejcr.PentahoJcrTemplate.execute(PentahoJcrTemplate.java:63)
    ... 61 more
    Caused by: java.lang.IllegalArgumentException: /home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr
    at org.apache.jackrabbit.core.id.NodeId.<init>(NodeId.java:129)
    at org.apache.jackrabbit.core.id.NodeId.valueOf(NodeId.java:52)
    at org.apache.jackrabbit.core.SessionImpl.getNodeByIdentifier(SessionImpl.java:1098)
    ... 68 more
    2017-09-12 10:25:59,635 ERROR [org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor] 1032498039: 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:139)
    at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer.performQuery(AbstractKettleTransformationProducer.java:230)
    at org.pentaho.reporting.engine.classic.extensions.datasources.kettle.KettleDataFactory.queryData(KettleDataFactory.java:96)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:172)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryInternal(CachingDataFactory.java:408)
    at org.pentaho.reporting.engine.classic.core.cache.CachingDataFactory.queryStatic(CachingDataFactory.java:151)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStaticInternal(CompoundDataFactory.java:168)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryStatic(CompoundDataFactory.java:154)
    at org.pentaho.reporting.engine.classic.core.CompoundDataFactory.queryData(CompoundDataFactory.java:67)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQueryData(DefaultFlowController.java:251)
    at org.pentaho.reporting.engine.classic.core.states.datarow.DefaultFlowController.performQuery(DefaultFlowController.java:188)
    at org.pentaho.reporting.engine.classic.core.states.process.ProcessState.initializeForMasterReport(ProcessState.java:318)
    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.prepareReportProcessing(AbstractReportProcessor.java:442)
    at org.pentaho.reporting.engine.classic.core.layout.output.AbstractReportProcessor.processReport(AbstractReportProcessor.java:1433)
    at org.pentaho.reporting.platform.plugin.output.ReportOutputHandler.doProcess(ReportOutputHandler.java:64)
    at org.pentaho.reporting.platform.plugin.output.PDFOutput.generate(PDFOutput.java:58)
    at org.pentaho.reporting.platform.plugin.SimpleReportingComponent.execute(SimpleReportingComponent.java:942)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution$1.call(PentahoAsyncReportExecution.java:102)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution$1.call(PentahoAsyncReportExecution.java:88)
    at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:175)
    at org.pentaho.platform.engine.security.SecurityHelper.runAsUser(SecurityHelper.java:164)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution.call(PentahoAsyncReportExecution.java:88)
    at org.pentaho.reporting.platform.plugin.async.PentahoAsyncReportExecution.call(PentahoAsyncReportExecution.java:40)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.pentaho.reporting.libraries.resourceloader.ResourceLoadingException: exception while getting file with id "/home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr"

  4. #4
    Join Date
    Aug 2006
    Posts
    287

    Default

    Looks like the report is looking for the KTR in the wrong place accrding to this line:

    /home/admin/C:\Users\User\Google Drive\HiCharts\MyWork\Exchange Rates\ExchangeRates.ktr

    Depending on the work the KTR does you need to put the KTR in the same folder the PRD is on the Server. Before publishing the PRD you have to change this location. Or use the KTR as a resource inside the PRD so it is embedded into it and you wouldn't need to worry about uploading the KTR to the server just the PRD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.