Connect to your own Database

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”

myfirst_001.png
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

myfirst_002.png

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
myfirst_003.png

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
myfirst_004.png
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!

64 thoughts on “Connect to your own Database

  1. Chris Lavigne

    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…

    Reply
  2. ngoodman Post author

    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

    Reply
  3. Chris Lavigne

    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

    Reply
  4. Cesar

    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

    Reply
  5. ngoodman Post author

    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:

    < ?xml version="1.0" encoding="UTF-8"?>


    xe
    jdbc:oracle:thin:@localhost:1521:xe
    oracle.jdbc.pool.OracleConnectionPoolDataSource
    HR

    oracle1

    Reply
  6. ngoodman Post author

    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

    Reply
  7. Cesar

    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 :-(

    Reply
  8. Cesar

    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.

    Reply
  9. Cesar

    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.

    Reply
  10. Sérgio Agostinho

    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

    Reply
  11. tiger

    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.

    Reply
  12. sathish

    Absouletely great article. its really helpful in solving many connection issues. Thanks to all of you.

    Reply
  13. Menzlitsh

    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

    Reply
  14. Relzon

    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 ?

    Reply
  15. Esteban

    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 “]]”

    Reply
  16. satya

    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

    Reply
  17. saravanan

    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

    Reply
  18. Saravanan

    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)

    Reply
  19. Bart Farasyn

    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

    Reply
  20. Leslie

    Great intro to Pentaho question 2!

    Successfully connected to MS SQL Server with windows authentication using jtds driver and jcifs.

    Thanks
    Les

    Reply
  21. Yamini

    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!

    Reply
  22. HARI

    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?

    Reply
  23. HARI

    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

    Reply
  24. Daniel Einspanjer

    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.

    Reply
  25. tlemsani

    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)

    Reply
  26. Alejandra

    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

    Reply
  27. Alex Lim

    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.

    Reply
  28. Tom Healy

    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.

    Reply
  29. kurniawan

    sorry, i still have error when use firebird, maybe Bart can help me with his experience setting pentaho with firebird step by step, thanks

    Reply
  30. kurniawan

    how about you add some information of connector that compatible with pentaho from different database server i.e Firebird,MS SQL,MySQL etc.

    Reply
  31. Frank Carnovale

    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.

    Reply
  32. pradeep kumar

    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

    Reply
  33. adallac

    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

    Reply
  34. adallac

    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

    Reply
  35. MG

    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.

    Reply
  36. Bill

    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

    Reply
  37. David

    I’m having problems trying to connect to a MS SQL server using native Windows authentication (not SQL). Do you have any advice?

    Reply
  38. Ivan Noboa

    Mondrian & Oracle in this page (spanish)http://pentaho.almacen-datos.com/mondrian_oracle.html
    .I’ve tried it and it really works.

    Reply
  39. Eduardo

    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,

    Reply
  40. Jun Villabroza

    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

    Reply
  41. Jesus

    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) ????

    Reply
  42. JohnB

    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

    Reply
  43. Patricia Martin

    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

    Reply
  44. Pingback: Nicholas Goodman on Business Intelligence » Blog Archive » It is FINALLY here - Manage Datasources

  45. Pingback: It is FINALLY here - Manage Datasources | Integribase.com

  46. Roger

    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.

    Reply
  47. nishi kishore

    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.

    Reply
  48. Anitha

    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,

    Reply
  49. Arthur Jeffers

    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.

    Reply
  50. Subeesh

    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

    Reply
  51. ramasubramaniam

    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)

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>