Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: ERROR 0012 at first ad hoc report

  1. #1
    Join Date
    Apr 2009
    Posts
    24

    Default ERROR 0012 at first ad hoc report

    Hi all,
    I would like to share with you an error that occurs when I first create an adhoc report after launching Tomcat:

    Code:
    AdhocWebService.ERROR_0012 - Failed to generate the report preview. Please check the server log for details of the error.
    with "ActionDefinition for MQLRelationalDataComponent did not execute successfully" in the command window of tomcat.

    It appears that after I launch a non-adhoc report on the same datasource based on an xaction file, the reports work perfectly fine.
    Problem solved, but I don't find it very clean and would like to know where this error might come from and how to get round this issue.

    Any suggestion welcome.

  2. #2
    pstoellberger Guest

    Default

    did you have a look at the server log as suggested?
    can you post the stacktrace of the error?

  3. #3
    Join Date
    Apr 2009
    Posts
    24

    Default

    Quote Originally Posted by pstoellberger View Post
    did you have a look at the server log as suggested?
    can you post the stacktrace of the error?
    It appears pentaho cannot connect to my database directly from adhoc report but i need to launch a basic report first.

    Here is the log I get:

    Code:
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.0.0.RC2.37176
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.0.0.RC2.37176
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] 5470e2ba-3fb8-11de-be6f-bf665e4b32e3:COMPONENT:context-29727333-1242217179091:InMemorySolutionConnectFactory.ERROR_0001 - [fr_0] Database connection could not be established to: null jdbc:oracle:thin:@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    java.lang.NullPointerException
    What's puzzling is that my connection with metadata editor went perfectly well as I built my xmi file with no issue...
    Last edited by mad1s0n; 05-13-2009 at 08:43 AM.

  4. #4
    Join Date
    Apr 2009
    Posts
    24

    Default

    Quote Originally Posted by mad1s0n View Post
    It appears pentaho cannot connect to my database directly from adhoc report but i need to launch a basic report first.

    Here is the log I get:

    Code:
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.0.0.RC2.37176
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] Error Start: Pentaho Pentaho Platform Engine Core 3.0.0.RC2.37176
    2009-05-13 14:19:39,999 ERROR [org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent] 5470e2ba-3fb8-11de-be6f-bf665e4b32e3:COMPONENT:context-29727333-1242217179091:InMemorySolutionConnectFactory.ERROR_0001 - [fr_0] Database connection could not be established to: null jdbc:oracle:thin:@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
    java.lang.NullPointerException
    What's puzzling is that my connection with metadata editor went perfectly well as I built my xmi file with no issue...
    Ok I changed the connection type in metadata editor to a JNDI connection and not native and it seems to have resolved my issue.
    Thank you!

  5. #5
    Join Date
    Nov 2008
    Posts
    143

    Default

    Greetings,

    I tried as suggested but still got no result for first ad hoc report after following the wiki walkthrough and Diethard suggestions (http://diethardsteiner.blogspot.com/...ta-editor.html).

    My problem is the same as reported by mad1son, ERROR_0012.

    I tried for both jdbc and jndi data sources.

    Any clues?

    Thanks in advance,

    Renato

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.