Pentaho Community Forums - BI Platform

xaction returns "Repository" not found message

axelb — Mon, 06 Sep 2010 07:52:12 GMT

Hi,

I'm trying to execute a Kettle job using xaction. The job resides inside a Kettle repository. When I try to execute the xaction, Bi returns the following error:

Pentaho BI Platform - Error in Action Failed [es_161] Error: Kettle.ERROR_0004 - [es_260] The repository specified was not found (Prueba_MySQL) (org.pentaho.platform.plugin.action.kettle.KettleC omponent)

In this case, the name of repository is Prueba_MySQL

You can see in the message that the problem comes from Kettle. It looks like it cannot recognize the datasource, so I did the following:

Defined the datasource in jdbc.properties file, under simple-jndi directories located under BI directory and Kettle directory.
In Kettle, changed repository connection database to JNDI.

Defined Datasource in BI using Database connection Tab, inside PAC

I don't know what is missing, since the system still reports an error...

Any idea ?

Thank you for your help

The requested resource (/ pentaho / NewAnalysisView) is not available

sws — Mon, 06 Sep 2010 07:40:37 GMT

Hi,

on Friday I upgraded our BI Server from 3.5.2 to 3.6. As far as I can see everything's fine. Almost ...

When I tried to create an analysis view with the published schema I got the following error message:

HTTP Status 404:
"The requested resource (/ pentaho / NewAnalysisView) is not available."

I checked ... /pentaho-solutions/system/olap/datasources.xml, I republished schema file. Everything seems to be in the right place but the error message remains. Didn't find anything in the forums so far.

Any help is appreciated.
Greets,
Sebastian

I am not able to try the ad hoc query (Hard to be a newbee)

intellagent — Sat, 04 Sep 2010 06:57:49 GMT

I try to define a simple report in the Pentaho User Consol. (With the given examples it works) I have already a business model. I dropped one item into the detail area and start the preview. I got the message:"AdhocWebService.ERROR_0012 - Failed to generate the report preview. Please check the server log for details of the error."
In the server log there are the followings:

08:51:48,530 ERROR [SolutionEngine] e3b68d6e-b7f0-11df-b38a-f12655452f74:SOLUTION-ENGINE:preview.xaction: Action Sequence execution failed, see details below

| Error Time: 2010. szeptember 4. 8:51:48 CEST
| Session ID: joe
| Instance Id: e3b68d6e-b7f0-11df-b38a-f12655452f74
| Action Sequence: preview.xaction
| Execution Stack:
EXECUTING ACTION: rule (MQLRelationalDataComponent)
| Action Class: MQLRelationalDataComponent
| Action Desc: rule
| Loop Index (1-based): 0
Stack Trace:org.pentaho.platform.api.engine.ActionExecut ionException: RuntimeContext.ERROR_0017 - Action failed to execute
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeComponent(RuntimeContext.java:130 6)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeAction(RuntimeContext.java:1260)
at org.pentaho.platform.engine.services.runtime.Runti meContext.performActions(RuntimeContext.java:1159)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeLoop(RuntimeContext.java:1103)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:985)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:895)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.executeInternal(SolutionEngine.java:399 )
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:202)
at org.pentaho.platform.web.servlet.AdhocWebService.e xecuteActionSequence(AdhocWebService.java:554)
at org.pentaho.platform.web.servlet.AdhocWebService.c reateJFreeReportAsStream(AdhocWebService.java:483)
at org.pentaho.platform.web.servlet.AdhocWebService.g eneratePreview(AdhocWebService.java:407)
at org.pentaho.platform.web.servlet.AdhocWebService.d ispatch(AdhocWebService.java:295)
at org.pentaho.platform.web.servlet.AdhocWebService.d oGet(AdhocWebService.java:261)
at org.pentaho.platform.web.servlet.AdhocWebService.d oPost(AdhocWebService.java:335)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :378)
at org.springframework.security.intercept.web.FilterS ecurityInterceptor.invoke(FilterSecurityIntercepto r.java:109)
at org.springframework.security.intercept.web.FilterS ecurityInterceptor.doFilter(FilterSecurityIntercep tor.java:83)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.ui.ExceptionTranslati onFilter.doFilterHttp(ExceptionTranslationFilter.j ava:101)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.pentaho.platform.web.http.security.SecuritySta rtupFilter.doFilter(SecurityStartupFilter.java:103 )
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.providers.anonymous.A nonymousProcessingFilter.doFilterHttp(AnonymousPro cessingFilter.java:105)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.pentaho.platform.web.http.security.RequestPara meterAuthenticationFilter.doFilter(RequestParamete rAuthenticationFilter.java:169)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.ui.basicauth.BasicPro cessingFilter.doFilterHttp(BasicProcessingFilter.j ava:174)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.ui.AbstractProcessing Filter.doFilterHttp(AbstractProcessingFilter.java: 278)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.ui.logout.LogoutFilte r.doFilterHttp(LogoutFilter.java:89)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.pentaho.platform.web.http.security.HttpSession ReuseDetectionFilter.doFilter(HttpSessionReuseDete ctionFilter.java:134)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.context.HttpSessionCo ntextIntegrationFilter.doFilterHttp(HttpSessionCon textIntegrationFilter.java:235)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.wrapper.SecurityConte xtHolderAwareRequestFilter.doFilterHttp(SecurityCo ntextHolderAwareRequestFilter.java:91)
at org.springframework.security.ui.SpringSecurityFilt er.doFilter(SpringSecurityFilter.java:53)
at org.springframework.security.util.FilterChainProxy $VirtualFilterChain.doFilter(FilterChainProxy.java :390)
at org.springframework.security.util.FilterChainProxy .doFilter(FilterChainProxy.java:175)
at org.springframework.security.util.FilterToBeanProx y.doFilter(FilterToBeanProxy.java:99)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SystemStatus Filter.doFilter(SystemStatusFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.pentaho.platform.web.http.filters.SetCharacter EncodingFilter.doFilter(SetCharacterEncodingFilter .java:113)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:174)
at org.apache.catalina.authenticator.AuthenticatorBas e.invoke(AuthenticatorBase.java:433)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.lang.NullPointerException
at org.pentaho.platform.plugin.action.pentahometadata .MetadataQueryComponent.getDatabaseInterface(Metad ataQueryComponent.java:307)
at org.pentaho.platform.plugin.action.pentahometadata .MetadataQueryComponent.getActiveDatabaseMeta(Meta dataQueryComponent.java:331)
at org.pentaho.platform.plugin.action.pentahometadata .MetadataQueryComponent.executeSqlPhysicalModel(Me tadataQueryComponent.java:361)
at org.pentaho.platform.plugin.action.pentahometadata .MetadataQueryComponent.execute(MetadataQueryCompo nent.java:243)
at org.pentaho.platform.plugin.action.pentahometadata .MQLRelationalDataComponent.executeAction(MQLRelat ionalDataComponent.java:111)
at org.pentaho.platform.engine.services.solution.Comp onentBase.execute(ComponentBase.java:463)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeComponent(RuntimeContext.java:129 1)
... 72 more
--------------------------
What can be the problem?

Thanks

Repository Browse

berkeley — Fri, 03 Sep 2010 21:03:43 GMT

Where does Pentaho BI Server get the information to know which folders to load into the Browse window on the Pentaho user console?

I want some users to see some folders and other users to see other folders.

What are the BI Server internals that control this?

Is there any difference between BI Server 2.0 and BI Server 3.6?

