Newbie question : error with my first action

[tom120934]

Hello everyone,

I'm using PCI 2.0 RC1 and I'm trying to get up and running my first action ever with Pentaho. Yes, you guessed right, I'm noob to Pentaho.

I created a brand new action in Eclipse^WReport Design Studio, using a JDBC:ODBC data source to reach some of my data. The configuration of the datasource has been checked using the Administration Console.

When I test the action in the 4th tab "Test" in the XAction editor, I got the following stack trace :
Pentaho BI Platform - Error in Action Failed Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug : [fr_21] Starting execute of bi-developers/analysis/Chantiers_SNGC.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug : [fr_30] Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug : [fr_33] Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)

Server Version: Pentaho Platform Engine Core 2.0.0-RC1.33017

Anyone, any lead for me ? Thanks for reading.

[tom120934]

Sorry for double post.

I just wanted to clarify a mistake I made in my first post : i'm talking about Design Studio, not Report.

Sorry for the up, but I'm still stuck with this issue so far, and I would really enjoy some kind of feedback.

Maybe I posted in the wrong section ?

[bugg_tb]

Well you could post the xaction here for us to see, also make sure its located in the pentaho-solution directory of your BI server

[tom120934]

Thanks for your quick answer and for moving my thread to the right place.

My xaction is in pentaho-solutions/bi-developers/analysis. The xaction file is attached below.

[bugg_tb]

A few things I noticed, just to make our lives easier try removing the outputs and putting query_result as an output with response Content as the output destination.

Also have you put the jdbcODBC driver in common/lib or wherever its supposed to live. Finally do you really have to use JDBC-ODBC bridge, ODBC sucks big style :)

Tom

[tom120934]

I performed the changes you described, here's the output I got (I re-attached the xaction file if it can be helpful)


Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine) Debug : [fr_21] Starting execute of bi-developers/analysis/Chantiers_SNGC.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug : [fr_30] Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
Debug : [fr_33] Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
Erreur : SolutionEngine.ERROR_0007 - [fr_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)


ODBC sucks, I agree with that, just like anyone. But for my first attempt at Pentaho, I want to use Microsoft Access "databases". Just to skip the ETL step. And as the JdbcOdbc driver is in rt.jar, it's available almost everywhere and easy simple to use, so I choosed it for a first test.

Thanks again for your fast support. I'm impressed.

Tom

[bugg_tb]

I want to use Microsoft Access "databases".

Arghhhhhh


Thanks again for your fast support. I'm impressed.

Well its a monday I'm bored and trying to avoid doing real work ;)

If you look at other Xactions you will see that the output is 'response Content' not response query_result. I don't know if this is actually your problem but its better getting some standards set first. You have hit the best xaction problem though where it doesn't really give you an error. I assume rt.jar is in common/lib also check logs/catalina.out for a real error message of some sort(grasping at straws here)

If you fancy some real time help feel free to log onto the irc channel where some of us pretend to do work.

Tom

[tom120934]

Thanks to bugg_tb and pstoellberger, my problem is now solved. I got impressive support from both of you guys, so be thanked publicly as you deserve.

2 steps I forgot :
- Refresh the solutions repository within the User Console
- Copy the jar containing my Jdbc driver to tomcat/common/lib

From there, I got a significant error message, and I learned that my problem was caused by the Access ODBC driver.

So I move on to Pentaho Data Integration (formerly known as Kettle) to copy my Access databases to MySQL. No more problem since, the MySQL Jdbc driver being shipped with BI server.

Thanks again to bugg and pstoellberger !

PS : Can any admin/moderator change the thread name to indicate it's solved ? Thanks by advance.

[abude]

2 steps I forgot :
- Refresh the solutions repository within the User Console


Just to be sure, you mention the Administrator Console, not the User Console, right?

When is it necessary to refresh the Solution Repository?