I get asked frequently by people who evaluate Pentaho: How do I get started? Many people (tens of thousands on a monthly basis) download the Pre Configured application and immediately get a sense for the benefits of the Pentaho open source project.
What people almost always want to do next, is get started with their OWN data. You the reader of this blog might find a pre canned demo interesting, but you’ll want to reserve judgement on the leading open source BI Project until you’ve seen your own data flowing into beautiful PDFs/Excel/OLAP Pivot Tables. I totally understand…
This is a very SIMPLE, BASIC, LIGHTWEIGHT guide on how to get the downloadable DEMO connected to YOUR DATABASE and executing YOUR SQL Query using the lynchpin of the Pentaho platform, an Action Sequence (refer to this blog for more on what Action Sequences are).
Disclaimer: Pentaho has development tools that once installed makes the development of action sequences more productive then editing xml as below. In other words, this is just rough and dirty to get you going and connect… I highly suggest downloading the Development Workbench to actually build the Action Sequences.
Step 1:
Collect the following information for your database.
- Vendor (Oracle/MySQL) provided JDBC Jar file (classes12.zip, mysql-connector-java-3.1.12-bin.jar)
- JDBC Connection URL (jdbc:mysql://localhost/database)
- JDBC User Name (scott)
- JDBC Password (tiger)
- A SQL query that you are certain works in your database (select id, title from status)
This is the information needed for ANY Java Application to connect to a database, and is not really Pentaho specific.
Step 2:
Create (using notepad or vi) a file named myfirst-ds.xml in $DEMO_BASE/jboss/server/default/deploy/
Put the following into that file to create a JNDI datasource with the JNDI-NAME “myfirst”
Note: You need to replace the above items with the corresponding JDBC information you collected in the first step.
Step 3:
Edit (using notepad or vi) the file $DEMO_BASE/jboss/server/default/deploy/pentaho.war/WEB-INF/web.xml.
Add the following right below the Shark Connection entry
Step 4:
Edit (using notepad or vi) the file $DEMO_BASE/jboss/server/default/deploy/pentaho.war/WEB-INF/jboss-web.xml.
Add the following right below the Shark entry
Step 5:
Copy your Vendor provided jdbc driver library (classes12.zip) in the following directory:
$DEMO_BASE/jboss/server/default/lib
Congratulations, you’ve setup your JNDI datasource! Whew…. Almost there.
Step 6:
Let’s create your first action sequence!
Create (using notepad or vi) a file named MyFirst.xaction in $DEMO_BASE/pentaho-solutions/samples/datasources
Make sure and replace the select I have above with a select statement that you KNOW works in your database.
Step 7:
Restart your server using the stop-pentaho/start-pentaho commands in $DEMO_BASE.
Step 8:
Open up Firefox (cough IE) and hit the following URL:
http://localhost:8080/pentaho/ViewAction?&solution=samples&path=datasources&action=MyFirst.xaction
You should see the basic output of the Action Sequence which, in this case, is the results of the SQL you provided.
| Action Successful
|
||
| id | title | |
|---|---|---|
| 1 | Open | |
That’s it! You’re connected to your own datasource and now you can start to explore the immense power of Action Sequences with your data… There are approximately 50 example .xactions in the demo so use them as a reference when trying to exploring the features of the platform. I HIGHLY SUGGEST downloading the workbench as well. It’s a visual environment for authoring .xaction files. Trust me, you’ll appreciate the GUI!
Now if you can do something like this but demonstrating Mondrian running over Oracle through Pentaho, then I would be really impressed! I can get Mondrian working with other open-source tools, but not with Pentaho…
Chris,
Interesting… I just connected Mondrian to my local Oracle Express Edition (HR schema has OK sample data) and it worked just fine.
I think connecting to Oracle is a great HOWTO Blog and I’ll work at it soon. To make sure it at least hits what you’re interested in:
Pentaho Application -> Embedded Mondrian/JPivot -> Oracle Database Star Schema.
Basically, you want to use Mondrian inside of our pre-configured installation against an Oracle database, yes?
Nick
Nic,
I think I needed to take a fresh look at it this morning, because after a few minor changes it now works fine…actually much faster than through the other open-source tool I was using. Anyone interested in the examples can send me an email.
Now, is there a way of drilling around in a cube and then saving your postion as a new analysis pivot page from the browser? I can do this from Eclipse, but I’m wondering if there is anything easy enough for end users to do through the browser.
Chris
Hello, I follow the isntructions in your post, but for an Analysis example, When I open the example I’m getting this error in the server console:
12:45:27,140 INFO [STDOUT] Pentaho BI Platform server is ready. (1.0.0.0-156)
12:45:32,750 INFO [HibernateUtil] Hibernate being used in un-managed environmen
t – using static for factory.
12:45:33,187 WARN [SessionFactoryObjectFactory] InitialContext did not implemen
t EventContext
12:45:35,109 ERROR [MondrianModelFactory] Datasource java:comp/env/jdbc/jdbc/Mis
DatosOracle is not configured properly
javax.naming.NameNotFoundException: jdbc not bound
*My JNDI connection name is MisDatosOracle,
*I copied “classes12.zip” inside “root\Pentaho\pentaho-demo\jboss\server\default\lib”
*This is what I have in MisDatosOracle-ds.xml:
MisDatosOracle
jdbc:oracle:oci:@HOST:1521:SID
oracle.jdbc.driver.OracleDriver
USER
PWD
Any ideas what the error means?
Thanks
Cesar,
I can’t say for sure. I used the ojdbc14.jar file that comes with Oracle 10g instead of classes12.zip. I’m not sure what version of Oracle you are using. I was able to connect to Oracle XE running on my localhost using the following XML xe-ds.xml. I tried the oracle driver class name you did, but then switched to this Pool Data Source based on some advice I picked up from some forums. Maybe this will help:
Hello, I change my driver to your settings, still the same error, I’m using Oracle 8i.
Oracle 8 is getting old (10 years)… 🙂 You still have to worry about things like rollback segments and such; I’m sorry!
Another thing to verify… in your “MyFirst.xaction” did you change the tag “jndi” to your own name, instead of “MyFirst.” This tag tells Pentaho which data source it should use for the SQL lookup. I’d say try your old JDBC driver settings (classes12.zip) and verify your MyFirst.xaction has the jndi tag MisDatosOracle.
Since it’s not immediate obvious I’d say keep digging, perhaps on JBoss forums/websites about the circumstances you’re in. There may be info on Oracle websites as well.
Of course, if you’re a pentaho/oracle customer you can contact either or both support organizations.
Kind Regards
Sorry, I’m using 9i (still not 10.Xg but… hhmm), I did change the name of the jndi property to my own name. I’ve been looking in pentaho forums without any luck 🙁
New error message, after starting pentaho server, I received this message:
t EventContext
10:14:16,921 INFO [STDOUT] Pentaho BI Platform server is ready. (1.0.0.0-156)
10:14:17,421 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
— Packages waiting for a deployer —
org.jboss.deployment.DeploymentInfo@15070a6c { url=file:/D:/Pentaho/pentaho-demo
/jboss/server/default/deploy/MisDatosOracle.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/D:/Pentaho/pentaho-demo/jboss/server/default/deploy/MisDatosOracl
e.xml
altDD: null
lastDeployed: 1149866057421
lastModified: 1149866057421
mbeans:
— Incompletely deployed packages —
org.jboss.deployment.DeploymentInfo@15070a6c { url=file:/D:/Pentaho/pentaho-demo
/jboss/server/default/deploy/MisDatosOracle.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/D:/Pentaho/pentaho-demo/jboss/server/default/deploy/MisDatosOracl
e.xml
altDD: null
lastDeployed: 1149866057421
lastModified: 1149866057421
mbeans:
Any ideas?
Thanks for all your help.
Cesar,
Please rename your file to be MisDatosOracle-ds.xml. Jboss simple-jndi requires that datasources end in -ds.xml.
Thanks, I forgot I changed the name for testing purposes, still cannot connect to Oracle, I checking pentaho forum to see if I can find something.
> Vendor (Oracle/MySQL)
What about other jdbc drivers? cobol relativity for example…
Hi there,
I found your post very interesting, since I’m trying to connect Mondrian (first standalone and now through Pentaho) for the past two weeks.
However, even with your how-to I get a similar problem than Cesar:
16:08:32,750 INFO [STDOUT] [pt_47] Pentaho BI Platform server is ready. ([pt_10
5] 1.0.0.0-[pt_101] 0001)
16:08:34,093 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
— Packages waiting for a deployer —
org.jboss.deployment.DeploymentInfo@144eaf0a { url=file:/C:/Pentaho/jboss/server
/default/deploy/bddw.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/Pentaho/jboss/server/default/deploy/bddw.xml
altDD: null
lastDeployed: 1151334514093
lastModified: 1151334514093
mbeans:
— Incompletely deployed packages —
org.jboss.deployment.DeploymentInfo@144eaf0a { url=file:/C:/Pentaho/jboss/server
/default/deploy/bddw.xml }
deployer: null
status: null
state: INIT_WAITING_DEPLOYER
watch: file:/C:/Pentaho/jboss/server/default/deploy/bddw.xml
altDD: null
lastDeployed: 1151334514093
lastModified: 1151334514093
mbeans:
It looks like I have to “deploy” the package somehow…
I’m using:
Pentaho BI Platform (Pre-Configured Installation) Release 1.0.0 (GA) on Windows
Derby 10.1.2.1
how can I use DB2 v8.2 on Pentaho Platform,my database is “abcd”,my table is “efgh”,my userID is “tiger”,my password is “QAZqaz123”.I ‘d like to connect to Pentaho report designer,
Thank you so much.please give me details.
where can I download DASHBOARD?
Absouletely great article. its really helpful in solving many connection issues. Thanks to all of you.
Thanks!!!. Works well for MySQL but I had to change component-name to org.pentaho.plugin.sql.SQLLookupRule instead of component.SQLLookupRule…
Hi all,
My SGBD is POSTGRESQL; i use the driver : postgresql-8.1-404.jdbc2ee but when i execute the requet : http://localhost:8080/pentaho/ViewAction?&solution=samples&path=datasources&action=MyFirst.xaction
an error :
Error: ConnectFactory.ERROR_0001 – Database connection could not be established to: myfirst – org.jboss.util.NestedSQLException: Could not create connection; – nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: org.postgresql.Driver, url: null); – nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; – nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: org.postgresql.Driver, url: null)) (org.pentaho.plugin.sql.SQLLookupRule)
Can you help me?
thank you
Hi Nicholas
How can i apply your proced with MS SQL ?
In “MyFirst.Xml”
myfirst
jdbc:sqlserver://XXX.XXX.X.XX/bugs
com.microsoft.sqlserver.jdbc.SQLServerDriver
nameuser
passusr
In “web.xml”
My First Connection
jdbc/myfirst
javax.sql.Datasource
Container
In “jboss-web.xml”
jdbc/myfirst
javax.sql.Datasource
java:/myfirst
Executing in IE:
http://XXX.XXX.X.XXX:8080/pentaho/ViewAction?&solution=samples&path=datasources&action=MyFirst.xaction
Failed
——————————————————————————–
[es_72] Error: [es_103] SolutionEngine.ERROR_0005 – [es_29] Action sequence not found (org.pentaho.solution.SolutionEngine)
[es_69] Debug: [es_21] Starting execute of samples/datasources/MyFirst.xaction (org.pentaho.solution.SolutionEngine)
[es_69] Debug: [es_30] Getting runtime context and data (org.pentaho.solution.SolutionEngine)
[es_69] Debug: [es_33] Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
[es_72] Error: [es_103] SolutionEngine.ERROR_0005 – [es_29] Action sequence not found (org.pentaho.solution.SolutionEngine)
Can you Help me ?
to the guy with the “Action sequence not found (org.pentaho.solution.SolutionEngine) error ”
check your MyFirst.xaction file. You are most likely missing a “>” or have another syntax error. I had the same error and it was because I was missing a “>” on the query line right after the “]]”
Hi,
I am getting problem while connecting to MS analytic server 2005 using Mondrian API.
I am getting the following error.
Mondrian internal error: provider is not found MSDASQL
can anyone help me to resolve this
what should be given for connection URL for myfirst-ds.xml.i`ve got the following error.
aho-demo/jboss/server/default/deploy/myfirst-ds.xml }
deployer: org.jboss.deployment.XSLSubDeployer@10872ce
status: null
state: FAILED
watch: file:/E:/My Tasks/SDR BI/pentaho-demo/jboss/server/default/deploy/myfir
st-ds.xml
altDD: null
lastDeployed: 1165224144906
lastModified: 1165224144890
mbeans:
give me suggestions
While i run the Url i use to get the following error.I need immediate suggestions.Plz help me out.
Failed
Error: ConnectFactory.ERROR_0001 – Database connection could not be established to: myfirst (org.pentaho.component.SQLLookupRule)
Debug: Starting execute of samples/datasources/MyFirst.xaction (org.pentaho.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.solution.SolutionEngine)
Debug: audit: instanceId=c1a956c3-837e-11db-b37d-37a86684af1d, objectId=org.pentaho.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.runtime.RuntimeContext)
Debug: validateComponent validating component org.pentaho.component.SQLLookupRule (org.pentaho.runtime.RuntimeContext)
Debug: Validating component for action MyFirst.xaction (org.pentaho.component.SQLLookupRule)
Debug: Executing action sequence (org.pentaho.runtime.RuntimeContext)
Debug: Executing action definition: Iteration {0}0 (org.pentaho.runtime.RuntimeContext)
Debug: audit: instanceId=c1a956c3-837e-11db-b37d-37a86684af1d, objectId=org.pentaho.component.SQLLookupRule, messageType=component_execution_started (org.pentaho.runtime.RuntimeContext)
Debug: execute pre-audit (org.pentaho.runtime.RuntimeContext)
Debug: Setting component log level to DEBUG (org.pentaho.runtime.RuntimeContext)
Debug: Initializing component (org.pentaho.runtime.RuntimeContext)
Debug: executeComponent starting audited execute (org.pentaho.runtime.RuntimeContext)
Debug: execute validation=true (org.pentaho.component.SQLLookupRule)
Error: ConnectFactory.ERROR_0001 – Database connection could not be established to: myfirst (org.pentaho.component.SQLLookupRule)
Debug: Running query – select idreg,nam from reg where id=45 (org.pentaho.component.SQLLookupRule)
Error: SQLBaseComponent.ERROR_0006 – Could not execute MyFirst.xaction (org.pentaho.component.SQLLookupRule)
Debug: executeComponent finished audited execute (org.pentaho.runtime.RuntimeContext)
Error: RuntimeContext.ERROR_0012 – ActionDefinition for org.pentaho.component.SQLLookupRule did not execute successfully (org.pentaho.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 – Action sequence execution failed (org.pentaho.solution.SolutionEngine)
Hi Nicolas,
Thanks for this step-by-step.
I tested it with Firebird and couldn’t get it to work.
After some hours of testing there seemed to be 2 problems : 1. I didn’t have the right driver for my Java. I downloaded the latest jaybird-full-2.1.0.jar for JDK 1.4.
2. the connection-url had to be a little different : not jdbc:firebirdsql://localhost/… but jdbc:firebirdsql:localhost/…
Now all works fine and I am ready to move on to greater hights riding Pentaho and Firebird 😉
Keep up the good work,
Bart
Great intro to Pentaho question 2!
Successfully connected to MS SQL Server with windows authentication using jtds driver and jcifs.
Thanks
Les
Great explanation, Thank you! I’m evaluating Pentaho as an alternative to our existing BI app (MicroStrategy). I had the demo running in 15 minutes, but then I spent a day floundering about, wondering what to do next…
What a thrill to be able to actually connect to the MS Sql Server database and see real data!
Is this applicable to Apache/Tomcat also
The oracle part is not very clear
How many xml files need to be changed?
web.xml
datasource.xml only?
with ip , port user id and pwd?
JPivot had an error …
javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Mondrian Error:Internal error: Error while creating SQL dialect
Provider=oracle_data;Jdbc=jdbc:oracle:thin:10.192.30.25:1521:SUPPORT;JdbcUser=SORN_104_24OCT06;JdbcPassword=SORN_104_24OCT06;JdbcDrivers=oracle.jdbc.OracleDriver;Catalog=/WEB-INF/queries/oracle_data.xml
what ned to be done to connect to Oracle
Just wanted to mention to anyone running into trouble with the error “solution1 is not configured properly”, my reason for getting this error was because I copied and pasted the text from the website for the solution1-dx.xml file, and the encoding of the pasted text was latin1 but the XML header indicated it should be utf-8. There was another error message buried in the server console output to that effect. I resaved the file in utf-8 format (although simply retyping the information should work too) and I was able to resolve the problem.
hi
i’ve tried to go through this problem for 3 days
i check up my foodmart.xml schema 3 or 4 times any result i can’t find the error
please help me
11:48:46,208 ERROR [GetMondrianModel] MondrianModel.ERROR_0002 - Le document nest pas n fichier XML Mondrian XML : {0}11:48:46,247 ERROR [OlapModelTag]
mondrian.olap.MondrianException: Mondrian Error:Internal error: while parsing catalog http://localhost:8080/pentaho/GetMondrianModel?model=samples/analysis_foodmart/foodmart.xml
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1035)
at mondrian.olap.Util.newInternal(Util.java:914)
at mondrian.olap.Util.newError(Util.java:930)
at mondrian.rolap.RolapSchema.load(RolapSchema.java:234)
at mondrian.rolap.RolapSchema.(RolapSchema.java:170)
at mondrian.rolap.RolapSchema.(RolapSchema.java:49)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:797)
at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:636)
at mondrian.rolap.RolapConnection.(RolapConnection.java:138)
at mondrian.rolap.RolapConnection.(RolapConnection.java:73)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:120)
at mondrian.olap.DriverManager.getConnection(DriverManager.java:87)
at com.tonbeller.jpivot.mondrian.MondrianModel.initialize(MondrianModel.java:365)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator.initialize(OlapModelDecorator.java:129)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.initialize(OlapModelProxy.java:76)
at com.tonbeller.jpivot.tags.PageStateManager.initializeAndShow(PageStateManager.java:37)
at com.tonbeller.jpivot.tags.OlapModelProxy.initializeAndShow(OlapModelProxy.java:161)
at com.tonbeller.jpivot.tags.OlapModelTag.doEndTag(OlapModelTag.java:76)
at org.apache.jsp.jsp.Pivot_jsp._jspService(Pivot_jsp.java:307)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:139)
at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
but I cannot change to the data for the examples olap and jpivot. Review and you change SampleData.mondrian.xml, query1.xaction. Not the structure of the bucket and dimensions of the SampleDAta. like doing so that it works with my data? aid Pardon the English
Wow… worked well. I did manage to get an error via a typo but otherwise the connection is working, well almost.
I placed a query that is supposed to return a list of 678 rows but somehow or rather it returns only the first 100 rows.
Is this due to a setting in the jdbc driver or Pentaho?
Thanks in advance.
Hi and if i use pentahoJ2EEdeploy and Tomcat5.5 is it the same ?
Thanks for the example. But when I run it I first receive a message stating that I should not be using the org.pentaho.component.SQLLookupRule but rather I should use org.pentaho.plugin.sql.SQLLookupRule. After making this change this error message dissapeared but I am still geting the following error message:
10:10:13,070 ERROR [RuntimeContext] bef364ce-e83e-11db-8748-69254d608325:RUNTIME:context-8460855-1176304212700:MyFirst.xaction RuntimeContext.ERROR_0029 – Error output parameter “rule-result” not found during save.
I have verified that my code is the same as your sample. I am connecting to a mySQL db.
Thanks.
My Bad. I found the culprit. A typo of course. Thanks!
sorry, i still have error when use firebird, maybe Bart can help me with his experience setting pentaho with firebird step by step, thanks
hi…thanks your solution really work, i just forget to use another version of the connector
how about you add some information of connector that compatible with pentaho from different database server i.e Firebird,MS SQL,MySQL etc.
Note, at Step 7, I found that just restarting the Pentaho demo was insufficient to get this new Action recognised. I continued to get the “Action Sequence not valid” error. After a few very sorry hours of scratching about studying Log Files, I found that it is necessary to go to the Admin Screen and invoke “Update Solution Repository”. The new Action can then be invoked.
I presume this requirement is a new Feature introduced since this tutorial was written.
hi,
this is pradeep, iwant to know how to intigrate multible tables in kettle.i am using dummy transformayion but it is not working.
plz as soon as possible replyto my email id
thank u.
my email id :pkumar@vavni.com
Nice article! But I got this error using mysql database – can you help me about this??
Error: SQLBaseComponent.ERROR_0006 – Could not execute myDatabase.xaction – com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘![CDATA[select sku,price from products]]’ at line 1 (org.pentaho.plugin.sql.SQLLookupRule)
Debug: Starting execute of samples/datasources/myDatabase.xaction (org.pentaho.core.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
Debug: SolutionRepository.DEBUG_FILE_PATH – getFile path=C:\My Installer\Pentaho – Business Intelligence\pentaho_demo-1.5.4.716-0\pentaho-demo\pentaho-solutions\samples\datasources\myDatabase.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: audit: instanceId=01b03add-2ffd-11dc-8692-cddcea49c181, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
Debug: validateComponent validating component org.pentaho.component.SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
Warning: Attempt to use org.pentaho.component.SQLLookupRule, please use org.pentaho.plugin.sql.SQLLookupRule instead (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=01b03add-2ffd-11dc-8692-cddcea49c181, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=deprecated (org.pentaho.core.runtime.RuntimeContext)
Debug: Validating component for action myDatabase.xaction (org.pentaho.plugin.sql.SQLLookupRule)
Debug: Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
Debug: Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=01b03add-2ffd-11dc-8692-cddcea49c181, objectId=org.pentaho.component.SQLLookupRule, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
Debug: Setting component log level to DEBUG (org.pentaho.core.runtime.RuntimeContext)
Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
Debug: execute validation=true (org.pentaho.plugin.sql.SQLLookupRule)
Debug: Running query – ![CDATA[select sku,price from products]] (org.pentaho.plugin.sql.SQLLookupRule)
Error: SQLBaseComponent.ERROR_0006 – Could not execute myDatabase.xaction – com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘![CDATA[select sku,price from products]]’ at line 1 (org.pentaho.plugin.sql.SQLLookupRule)
Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
Error: RuntimeContext.ERROR_0012 – ActionDefinition for org.pentaho.component.SQLLookupRule did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=01b03add-2ffd-11dc-8692-cddcea49c181, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 – Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)
Server Version 1.5.4 build 716 0
i changed the Pentaho BI Platform to version 1.2.0 and followed the steps.. but got this error..
Failed
Error: ConnectFactory.ERROR_0001 – Database connection could not be established to: myDatabase – javax.naming.NameNotFoundException: myDatabase not bound (org.pentaho.plugin.sql.SQLLookupRule)
Debug: Starting execute of samples/datasources/myDatabase.xaction (org.pentaho.core.solution.SolutionEngine)
Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
Debug: SolutionRepository.DEBUG_FILE_PATH – getFile path=C:\My Installer\Pentaho – Business Intelligence\pentaho_demo-1.2.1.625-GA\pentaho-demo\pentaho-solutions\samples\datasources\myDatabase.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
Debug: audit: instanceId=0a1438e5-30ba-11dc-b0cd-c5ae7e04bae8, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
Debug: validateComponent validating component org.pentaho.component.SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
Warning: Attempt to use org.pentaho.component.SQLLookupRule, please use org.pentaho.plugin.sql.SQLLookupRule instead (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=0a1438e5-30ba-11dc-b0cd-c5ae7e04bae8, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=deprecated (org.pentaho.core.runtime.RuntimeContext)
Debug: Validating component for action myDatabase.xaction (org.pentaho.plugin.sql.SQLLookupRule)
Debug: Executing action sequence (org.pentaho.core.runtime.RuntimeContext)
Debug: Executing action definition: Iteration 0 (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=0a1438e5-30ba-11dc-b0cd-c5ae7e04bae8, objectId=org.pentaho.component.SQLLookupRule, messageType=component_execution_started (org.pentaho.core.runtime.RuntimeContext)
Debug: execute pre-audit (org.pentaho.core.runtime.RuntimeContext)
Debug: Setting component log level to DEBUG (org.pentaho.core.runtime.RuntimeContext)
Debug: Initializing component (org.pentaho.core.runtime.RuntimeContext)
Debug: executeComponent starting audited execute (org.pentaho.core.runtime.RuntimeContext)
Debug: execute validation=true (org.pentaho.plugin.sql.SQLLookupRule)
Error: ConnectFactory.ERROR_0001 – Database connection could not be established to: myDatabase – javax.naming.NameNotFoundException: myDatabase not bound (org.pentaho.plugin.sql.SQLLookupRule)
Error: SQLBaseComponent.ERROR_0007 – Connection to data source is not valid (org.pentaho.plugin.sql.SQLLookupRule)
Debug: executeComponent finished audited execute (org.pentaho.core.runtime.RuntimeContext)
Error: RuntimeContext.ERROR_0012 – ActionDefinition for org.pentaho.component.SQLLookupRule did not execute successfully (org.pentaho.core.runtime.RuntimeContext)
Debug: audit: instanceId=0a1438e5-30ba-11dc-b0cd-c5ae7e04bae8, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_failed (org.pentaho.core.runtime.RuntimeContext)
Error: SolutionEngine.ERROR_0007 – Action sequence execution failed (org.pentaho.core.solution.SolutionEngine)
Server Version 1.2.1 build 625 GA
Hi Nicholas
How can i apply your proced with PostgreSQL ?
The query was executed succesfully,but I don´t know what to do to avoid changing the “.xaction” everytime I want to make a new query.
I just tried the step by step approach to do a MyFirst.xacton against a MySQL database. My Pentaho Demo is working properly. When I try to connect to the web URL for MyFirst.xaction I just get teh generic (IE) error : This page cannot be displayed. Same thing you would egt when typing in an invalid web site. I have checked and triple checked that I don’t have a type in the URL. I don;t get any Pentaho errors at all. I can connect just fine to the SampleDataQuery.xaction.
Could this error be due to the MySQL JBC jar file not being installed properly. The file is installed in:
….\joboss\server\default\lib
Thanks,
Bill
I’m having problems trying to connect to a MS SQL server using native Windows authentication (not SQL). Do you have any advice?
Mondrian & Oracle in this page (spanish)http://pentaho.almacen-datos.com/mondrian_oracle.html
.I’ve tried it and it really works.
Hi,
I’m having problems trying to connect mysql.
[org.hibernate.util.JDBCExceptionReporter] Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused: connect
STACKTRACE:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
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 java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)
at org.hibernate.loader.Loader.doQuery(Loader.java:673)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
at org.hibernate.event.def.DefaultLoadEventListener.lockAndLoad(DefaultLoadEventListener.java:297)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:106)
at org.pentaho.repository.HibernateLoadEventListener.onLoad(HibernateLoadEventListener.java:30)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:869)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:864)
at org.pentaho.repository.DefinitionVersionManager.performAutoUpdateIfRequired(DefinitionVersionManager.java:45)
at org.pentaho.repository.HibernateUtil.initialize(HibernateUtil.java:155)
at org.pentaho.repository.HibernateUtil.(HibernateUtil.java:85)
at com.pentaho.repository.subscribe.SubscriptionRepository.(SubscriptionRepository.java:64)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance0(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at org.pentaho.core.system.PentahoSystem.createObject(PentahoSystem.java:1179)
at org.pentaho.core.system.PentahoSystem.createObject(PentahoSystem.java:1202)
at org.pentaho.core.system.PentahoSystem.loadStartupObject(PentahoSystem.java:580)
at org.pentaho.core.system.PentahoSystem.loadStartupObject(PentahoSystem.java:540)
at org.pentaho.core.system.PentahoSystem.initGlobalObjects(PentahoSystem.java:710)
at org.pentaho.core.system.GlobalObjectInitializer.startup(GlobalObjectInitializer.java:33)
at org.pentaho.core.system.PentahoSystem.createSystemListeners(PentahoSystem.java:388)
at org.pentaho.core.system.PentahoSystem.init(PentahoSystem.java:321)
at org.pentaho.core.system.PentahoSystem.init(PentahoSystem.java:212)
at org.pentaho.core.system.SolutionContextListener.contextInitialized(SolutionContextListener.java:121)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3854)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4359)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297)
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:5310)
at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:297)
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(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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 $Proxy182.start(Unknown Source)
at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
at sun.reflect.GeneratedMethodAccessor123.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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.ws.integration.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:93)
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 $Proxy183.start(Unknown Source)
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 sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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:302)
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(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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(Unknown Source)
thanks,
Hi
PgAdminIII can access my database. The Pre Configured application of the report designer sample works as well. But I got the following result by running step 8 on the IE:
HTTP Status 404 – /pentaho/ViewAction
——————————————————————————–
type Status report
message /pentaho/ViewAction
description The requested resource (/pentaho/ViewAction) is not available.
——————————————————————————–
JBossWeb/2.0.0.GA
Can you please advise me what I might be doing wrong?
Thanks
hola nicholas gracias por tu ayuda cuando intento ejecutar el .xaction me sale el siguiente error. Otra cosa como puedo conectarme a diferentes bases de datos ejemplo el ejemplo que viene con mysql hay no hay problema y a mi base de datos postgres 8.2. de mi base de datos postgres quiero ver mediante graficas y tablas el analisis de mi cubo Ah otra cosita cuando intento publicar el cubo me sale que el password y el usuario no conciden tengo pentaho BI server 1.6 ya ingrese mi password de publicación y como usuario ingreso joe y contraseña password????? gracias
Hi nicholas. thanks for you help, but I wanted run my file xxxx.xaction… es_161] Error: SolutionRepository.ERROR_0009 – [es_385] The solution document /pentaho-solutions/samples/datasources/IndProduccion.xaction is not a valid XML document (com.pentaho.repository.dbbased.solution.SolutionRepository) ????
I make the sample use sampledata and i get the follow mistake, i did installed Cube Designer and i schema workbrench after this the application fail:
Failed
——————————————————————————–
[es_161] Error: RuntimeContext.ERROR_0006 – [es_2] Action components do not validate: otro.xaction (org.pentaho.core.runtime.RuntimeContext)
[es_116] Debug: [es_21] Starting execute of samples/datasources/otro.xaction (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: [es_30] Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: [es_33] Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
[es_116] Debug: SolutionRepository.DEBUG_FILE_PATH – [es_35] getFile path=C:\pentaho\bi-server\pentaho-solutions\samples\datasources\otro.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
[es_116] Debug: [es_34] audit: instanceId=9deb7b08-2d03-11dd-b5f1-eb78a6594b9d, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
[es_116] Debug: [es_1] validateComponent validating component org.component.SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
[es_14] Error: RuntimeContext.ERROR_0009 – [es_41] Could not create component org.component.SQLLookupRule – java.lang.ClassNotFoundException: No ClassLoaders found for: org.component.SQLLookupRule (org.pentaho.core.runtime.RuntimeContext)
[es_161] Error: RuntimeContext.ERROR_0006 – [es_2] Action components do not validate: otro.xaction (org.pentaho.core.runtime.RuntimeContext)
[es_161] Error: SolutionEngine.ERROR_0006 – [es_15] Action sequence validation failed (org.pentaho.core.solution.SolutionEngine)
[es_41] Server Version Pentaho BI Platform 1.6.0.GA.863
I have done all the steps, but I have a problem, when I try to execute My First xaction in Step 8:
Open up Firefox (cough IE) and hit the following URL:
http://localhost:8080/pentaho/ViewAction?&solution=samples&path=datasources&action=MyFirst.xaction
I cant do it, because if I put this URL appear the main URL:
http://localhost:8080/pentaho/Login
Do you know what could be the problem?
And I have another question, when I put jdbc:mysql://localhost/myDatabase in the URL not connect. Do you know something of this problem?
Thanks
Pingback: Nicholas Goodman on Business Intelligence » Blog Archive » It is FINALLY here - Manage Datasources
Pingback: It is FINALLY here - Manage Datasources | Integribase.com
Thanks for this extensive tutorial. It helps a lot.
I got it working after correcting some typo.
I have most of the error mentioned above. All of my problem is solved by double checking the files.
Thanks! u r the man.
Thanks Nicholas, easy and painless..
hi,thanks Daniel Einspanjer
hi,
i m using pentaho report designer1.7.7 & SQL Server Business Intelligence Development Studio.
i have created my database as “student database” and it contains one table as “student records”.
i want to connect this databse with pentaho report designer.
but i m getting error.
so please help me how to recover it.
Hi,
If I’m not wrong, we could report on data from excel documents. If this is achievable:
How to connect to the Excel Documents in Report Designer? What exact JDBC driver is needed and how is the way forward?
Many thanks,
please, update the tutorial to biserver ce 3.0
I am trying to connect to an iseries using the following:-
JNDI Name : AS400-RGDEV
Driver : com.ibm.as400.access.AS400JDBCDriver
Connection String: jdbc:as400:/rgdev;translate binary=true;
Username : What ever
Password : What ever
I get a Signon to the system display and after entering the required information I get a General security error (The application server rejected the connection).
Can anyone assist?
Regards,
Arthur.
Hi,
Nice to see this helpful tutorial.
Is there anything related to “email sending the report”?
I created one report using pentaho, and configured it to send email using design studio tool, and from the user console, when sending, it says “Could not send email..etc”
In the pentaho.log error, it says “SolutionEngine.ERROR_0006 – Action sequence validation failed”.
Any idea? Any of your suggestion will be highly helpful,
thanks,
Subeesh
dear all,
this is same thing i tried in mysql with jbossas but it is saying
org.jboss.resource.JBossResourceException: Could not create connection; – nested throwable: (org.jboss.resource.JBossResourceException: Apparently wrong driver class specified for URL: class: com.mysql.jdbc.Driver, url: jdbc:mysql://192.168.2.41:3306/learndb)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:90)
at com.iGrandee.Common.ConnectionManager.getVirtualLearnConnection(ConnectionManager.java:69)