SolutionRepositoryService is throwing a NullPointerException

dupshaw — Fri, 03 Sep 2010 17:35:35 GMT

Hi,

I am new to Pentaho and will be attending the bootcamp next week. In the meantime, I have installed and configured the BI platform on a virtual machine running Red Hat Linux Enterprise 5. I am able to bring up the server, but the SolutionRepositoryService is throwing a NullPointerException.

Here is a partial stacktrace from the biserver pentaho log:

Code:

 

2010-09-03 10:45:03,442 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/pentaho].[SolutionRepositoryService]] Servlet.service() for servlet SolutionRepositoryService threw exception

java.lang.NullPointerException

        at org.pentaho.platform.repository.solution.SolutionRepositoryServiceImpl.getSolutionRepositoryDoc(SolutionRepositoryServiceImpl.java:477)

        at org.pentaho.platform.web.servlet.SolutionRepositoryService.dispatch(SolutionRepositoryService.java:152)

        at org.pentaho.platform.web.servlet.SolutionRepositoryService.doGet(SolutionRepositoryService.java:78)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)

        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)

        at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)

        at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)

        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

        at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101)

        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

        at org.pentaho.platform.web.http.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:103)

        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

        at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105)

        at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53)

        at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390)

        at org.pentaho.platform.web.http.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:169)

Any help that you can provide would be greatly appreciated. Thanks!

How to update PDI module from BI Suite 3.6 Enterprise to PDI 4.01?

D7311 — Fri, 03 Sep 2010 08:31:12 GMT

Hello,

Because of an Bug in PDI 4.0 I have to update it to 4.01. PDI was installed with the BI Suite Enterprise Edition 3.6 GA. I have searched for a new BI Suite Enterprise Edition but it seems there is no. So I thought I can update only the PDI module of the suite with the PDI 4.01 installer (also enterprise). But I can't install it to the c:/pentaho folder becausethe installer says the folder is not empty. Then I thought about to deinstall PDI, but this is not possible because the software BI Suite is only deinstallable as whole software...

So, how can I update PDI Module of the BI Suite 3.6 GA to PDI 4.01?

Thanks for your help.

Xaction mergin pdf's

rhaces — Thu, 02 Sep 2010 16:57:09 GMT

Hi, I have 3 reports (prpt) that have pdf as the output, and I really need to save them in a signle pdf. My question is, is there a way of:
1) Merge 3 report output into one
2) Merge 3 pdf into one

I'm thinking I could do this with subreports, but I need a way on making this prpt's a subreport of an aditional prpt. I'm posting my question in the Reporting forum: http://forums.pentaho.com/showthread...eport-question

Thanks

How to remove login in Bi Server portal

psapozhnikov — Thu, 02 Sep 2010 15:07:37 GMT

Hi

I am running Bi Server 3.6.0 on jboss. I would like to know is there a way to remove the login on the portal and have it go directly into workspace? If there is a way to do it then how?

Thanks
Pavel

Problem in remote access of pentaho server running on Tomcat

siladityadash — Wed, 01 Sep 2010 06:30:31 GMT

Hi,

We are using pentaho 3.6 on linux. To access the server remotely we modified some of the files which blocked the adhoc report to work properly. These are the modifications which I did in tomcat server.

1. Modified the web.xml file located at "/opt/pentaho/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF"

Before:-

base-url

http://localhost:80/pentaho/

Proxy Trusting Filter

org.pentaho.platform.web.http.filters.ProxyT rustingFilter

TrustedIpAddrs

127.0.0.1

Comma separated list of IP addresses of a trusted hosts.

After:-

base-url

http://172.16.0.116:80/pentaho/

Proxy Trusting Filter

org.pentaho.platform.web.http.filters.ProxyT rustingFilter

TrustedIpAddrs

127.0.0.1,172.16.0.116

Comma separated list of IP addresses of a trusted hosts.

2. Modified the server.xml located at "/opt/pentaho/server/biserver-ee/tomcat/conf"

Before:-

maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

After:-

maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

After doing all of these changes when we try to access the adhoc report its giving some javascript error like

QueryInterface: function QueryInterface() {
[native code]
}
message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIXMLHttpRequest.send]
result: 2147500037
name: NS_ERROR_FAILURE
filename: http://172.16.0.116:8080/pentaho/js/pentaho-ajax.js
lineNumber: 246
columnNumber: 0
inner: null
data: null
initialize: function initialize() {
[native code]
}

So can someone tell me what are the steps I have to follow if i need to access the tomcat server remotely. Before writing this mail i gone through the customer portal also "http://kb.pentaho.com/kb/". But that has not contains all of the steps.

Customizing Emails Sent Via Pentaho

PriyankaP — Wed, 01 Sep 2010 05:07:31 GMT

Hi,

I am scheduling reports and sending them in email as xsl attachment. While subscribing I've been given to enter the email subject as 'Report Name'. But in the email I also get the following message "This message was automatically generated by a subscription from the Pentaho BI server."

I want to customize the email content..

I am using Biserver 3.6

Please can anyone help.

PAC using anonymousUser to connect to bi-server-ce

dataguy12 — Tue, 31 Aug 2010 18:27:47 GMT

Hi all,

If I configure the console.xml thusly:

joe

Shouldn't I see joe in this bi-server-ce output?

Code:

2010-08-31 13:23:18,064 DEBUG [org.springframework.security.intercept.AbstractSecurityInterceptor] Previously Authenticated:

org.springframework.security.providers.anonymous.AnonymousAuthenticationToken@bb64

3639: Principal: anonymousUser; Password: [PROTECTED]; Authenticated: true; Details: 

org.springframework.security.ui.WebAuthenticationDetails@ffff8868: RemoteIpAddress: 

192.168.1.41; SessionId: 00BC137EDAA1A03AA88624A9896C69BC; Granted Authorities: 

Anonymous

Instead I keep seeing Anonymous no matter what username I provided.

Second but related question, how do I tell PAC that the authentication has been switched from DAO to LDAP?

Thanks!

