Forums de discussion

Pentaho integration with Liferay

Gaurav Sharma, modifié il y a 10 années.

Pentaho integration with Liferay

Junior Member Publications: 39 Date d'inscription: 01/11/12 Publications récentes
What's the best way to integrate the Pentaho BI server with Liferay. I've googled around a bit and found 3 methods:

1. iFrame it
2. Folow the steps listed here: http://wiki.pentaho.com/display/COM/Pentaho+reports+integration+with+portlets+web+application
3. Follow the steps here: http://www.liferay.com/community/wiki/-/wiki/Main/Pentaho+Portlets

Any experiences, good or bad, would be welcome.
Gaurav Sharma, modifié il y a 10 années.

RE: Pentaho integration with Liferay

Junior Member Publications: 39 Date d'inscription: 01/11/12 Publications récentes
After a lot of digging, I've realized that one of the best ways to integrate Pentaho would be to use the Pentaho Report Designer, a standalone desktop app. This designer creates a .prpt file. This file can be used to generate reports in HTML, PDF, Excel and formats.

I'm now trying to figure out how I can incorporate the HTML being generated by the
HtmlReportUtil.createStreamHTML
call into a portlet. The problem is that this call generates an entire HTML page along with
,  and 
tags.
vamsee krishna, modifié il y a 10 années.

RE: Pentaho integration with Liferay

New Member Envoyer: 1 Date d'inscription: 16/12/13 Publications récentes
we have used a default liferay iframe portlet and gave the URL of our pentaho dashboard to it, the layout is displayed like we are getting static HTML code but data which has to come from database is not coming, entire db configurations have been perfectly done....However default dashboards which come with pentaho are shown up in the iframe.Could someone assist me in solving this problem and go further.I'm pasting the error which is shown in pentaho.log file.


THANKS in ADVANCE.

Error log of pentaho:


2013-12-16 11:10:37,924 WARN [org.pentaho.hadoop.shim.HadoopConfigurationLocator] Unable to load Hadoop Configuration from "file:///D:/biserver-ce-4.8.0-stable/biserver-ce/pentaho-solutions/system/kettle/plugins/pentaho-big-data-plugin/hadoop-configurations/mapr". For more information enable debug logging.
2013-12-16 11:10:40,738 WARN [org.pentaho.reporting.libraries.base.boot.PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
2013-12-16 11:10:40,818 WARN [org.pentaho.reporting.libraries.base.boot.PackageSorter] A dependent module was not found in the list of known modules.
2013-12-16 11:10:50,121 ERROR [org.pentaho.platform.engine.services.solution.PojoComponent] Error Start: Pentaho Pentaho Platform Engine Core 4.8.0-stable.51169
2013-12-16 11:10:50,123 ERROR [org.pentaho.platform.engine.services.solution.PojoComponent] 9e55351d-6614-11e3-81cc-47fce055ca31:COMPONENT:context-12390962-1387172449549:backupScheduler.xactionCould not load bean class
java.lang.ClassNotFoundException: CdaScheduler
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
at org.pentaho.platform.engine.services.solution.PojoComponent.validateAction(PojoComponent.java:515)
at org.pentaho.platform.engine.services.solution.ComponentBase.validate(ComponentBase.java:239)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateComponents(RuntimeContext.java:559)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateSequence(RuntimeContext.java:508)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:397)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.scheduler.QuartzExecute.execute(QuartzExecute.java:198)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2013-12-16 11:10:50,130 ERROR [org.pentaho.platform.engine.services.solution.PojoComponent] Error end:
2013-12-16 11:10:50,132 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 9e55351d-6614-11e3-81cc-47fce055ca31:SOLUTION-ENGINE:backupScheduler.xaction: Action Sequence execution failed, see details below
| Error Time: Monday, December 16, 2013 11:10:50 AM IST
| Session ID: backupScheduler.xaction
| Instance Id: 9e55351d-6614-11e3-81cc-47fce055ca31
| Action Sequence: backupScheduler.xaction
| Execution Stack:
EXECUTING ACTION: Scheduler (org.pentaho.platform.engine.services.solution.PojoComponent)
| Action Class: org.pentaho.platform.engine.services.solution.PojoComponent
| Action Desc: Scheduler
| Loop Index (1-based): N/A
Stack Trace:org.pentaho.platform.api.engine.ActionValidationException: RuntimeContext.ERROR_0035 - Action validation failed.
at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateComponents(RuntimeContext.java:576)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.validateSequence(RuntimeContext.java:508)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:397)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.scheduler.QuartzExecute.execute(QuartzExecute.java:198)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

2013-12-16 11:10:51,062 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 9f5ba8a0-6614-11e3-81cc-47fce055ca31:SOLUTION-ENGINE:scheduler.xaction: Action Sequence execution failed, see details below
| Error Time: Monday, December 16, 2013 11:10:51 AM IST
| Session ID: scheduler.xaction
| Instance Id: 9f5ba8a0-6614-11e3-81cc-47fce055ca31
| Action Sequence: scheduler.xaction
| Execution Stack:
EXECUTING ACTION: Scheduler (org.pentaho.platform.engine.services.solution.PojoComponent)
| Action Class: org.pentaho.platform.engine.services.solution.PojoComponent
| Action Desc: Scheduler
| Loop Index (1-based): 0
Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - Action failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.scheduler.QuartzExecute.execute(QuartzExecute.java:198)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

2013-12-16 11:10:51,982 WARN [pt.webdetails.cpf.persistence.PersistenceEngine] Falling back to built-in config
2013-12-16 11:11:00,802 WARN [org.apache.axis2.description.java2wsdl.DefaultSchemaGenerator] We don't support method overloading. Ignoring [public java.lang.String serializeModels(org.pentaho.metadata.model.Domain,java.lang.String,boolean) throws java.lang.Exception]
2013-12-16 11:38:05,982 WARN [org.pentaho.platform.engine.services.runtime.TemplateUtil] not found: [Measures].[Sales]