Problem while scheduling my report :(

hanihh — Tue, 31 Aug 2010 13:01:16 GMT

Hello there,
I'm facing a problem while trying to schedule my report.
What I did was right click on the report and choose schedule and then fill the fields like the attached snapshot.
an ambigous error occured
I saw the log file but no new intry on it

I tried to make a schedule from PAC, it succeded but no result in PUC...
Attachment 6023

Attached Images

Screenshot.jpg (29.0 KB)

Start-pac.bat as a service

axelb — Tue, 31 Aug 2010 07:26:10 GMT

Hi!

Is there anyway to convert start-pac.bat to a Windows Service so it starts at server boot time ?

Thank you for your help!

Parameters of TOMCAT

Martillo — Tue, 31 Aug 2010 02:29:06 GMT

Hello,

Anybody could explain me a bit what are the meanings of these parameters please?

CATALINA_OPTS="-Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

Xms ??
Xmx ??
XX:MaxPermSize ??
I hope you can help me.

regards.

Please help on the following item. I am trying to use Informix with the Pentaho

zoescout — Mon, 30 Aug 2010 21:25:25 GMT

Please help on the following item. I am trying to use Informix with the Pentaho product and I notice that hibernate works fine with pentaho, basically due to our changes to hibernate3. Also, I created a delegate class for informix and then updated the quartz jar file.

But I have a question and a problem with trying to run it.
1. Question--> It appears that Pentaho uses hypersonic regardless of the main database you are using. Is this correct? Does it actually use 2 different database managers for it to work?

2. I have everything except the hibernate connection using hypersonic and the informix for the main db being accessed by hibernate. the hibernate access seems ok. But I get the following error from starting and I was hoping someone could tell me where it is getting the id and why it changes it to all uppercase. btw... I do not want to add INFORMIX id to the hypersonic database.

16:12:08,473 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 3.6.0-stable.41852
16:12:08,491 ERROR [SQLLookupRule] 3ee2c453-b47b-11df-a4c6-a1ae03bed5ce:COMPONENT:context-17391051-1283202727448:global-department-list.xactionConnectFactory.ERROR_0001 - Database connection could not be established to: SampleData
org.pentaho.platform.api.data.DatasourceServiceExc eption: java.sql.SQLException: User not found: INFORMIX
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceHelper.setupPooledDa taSource(PooledDatasourceHelper.java:147)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledOrJndiDatasourceService.retrie ve(PooledOrJndiDatasourceService.java:46)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledOrJndiDatasourceService.getDat aSource(PooledOrJndiDatasourceService.java:115)
at org.pentaho.platform.plugin.services.connections.s ql.SQLConnection.initWithJNDI(SQLConnection.java:1 92)
at org.pentaho.platform.plugin.services.connections.s ql.SQLConnection.setProperties(SQLConnection.java: 107)
at org.pentaho.platform.engine.services.connection.Pe ntahoConnectionFactory.getConnection(PentahoConnec tionFactory.java:129)
at org.pentaho.platform.engine.services.connection.Pe ntahoConnectionFactory.getConnection(PentahoConnec tionFactory.java:73)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getConnection(SQLBaseComponent.java:879)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getConnection(SQLBaseComponent.java:845)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getDatasourceConnection(SQLBaseComponent.jav a:795)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.executeAction(SQLBaseComponent.java:212)
at org.pentaho.platform.engine.services.solution.Comp onentBase.execute(ComponentBase.java:463)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeComponent(RuntimeContext.java:129 1)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeAction(RuntimeContext.java:1260)
at org.pentaho.platform.engine.services.runtime.Runti meContext.performActions(RuntimeContext.java:1159)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeLoop(RuntimeContext.java:1103)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:985)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:895)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.executeInternal(SolutionEngine.java:399 )
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.core.system.PentahoSys tem.globalStartup(PentahoSystem.java:723)
at org.pentaho.platform.engine.core.system.PentahoSys tem.globalStartup(PentahoSystem.java:678)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:302)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:206)
at org.pentaho.platform.web.http.context.SolutionCont extListener.contextInitialized(SolutionContextList ener.java:136)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirec tory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirec tories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:736)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:443)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:448)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:433)
Caused by: java.sql.SQLException: User not found: INFORMIX
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:582)
at java.sql.DriverManager.getConnection(DriverManager .java:185)
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:48)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.add Object(GenericObjectPool.java:996)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceHelper.setupPooledDa taSource(PooledDatasourceHelper.java:133)
... 49 more
16:12:08,497 ERROR [SQLLookupRule] Error end:

Question about Data Sources

LymanSS — Mon, 30 Aug 2010 19:17:56 GMT

Hi all,
I'm trying to set up a system for editing/developing my solutions in a development, using svn for version control, and ultimately publishing to our production server.

The problem that I'm running into is the database connections. The server that holds the database is on the other side of a firewall, so in my development instance I have to run through an SSH tunnel. So I have the datasource set up to query against the local host at the port where the SSH client is listening.

The production server doesn't have this problem, so it can directly query against the database. Ideally I'd just be able to specify the data source by name, and have that name map to two different connections in the two different environments. However it seems that when I configure a report to query through the SSH tunnel in my development environment, that configuration carries forward to the production server when I publish the report.

I'm sure there's a right way to do this and I'm just missing it. Can anyone tell me what I should be doing here? Thanks

Scott

Report Export Format issue

meussram — Mon, 30 Aug 2010 17:56:48 GMT

Hi,

I am a beginner with Pentaho. However I have created a Business View with Metadata Editor, published it to our Pentaho BI server and created and saved a report.

My issue is that when running the report once logged in my account on the BI server, I am not given a choice as to whether I want to export my report as HTML, CSV or whatever. The export format seems to be tied to the latest choice of preview format I made while editing the report...

Any help would be very welcome,

Thanks,

Sam

Repository cache refresh failed - missing "all-delete-orphan"

Nathan — Mon, 30 Aug 2010 15:32:52 GMT

I'm using Pentaho 3.5.2. Sometimes when I update the solution repository from the user console, I get a message that says "Repository cache refresh failed." When I search the log, I see

Code:

2010-08-30 10:22:25,876 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] HIBUTIL.ERROR_0008 - commitTransaction() failed.

org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: org.pentaho.platform.repository.solution.dbbased.RepositoryFile.childrenFiles

I can restart the Pentaho server application and it refreshes fine for a while until I run into this error again. I'm running on Windows, and I wonder if there is some file system permission problem or something that could be causing this?

Edit BI platform

marcojrfurtado — Mon, 30 Aug 2010 12:54:20 GMT

Hello,

I'm developing an application and I need to use some sort of application to browse my solutions folder.
I downloaded the biserver-ce-manual and decided to use the main page browser.

The problem is that I cannot put it directly where I need it, so I have to edit the page intead of simply calling the Home page. I took a look at /pentaho/mantle/Mantle.jsp, where it is located, but it wasn't of much help. It seems that the page is mostly built with this Javascript: pentaho/mantle/mantle.nocache.js. Unfortunately it is a compressed code and I couldn't find the source.
I even tried to google a solution but nobody seems to have this problem, so it must be really easy to edit the Browser. I just can't figure out how to do it.

pentaho translation

glahuka — Mon, 30 Aug 2010 08:33:56 GMT

Hi all,

I'm trying to translate pentaho's PUC to spanish just translating the .properties files... There is a lot of work already done , but... for example, the "new Ad Hoc report" view is in english... I've made a folder called "es" in adhoc folder (bi-platform-appserver/ ... /messages/nls/ ...) and then I've put in this folder a message_strings.js file with all the spanish messages... well... it doesn't work...

Please, what can I do for translate all PUC applications?

Thanks a lot,

Glahuka

first steps with OLAP Navigator

pep44 — Mon, 30 Aug 2010 00:02:30 GMT

Hello,

I made the sample tutorial: „Analysis View Tutorial“ with the SteelWheels schema and SteelWheels Salec cube. I worked successfully with the OLAP- Navigator as in the sample explained.

I wonted to get the idea how can I create cube on our data and how can I make similar analysis. But without success….

How can I see/ understand the cube of the sample - the SteelWheels Salec cube ?

Are there more (other) similar well explained samples (tutorials) ?

Thank you in advice for answers!

P.

Web Service to access Business models

madhupenta — Fri, 27 Aug 2010 08:21:55 GMT

Hi,

I need to know whether the business models in the metadata.xmi file can be hosted as a web service through user console.. also where would I find documentation where i can learn how to go about using user console' s set of web services??
Please help on this as I am trying to work on something where external applications access pentaho's web services

Dynamic Report

suja — Fri, 27 Aug 2010 05:36:35 GMT

Hi,
I am trying to generate a dynamic report wrt to query result set every time in xaction file.

Code snippet

/***** START ****/

/*** END *** /

But the generated report got congested columns, number of columns will change dynamically.How can set width each columns? And also consecutive columns are not showing. ie if there are 6 columns are there only 1 , 3 ,5 will be displayed. I have no idea what actually happening. Please help me on this issue. Please provide me documentation if any for dynamic report .

Installation problem with JAVA_Home Variable

holydiver — Thu, 26 Aug 2010 19:35:33 GMT

I'm installing Pentaho BI on a Linux server and when I get to the “Initial Startup of the BI Server and Pentaho…” step and when I attempt to run “start-pentaho.sh” I get the following:

WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Neither the JAVA_HOME nor the JRE_HOME environment variable is defined
At least one of these environment variable is needed to run this program

I believe I have the PENTAHO_JAVA_Home variable set up correctly. I added this line:
export PENTAHO_JAVA_HOME=/usr/lib/jvm/java-6-sun
to both my .bashrc as well as /etc/envirmonent (I’m using Ubuntu). But I still get this error. Any ideas?
Let me know, thanks!
A

Add button to the toolbar

supersonic — Thu, 26 Aug 2010 11:33:29 GMT

Hi,

I want to add a button to the toolbar.

I modified the file "main_toolbar.xul," I added this button

How I can connect the button to the home page(launch.jsp)?

"This page cannot be accessed directly" message while creating analysis view

hanihh — Thu, 26 Aug 2010 07:20:08 GMT

Hello all,
I'm new here, using bi server 3.6.0 stable.
There are a problem while creating an analysis view from a schema I published by schema workbench.

I used Linux 10.04 + PostgreSql On foodmart DB

This message appears:
"This page cannot be accessed directly. It must be linked to from other pages"
I tried a lot of suggested solutions but they didn't work.

Step-by-Step Guide / Howto set up Single Sign On and Active Directory

dirks — Wed, 25 Aug 2010 12:43:32 GMT

Hi,

I am trying to set up single sign on and active directory, but I cant get it to work.
I read everything I could find, but its just not working.

Is there a detailed guide on how to do it?

Best regards
Dirk

Exception while dispatching incoming RPC call

Jezebel — Wed, 25 Aug 2010 09:45:03 GMT

Hi,
after some days spent trying to install and configure pentaho BI Server on an existing TomCat 6 server and configured it with DB2 database, I ended having a working platform.
I was able to add some datasources in the administration console and import a schema created with the workbench.

Now, though, I get errors while trying to add a new datasource. When I click on "Test" button to see if the DB connection works. it just sayis "error checking parameters" and I get errors even if I try to edit or delete the connection previously created. I cannot even test or use them anymore.

If I look into the log file I find this:

Code:

 Exception while dispatching incoming RPC call

com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public java.util.List org.pentaho.database.service.DatabaseConnectionService.checkParameters(org.pentaho.database.model.IDatabaseConnection)' threw an unexpected exception: java.lang.NoClassDefFoundError: org/pentaho/di/core/plugins/PluginRegistry

This error is thrown every time I try to do something (add, test, delete the database connections).

Any idea? In fact I can't use BI Server anymore.

Get user name in User Console in MantleApplication

franrd — Wed, 25 Aug 2010 06:44:14 GMT

Hello everyone.

I need to know the active user in the session, which has made the login. I would be interested in the class MantleApplication recover.
I tried everything, but I don't can get it.
In jsp, in launch.jsp I could retrieve it using:

org.springframework.security.context.SecurityConte xtHolder,
org.springframework.security.userdetails.User
User user = (User) SecurityContextHolder.getContext (). GetAuthentication (). GetPrincipal ();

But if I try this in class MantleApplication, to make the build, as org.springframework.security Imports fail.

Anyone know how to retrieve the user session in the MantleApplication class?
Or you can give me something?

Thanks

How to easily cut and paste reports between directories in the user console?

somee — Tue, 24 Aug 2010 15:01:14 GMT

As an admin I would like to know what the easiast way is to move reports between folders in the Pntaho user Console.

Is this possible in the user console itself?
OK i know you can open the report and "save as" in another directory..., but I would rather have the possibility to do this all at once

Or does the user or the admin have to go to the server each time to switch a report from one directory to another?

remote mysql DB connection refused error

amy_BCell — Tue, 24 Aug 2010 13:44:26 GMT

Environment:
Centos 5.4(64-bit)
Jboss 4.2.3
Java 1.6
BI Platform 3.6
MySQL 5.1.49

I'm currently trying to connect to a remote mysql database. I'm able to connect to said database with just the mysql client and a third-party client(DBVisualizer). However, when I start the JBoss server, I'm getting warning and info messages that aren't allowing the BI Platform to start successfully. Here are some of those messages:

Code:

13:11:23,209 INFO  [STDOUT] 13:11:23,205 ERROR [SchemaUpdate] could not complete schema update

java.sql.SQLException: Connections could not be acquired from the underlying database!

        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)

        at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)

        at org.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:56)

        at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:27)

        at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:127)

        at org.hibernate.impl.SessionFactoryImpl.(SessionFactoryImpl.java:314)

        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)

        at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(Unknown Source)

        at org.pentaho.platform.repository.hibernate.HibernateUtil.(Unknown Source)

        at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.internalGetRootFolder(Unknown Source)

        at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.init(Unknown Source)

        at org.pentaho.platform.repository.solution.dbbased.DbBasedSolutionRepository.(Unknown Source)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)

        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)

        at java.lang.Class.newInstance0(Class.java:355)

        at java.lang.Class.newInstance(Class.java:308)

        at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.instanceClass(Unknown Source)

        at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.retreiveObject(Unknown Source)

        at org.pentaho.platform.engine.core.system.objfac.AbstractSpringPentahoObjectFactory.get(Unknown Source)

        at com.pentaho.platform.web.http.context.WebSpringPentahoObjectFactory.get(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.get(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.get(Unknown Source)

        at org.pentaho.platform.plugin.action.kettle.KettleSystemListener.startup(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.init(Unknown Source)

        at org.pentaho.platform.engine.core.system.PentahoSystem.init(Unknown Source)

        at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(Unknown Source)

        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)

        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)

        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)

        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)

        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)

        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)

        at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)

        at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)

        at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)

        at org.jboss.web.WebModule.startModule(WebModule.java:83)

        at org.jboss.web.WebModule.startService(WebModule.java:61)

        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)

        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)

        at $Proxy0.start(Unknown Source)

        at org.jboss.system.ServiceController.start(ServiceController.java:417)

        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy44.start(Unknown Source)

        at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)

        at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)

        at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)

        at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)

        at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy45.start(Unknown Source)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)

        at org.jboss.deployment.MainDeployer

13:11:23,216 INFO  [STDOUT] .deploy(MainDeployer.java:819)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)

        at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy9.deploy(Unknown Source)

        at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)

        at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)

        at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)

        at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)

        at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)

        at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

        at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)

        at $Proxy0.start(Unknown Source)

        at org.jboss.system.ServiceController.start(ServiceController.java:417)

        at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy4.start(Unknown Source)

        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:304)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)

        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy5.deploy(Unknown Source)

        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)

        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)

        at org.jboss.Main.boot(Main.java:200)

        at org.jboss.Main$1.run(Main.java:508)

        at java.lang.Thread.run(Thread.java:619)

Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.

        at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)

        at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)

        at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)

        ... 164 more

13:11:23,235 WARN  [BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@244a0a42 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:

com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:



** BEGIN NESTED EXCEPTION **



java.net.ConnectException

MESSAGE: Connection refused



STACKTRACE:



java.net.ConnectException: Connection refused

        at java.net.PlainSocketImpl.socketConnect(Native Method)

        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)

        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)

        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)

        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

        at java.net.Socket.connect(Socket.java:529)

        at java.net.Socket.connect(Socket.java:478)

        at java.net.Socket.(Socket.java:375)

        at java.net.Socket.(Socket.java:218)

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)

        at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)

        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2744)

        at com.mysql.jdbc.Connection.(Connection.java:1553)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

        at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)





** END NESTED EXCEPTION **







Last packet sent to the server was 0 ms ago.

        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2820)

        at com.mysql.jdbc.Connection.(Connection.java:1553)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)

        at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)

        at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)

        at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)

        at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)

        at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)

        at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)

        at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)

I've also attached the pentaho.log file. Any help would be much appreciated.

Thanks.

Attached Files

pentaho.log (136.9 KB)

How to create Dependent Parameters in Design Studio ( xaction ) ?

engineer — Tue, 24 Aug 2010 07:09:28 GMT

Hi,

Does anybody know how to create nested parameters in Design Studio ( xaction ) ?

When i choose a country, the area values are dependent for country. (Country : UK ; Area : London)

Thnx,

Report is submitted automatically even though autoSubmit is disabled on biserver 3.6

swethd — Mon, 23 Aug 2010 18:53:37 GMT

The Report is being automatically submitted on the publisher console while changing the report parameters even though the autoSubmit check box is unchecked (disabled) on bi-server 3.6.0

I have even tried both
1) Disabling the Master Report autoSubmit attribute on the report using ReportDesigner 3.6
2)Adding the autoSubmit parameter in the plugin.xml for RUN id tag.
With both these the autoSubmit option is not there on the publisher console of the report but the report is being submitted automatically every time when a report parameter is changed and the result preview will not be shown up unless ViewReport button is clicked which makes the report submitted again.

In Biserver 3.5 disabling AutoSubmit option prevents the form from being automatically submitted but there is no option to get rid of the AutoSubmit option completely from the console.

Is there any solution to prevent the report from being submitted automatically and get rid of AutoSubmit option from the publisher console of the report?

Out of DB connections in assembled Pentaho Dashboards

Nordmeyer — Mon, 23 Aug 2010 11:20:24 GMT

Hi,
we've got some dashboards consisting of about 5 reports, each of which contains a bunch of subreports. Some of these dashboards, are only partly populated with content. On console we get the exception below.

Any hints to do to avoid this. Some pointers to docu would be apreciated, too.

Regards,
TN

ParentException:
java.sql.SQLException: PentahoDatasourceConnectionProvider.ERROR_0002 - Unable to factory object for jndi name RENA for reason Cannot get a connection, pool exhausted
at org.pentaho.reporting.platform.plugin.connection.P entahoJndiDatasourc
eConnectionProvider.createConnection(PentahoJndiDa tasourceConnectionProvider.jav
a:130)
at org.pentaho.reporting.engine.classic.core.modules. misc.datafactory.sq
l.SimpleSQLReportDataFactory.getConnection(SimpleS QLReportDataFactory.java:181)
at org.pentaho.reporting.engine.classic.core.modules. misc.datafactory.sq
l.SimpleSQLReportDataFactory.parametrizeAndQuery(S impleSQLReportDataFactory.java
:264)

....

ALL: What are you using Action Sequences for?

aphillips — Thu, 19 Aug 2010 14:31:07 GMT

As one of the developers much interested in the fate of action sequences, I'd like to query the community about what business problems you use action sequences (aka xaction aka solution engine) to solve. What I'm looking for are just one liners, e.g.:

"I use AS to burst emails, with reports attached, to business users on a nightly basis"
or
"I have an AS that runs on demand that renders charts to users in the Pentaho User Console"
or
"My AS runs a PDI transformation every 3 hours that populates my DWH"
etc..

You might also respond and say you don't use AS because approach XYZ works great for me and I don't feel that I need them (if you do respond this way, I'd love to hear what business need is in view here).

Feel free to be more descriptive, but high level is plenty sufficient. I'm very curious about how AS are being leveraged and how Pentaho's other product offerings are stepping into the same solution space as AS.

I look forward to the feedback.
Cheers,
Aaron

ldap + jdbc authentication fail

alexsousa — Tue, 17 Aug 2010 18:17:36 GMT

Hey!
Could someone give me a help on making bi-server work with Postgres?

I have LDAP + JDBC authentication working for Hypersonic.
Now I've created hibernate and quartz databases on a Postgres server and populated with users, authorities and stuff. But when I change applicationContext-pentaho-security-jdbc.xml "dataSource" section from hsql to postgres I'm not able to log in anymore.
I've double checked hibuser permissions and I can connect to the database using pgAdmin without any problem.

Does anyone know what can be going on?

Works

Code:

Fails

Code:

Mondrian, Pivot.jsp and BI platform

flotho — Tue, 17 Aug 2010 14:33:50 GMT

Hy everybody,

I'm a brand new user of pentaho. I downloaded the latest release by following this link : : http://wiki.pentaho.com/display/COM/...+Stable+Builds

I've installed the platform BI and I use the tomcat bundle that come with the package. The server, the platform and the admin console are starting correctly.

I followed the pdf doc provided by the platform and I tried to create an analysis view.
I've got some little issues with the access level and I fixed them by running everything as root.
After that I have now the following error :

Code:

Error Occurred While getting Resultset                            

  An error occurred while rendering Pivot.jsp. Please see the  log for  details.

In the catalina.output I have the following message :

Code:

INFO: Server startup in 42545 ms

16:20:21,958 WARN  [Logger]  misc-org.pentaho.platform.engine.core.system.PentahoSystem:  PentahoSystem.WARN_OBJECT_NOT_CONFIGURED - Object with name  "Mondrian-UserRoleMapper" has not been configured in the Pentaho object  factory.

16:20:23,774 WARN  [TemplateUtil] not found:  [Measures].[Quantity]

I've checked that the Pivot.jsp is present and it is.

I'm now wondering :
1 - Does the Platform BI needs the mondrian installation
2 - If I need to install mondrian, must I install mondrian in the same tomcat server as the platform and how declare the install in the platform.

Sorry for my english and for this newbie question but I didn't succeed in finding n answer to this problem.

Best regards

can't connect to MySQL server over SSL with JNDI datasource - SOLVED

meonkeys — Tue, 17 Aug 2010 04:21:21 GMT

I'm trying to connect to a MySQL server from a report running in Pentaho BI Server 3.6.0.stable.41852.

If I create an account in MySQL with "GRANT ... REQUIRE SSL", I can still connect to the db using the command line mysql client, but testing the connection from the PAC gives a large stack trace, starting with

Code:

Connection attempt failed: Communications link failure due to underlying  exception:

   ** BEGIN NESTED EXCEPTION **   com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception:

   ** BEGIN NESTED EXCEPTION **   javax.net.ssl.SSLHandshakeException

MESSAGE: sun.security.validator.ValidatorException:

PKIX path building  failed: sun.security.provider.certpath.SunCertPathBuilderException:  unable to find valid certification path to requested target

STACKTRACE:  javax.net.ssl.SSLHandshakeException:  sun.security.validator.ValidatorException:

PKIX path building failed:  sun.security.provider.certpath.SunCertPathBuilderException: 

unable to  find valid certification path to requested target

     at com.sun.net.ssl.internal.ssl.Alerts.getSSLException(Alerts.java:174)

     at com.sun.net.ssl.internal.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1623)

     at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Handshaker.java:198)

     at com.sun.net.ssl.internal.ssl.Handshaker.fatalSE(Handshaker.java:192)

...

The JNDI datasource URL looks like:

Code:

jdbc:mysql://example.com:3306/database?verifyServerCertificate=false&useSSL=true

I noticed the the pentaho BI server and PAC appear to ship with connector/j 5.0.7 (guessing since I found mysql-connector-java-5.0.7.jar inadministration-console/jdbc and biserver-ce/tomcat/common/lib) but verifyServerCertificate isn't supported until connector/j 5.1.6.

I removed mysql-connector-java-5.0.7.jar from both administration-console/jdbc and biserver-ce/tomcat/common/lib, then placed a copy of mysql-connector-java-5.1.13.jar in each and restarted, but I still can't connect via SSL.

...aha! Actually, upgrading connector/j did indeed work, I just forgot to restart the admin console. Whew!

See also: http://jira.pentaho.com/browse/BISERVER-4848 - a request to upgrade bundled MySQL driver(s) to add support for verifyServerCertificate connection parameter

cached users and roles nightmare

alexsousa — Mon, 16 Aug 2010 13:52:36 GMT

Hello!
I've started using BI Server with LDAP authentication and Hibernate for storing roles/users.
Everything worked fine, but I needed to migrate from Hibernate to Postgres.
I've used Prashan's Tutorial and everything seemed to be fine. I can autheticate and see the roles and users on Admin Console.

The problem is that I can't get new users to log in and can't see new roles/users while setting permissions on http://localhost:8080/pentaho/Admin or on Properties from the context menu of a report for example.

Is there any kind of cache for that? I've already cleared repository cache.

IS BI Server compatible with MySQL 4.x ?Hi

X3n0n — Mon, 16 Aug 2010 07:14:23 GMT

Hi !
Everything is in the question, I have successfully installed BI Server on MySQL 5.x for testing, and now, we are thinking to deplmy it on our production server, but they have MySQL 4.x installed instead of 5.x.

Is this a problem or do we need to upgrade MySQL ?

Thanks :)

biserver-ce-3.6.0 Scheduler problem

devendra — Mon, 16 Aug 2010 06:48:42 GMT

hi,
i had schedule around 7 schedule in Bi server, but when i try to add 8th scheduler it create's but after 10 min when i refresh that 8th scheduler get deleted from that list. what is the problem ? :confused:

How can i run the BI-Server without Hibernate??

Colttt — Fri, 13 Aug 2010 14:32:44 GMT

Hello,

my question is in the title.. ;)
How can i run BI-Server without Hibernate??

Problem deploying Pentaho in Oracle OAS 10.1.3.5.0 with MySQL 5.0 in Windows XP

ivan.garciag — Thu, 12 Aug 2010 14:03:42 GMT

Hello,
I found some errors in log files when deploying Pentaho in Oracle OAS 10.1.3.5.0 with MySQL 5.0 in Windows XP.

These are my logs:

1-pentaho.log:
2010-08-12 15:44:26,713 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2010-08-12 15:44:27,463 WARN [org.apache.axis2.description.java2wsdl.DefaultSche maGenerator] We don't support method overloading. Ignoring [public boolean deleteConnection(org.pentaho.platform.dataaccess.d atasource.IConnection) throws org.pentaho.platform.dataaccess.datasource.wizard. service.ConnectionServiceException]
2010-08-12 15:44:27,573 WARN [org.apache.axis2.description.java2wsdl.DefaultSche maGenerator] We don't support method overloading. Ignoring [public boolean deleteConnection(org.pentaho.platform.dataaccess.d atasource.IConnection) throws org.pentaho.platform.dataaccess.datasource.wizard. service.ConnectionServiceException]
2010-08-12 15:44:27,604 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2010-08-12 15:44:27,948 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2010-08-12 15:44:28,338 WARN [org.apache.axis2.description.java2wsdl.DefaultSche maGenerator] We don't support method overloading. Ignoring [public boolean deleteConnection(org.pentaho.platform.dataaccess.d atasource.IConnection) throws org.pentaho.platform.dataaccess.datasource.wizard. service.ConnectionServiceException]
2010-08-12 15:44:28,385 WARN [org.apache.axis2.description.java2wsdl.DefaultSche maGenerator] We don't support method overloading. Ignoring [public boolean deleteConnection(org.pentaho.platform.dataaccess.d atasource.IConnection) throws org.pentaho.platform.dataaccess.datasource.wizard. service.ConnectionServiceException]
2010-08-12 15:44:28,401 WARN [org.apache.axis2.description.AxisService] Unable to generate EPR for the transport : http
2010-08-12 15:44:29,073 ERROR [org.pentaho.platform.engine.services.solution.Solu tionEngine] ba94b34a-a617-11df-ab0d-19102635d161:SOLUTION-ENGINE:global-department-list.xaction: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed
2010-08-12 15:44:29,073 ERROR [org.pentaho.platform.engine.services.solution.Solu tionEngine] ba94b34a-a617-11df-ab0d-19102635d161:SOLUTION-ENGINE:global-department-list.xaction: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed

2-default_group~home~default_group~1.log (in opmn\logs):
10/08/12 15:44:12 java.io.IOException: code-source:/C:/product/10.1.3.1/OracleAS_1/j2ee/home/applications/pentaho/pentaho/WEB-INF/lib/kettle-engine-3.2.2.jar has no "!/" suffix so does not name a path within the code-source.
10/08/12 15:44:12 at oracle.classloader.SharedCodeSourceSet.getResource Stream(SharedCodeSourceSet.java:536)
10/08/12 15:44:12 at oracle.classloader.SharedCodeSourceURL$Connection. getInputStream(SharedCodeSourceURL.java:128)
10/08/12 15:44:12 at java.net.URL.openStream(URL.java:1007)
10/08/12 15:44:12 at org.pentaho.di.core.util.ResolverUtil.loadImplemen tationsInJar(ResolverUtil.java:281)
10/08/12 15:44:12 at org.pentaho.di.core.util.ResolverUtil.findInPackag e(ResolverUtil.java:244)
10/08/12 15:44:12 at org.pentaho.di.core.util.ResolverUtil.find(Resolve rUtil.java:178)
10/08/12 15:44:12 at org.pentaho.di.core.util.ResolverUtil.find(Resolve rUtil.java:184)
10/08/12 15:44:12 at org.pentaho.di.core.config.AnnotatedStepsConfigMan ager.load(AnnotatedStepsConfigManager.java:59)
10/08/12 15:44:12 at org.pentaho.di.core.config.BasicConfigManager.load As(BasicConfigManager.java:46)
10/08/12 15:44:12 at org.pentaho.di.trans.step.BaseStep.(BaseSt ep.java:81)
10/08/12 15:44:12 at org.pentaho.di.trans.StepLoader.readNatives(StepLo ader.java:125)
10/08/12 15:44:12 at org.pentaho.di.trans.StepLoader.init(StepLoader.ja va:110)
10/08/12 15:44:12 at org.pentaho.platform.plugin.action.kettle.KettleSy stemListener.startup(KettleSystemListener.java:53)
10/08/12 15:44:12 at org.pentaho.platform.engine.core.system.PentahoSys tem.notifySystemListenersOfStartup(PentahoSystem.j ava:306)
10/08/12 15:44:12 at org.pentaho.platform.engine.core.system.PentahoSys tem.notifySystemListenersOfStartup(PentahoSystem.j ava:291)
10/08/12 15:44:12 at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:265)
10/08/12 15:44:12 at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:206)
10/08/12 15:44:12 at org.pentaho.platform.web.http.context.SolutionCont extListener.contextInitialized(SolutionContextList ener.java:136)
10/08/12 15:44:12 at com.evermind.server.http.HttpApplication.initDynam ic(HttpApplication.java:1279)
10/08/12 15:44:12 at com.evermind.server.http.HttpApplication.(Ht tpApplication.java:848)
10/08/12 15:44:12 at com.evermind.server.ApplicationStateRunning.getHtt pApplication(ApplicationStateRunning.java:435)
10/08/12 15:44:12 at com.evermind.server.Application.getHttpApplication (Application.java:592)
10/08/12 15:44:12 at com.evermind.server.http.HttpSite$HttpApplicationR unTimeReference.createHttpApplicationFromReference (HttpSite.java:2280)
10/08/12 15:44:12 at com.evermind.server.http.HttpSite$HttpApplicationR unTimeReference.(HttpSite.java:2199)
10/08/12 15:44:12 at com.evermind.server.http.HttpSite.initApplications (HttpSite.java:701)
10/08/12 15:44:12 at com.evermind.server.http.HttpSite.setConfig(HttpSi te.java:308)
10/08/12 15:44:12 at com.evermind.server.http.HttpServer.setSites(HttpS erver.java:280)
10/08/12 15:44:12 at com.evermind.server.http.HttpServer.setConfig(Http Server.java:180)
10/08/12 15:44:12 at com.evermind.server.ApplicationServer.initializeHt tp(ApplicationServer.java:2541)
10/08/12 15:44:12 at com.evermind.server.ApplicationServer.setConfig(Ap plicationServer.java:1058)
10/08/12 15:44:12 at com.evermind.server.ApplicationServerLauncher.run( ApplicationServerLauncher.java:131)
10/08/12 15:44:12 at java.lang.Thread.run(Thread.java:595)
ERROR 12-08 15:44:12,116 - org.pentaho.di.core.util.ResolverUtil@ed55ec - Could not search jar file \'code-source:/C:/product/10.1.3.1/OracleAS_1/j2ee/home/applications/pentaho/pentaho/WEB-INF/lib/kettle-engine-3.2.2.jar\' for classes matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@1a40f ff due to an IOException
ERROR 12-08 15:44:12,116 - org.pentaho.di.core.util.ResolverUtil@ed55ec - java.io.IOException: code-source:/C:/product/10.1.3.1/OracleAS_1/j2ee/home/applications/pentaho/pentaho/WEB-INF/lib/kettle-engine-3.2.2.jar has no "!/" suffix so does not name a path within the code-source.
at oracle.classloader.SharedCodeSourceSet.getResource Stream(SharedCodeSourceSet.java:536)
at oracle.classloader.SharedCodeSourceURL$Connection. getInputStream(SharedCodeSourceURL.java:128)
at java.net.URL.openStream(URL.java:1007)
at org.pentaho.di.core.util.ResolverUtil.loadImplemen tationsInJar(ResolverUtil.java:281)
at org.pentaho.di.core.util.ResolverUtil.findInPackag e(ResolverUtil.java:244)
at org.pentaho.di.core.util.ResolverUtil.find(Resolve rUtil.java:178)
at org.pentaho.di.core.util.ResolverUtil.find(Resolve rUtil.java:184)
at org.pentaho.di.core.config.AnnotatedStepsConfigMan ager.load(AnnotatedStepsConfigManager.java:59)
at org.pentaho.di.core.config.BasicConfigManager.load As(BasicConfigManager.java:46)
at org.pentaho.di.trans.step.BaseStep.(BaseSt ep.java:81)
at org.pentaho.di.trans.StepLoader.readNatives(StepLo ader.java:125)
at org.pentaho.di.trans.StepLoader.init(StepLoader.ja va:110)
at org.pentaho.platform.plugin.action.kettle.KettleSy stemListener.startup(KettleSystemListener.java:53)
at org.pentaho.platform.engine.core.system.PentahoSys tem.notifySystemListenersOfStartup(PentahoSystem.j ava:306)
at org.pentaho.platform.engine.core.system.PentahoSys tem.notifySystemListenersOfStartup(PentahoSystem.j ava:291)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:265)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:206)
at org.pentaho.platform.web.http.context.SolutionCont extListener.contextInitialized(SolutionContextList ener.java:136)
at com.evermind.server.http.HttpApplication.initDynam ic(HttpApplication.java:1279)
at com.evermind.server.http.HttpApplication.(Ht tpApplication.java:848)
at com.evermind.server.ApplicationStateRunning.getHtt pApplication(ApplicationStateRunning.java:435)
at com.evermind.server.Application.getHttpApplication (Application.java:592)
at com.evermind.server.http.HttpSite$HttpApplicationR unTimeReference.createHttpApplicationFromReference (HttpSite.java:2280)
at com.evermind.server.http.HttpSite$HttpApplicationR unTimeReference.(HttpSite.java:2199)
at com.evermind.server.http.HttpSite.initApplications (HttpSite.java:701)
at com.evermind.server.http.HttpSite.setConfig(HttpSi te.java:308)
at com.evermind.server.http.HttpServer.setSites(HttpS erver.java:280)
at com.evermind.server.http.HttpServer.setConfig(Http Server.java:180)
at com.evermind.server.ApplicationServer.initializeHt tp(ApplicationServer.java:2541)
at com.evermind.server.ApplicationServer.setConfig(Ap plicationServer.java:1058)
at com.evermind.server.ApplicationServerLauncher.run( ApplicationServerLauncher.java:131)
at java.lang.Thread.run(Thread.java:595)

-----------------------------------------------------------------

I can see login page but i can't log into application with a user from sample data. The log doesn't show anything about log action as shown in the image:

Attachment 5936

Has somebody the same problem?

Attached Images

error_log_pentaho.jpg (31.7 KB)

Design Studio remote workplace

rafaeldv — Thu, 12 Aug 2010 08:49:09 GMT

Hi
I have the PDS and the BI Platform installed in different locations. Do you know how can I open my pentaho-solutions in the PDS workplace ?. I just have option to open files from the local-machine filesystem.
Best regards
Rafael

License question

sebif — Thu, 12 Aug 2010 03:46:25 GMT

What type of license is needed to embed Pentaho in a comercial application that is sold to customers? Is it possible to embed the Community Edition or only Enterprise Edition can be used for that purpose? What pricing is used in this case - the EE ? Is this considered OEMining or is it a different category?

Thanks
FrankQ

Pentaho email component error on biserver-ce-3.6.0-stable

hirfuin — Wed, 11 Aug 2010 15:18:47 GMT

Hi all!

I need to send some info by email.
When I add EmailComponent in xaction I always get "RuntimeContext.ERROR_0035 - Action validation failed." (whichever configuration I try).

Unfortunately I can't find no log useful about why xaction can't be validated.
I looked for some kind of solution in Internet (finding also thread about recent patch on EmailComponent).

I've also configured smtp server on pentaho-solutions/system/smpt-email
At the moment I'm stuck.

Anyone has some ideas?

Tks!

Create schedule that saves pdf report to shared drive

tom.pricken — Wed, 11 Aug 2010 12:59:11 GMT

Hi,

I need to create a schedule that runs a report and saves it as a .pdf file to a shared directory. I've been looking around the forum but dit not find a straightforward solution for this. Anybody knows how to do this?

Thanks in advance,
Tom

Catch Kettle Exceptions in JPivot

samyukthahari — Wed, 11 Aug 2010 10:43:41 GMT

Hi,

I have a PDI job, which I am calling in the Pentaho User Console using an Xaction. If the job is run successfully a success message 'Action Successful' is displayed on the UI. But when the job fails, the error log is displayed.
Can somebody tell me if there is a way to catch the kettle exceptions, when the job fails and display a customized error message to the user. Should this done in the Pivot.jsp??

PS:I am not sure if this is right place to post issues about Jpivot, if not please redirect me to the appropriate forum

Thanks in advance,
Samyuktha.

security problem with Pentaho BI 3.5.2

gapson — Wed, 11 Aug 2010 09:29:21 GMT

I installed Pentaho BI on Oracle and it works well. but I have a security issue when I want to create a report adhoc.de more I can not publish my metadata from PME always safety problem. when I activate and deactivates . platform.repository.solution.dbbased.DbBasedSoluti onRepository "scope =" session "/> in pentahoObjects.spring.xml all works well but I can not enforce security on folders. what does that have to increase my configuration for all operating normally. help me please

TemplateUtil not found

mquevedob — Wed, 11 Aug 2010 09:03:28 GMT

I am getting this WARN and it seems to be affecting my analysis views:

WARN [org.pentaho.platform.engine.services.runtime.Templ ateUtil] not found: [Measures].[Monto]

Could anyone advise on it, please ?

Pentaho and XMLA (SAP BW)

Spade — Tue, 10 Aug 2010 14:47:41 GMT

Hi guys,

I am trying to access data from a SAP BW system and present it to the business users via the Pentaho BI Suite. As I've seen so far, the best way in which I can gain access to the SAP BW OLAP is by XMLA(please do correct me if this assumption is wrong). Which brings me to my questions:
- can I change the datasource for the Pentaho-embedded JPivot from Mondrian to XMLA provided by BW?
- can I use the BW XMLA as a datasource fro the Jasper Reports?
- is the Pentaho Analyzer restricted to Mondrian OLAP, or can I configure that to work on XMLA too?
- if none of the above are possible, is there any other OLAP Client (like JPaolo Client for example) that can / is embedded in Pentaho BI platform?

Thanks a lot,
Spade.

Evaluating Pentaho

sebif — Mon, 09 Aug 2010 23:10:10 GMT

Hi everyone,

I plan to evaluate Pentaho in the next week. A bit of background: in the past I've led an evaluation of Business Objects, Microstrategy and a few other BI platforms (that took a couple of months) and selected and implemented/OEMed Microstrategy in a large SaaS product. I'm familiar with the general reporting flow and concepts and while I expect that these will apply there I'm not yet aware of the details - which I plan to find out.

Currently I plan to add Pentaho to the list for a new project and I'm trying to figure out where to start - any pointers to documentation, best practices or experiences related to these requirements would be great. Also please keep in mind that as part of the evaluation exercise I'm trying to see whether Community or Enterprise or a mix of the two makes more sense.
- This is an OEM case where the reporting platform needs to be embedded in the product - any license, customizability concerns? Is there good documentation for developers customizing Pentaho and to what degree it can be customized?
- Also - in terms of licensing is OEMing possible with Community Edition?
- One specific requirement asks for capturing the "state" of a report - e.g. while working with an ad-hoc report(drilling) - how easy is to add a button to the UI that allows me to send an custom action to the server with the reports current state?
- For Dashboards - can Dashboards created with the Enterprise Edition be used in the Community Edition? I'm basically trying to figure out if we can create the Dashboards in our Enterprise Edition and roll them out on servers with only Community Edition.
- Performance, scalability - any white papers? (some of the fact tables might have 100 of millions of records).

- Can the unified model (metadata layer) be used everywhere to abstract the report entities?
- How are the aggregations handled/cached?
- Can the ad-hoc report designer/viewer be customized, how and to what degree?
- In the ad-hoc reports can I pre-define the report (select dimensions, metrics) and save it /publish it so next time I open it it can be viewed directly?
- Is the presentation part of the report or is it decoupled via a presentation template?
- Is it possible to link from a reports to other documents?
- What types of drilling is supported? How, where? How to define drill paths?
- Any challenges wrt the integration of Pentaho in a web app?

Again, any experiences related to any of the points above would be greatly appreciated.

Thanks,
FrankQ.

Ad Hoc Security

alexsousa — Mon, 09 Aug 2010 18:18:35 GMT

Hello,
I'm trying to work with metadata security but I can't see my roles and users on metadata editor 3.6.
I've already configured the security service on Tools - Security.
When i click on Test i get

Code:

Connection Infofrom server URL: http://10.96.86.48:8080/pentaho/ServiceAction?action=SecurityDetails&details=roles

But I can't see the users and roles on the business category properties "metadata security" section.
Does anyone know what can be wrong?
I was wondering, if I have too many users (about 19.000..:() will it be a problem?
Thanks!

Highlight bar in a bar line combination chart

alejo_sierra — Mon, 09 Aug 2010 16:01:40 GMT

Hi, i am building a bar line combination chart using a xaction. In fact I already did that showing 2 measures at the same time, but I want to highlight with a diferent color the last bar, that represent the current month.
I am using these charts (http://wiki.pentaho.com/display/Serv...bination+Chart).

Has anyone done that?

Thank You

problem with Pentaho BI and metadata

gapson — Mon, 09 Aug 2010 14:00:38 GMT

hello. I have a problem: When I install Pentaho on Oracle 3.5.2(windows). I can not make ad hoc report on Pentaho BI because the system generates me the message:"There are either no Data Source(s) defined in the metadata, or you do not have permission to access any of the Data Source(s). Please create one or more Data Source(s) using the Metadata Editor and then publish them to the Pentaho server. Or, use the Metadata Editor to give the appropriate user permission to access to the Data Source". when I publish more metadata via an SME, I also have this error message:"Unable to save file ... correct any server id or password .. ".yet everything works fine when I use the hsqldb Pentaho. help me to solve this problem if you like it. this week I am making a loop above. thank you

pentaho and windows 2000

bahafid — Mon, 09 Aug 2010 12:07:18 GMT

hi everybody ,
is pentaho platform work in windows 2000 server ?

thanks

Reporting parameter UTF-8 encoding problem

dipashah29 — Mon, 09 Aug 2010 05:16:02 GMT

Hi all,

We are using pentaho 1.6 as an external reporting tool to our application. We are generating reports via pentaho by making a URL call to the pentaho instance from our application. As part of it we are passing the filter criteria as request parameter. From our application the request parameter are being passed with UTF-8 character encoding but some how on pentaho application, the request parameters are not being decoded properly and as a result the pentaho report generation fails. We have tried using the PentahoAwareCharacterEncodingFilter to filter encoding selection by setting the UTF-8 as default character encoding but still the request parameter which is passed from our application in UTF-8 format is not being decoded properly. Please note that we would not prefer to change the default encoding at tomcat level by modifying the default encoding settings in server.xml file as they may have an impact on other deployed applications. Any kind of solution at the Pentaho application level would be desirable. I would appreciate your inputs/suggestions to resolve this issue.