Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Adhoc Reporting - error 0012

  1. #1
    Join Date
    Oct 2010
    Posts
    8

    Default Adhoc Reporting - error 0012

    Hi!

    I got an error message when the report created by Adhoc Reporting is shown.
    When I create the report and press "Go", occurs the following message:
    AdhocWebService.ERROR_0012 - Failed to generate the report preview. Please check the server log for details of the error.
    I configured my database with JDNI in Metadata Editor, as followed at link http://forums.pentaho.com/showthread...215-error_0012, uploaded, but the error persists.

    If anyone could help me with this error, I'd appreciate...

    Find attached the log message.
    Attached Files Attached Files
    Last edited by lugaid; 01-31-2011 at 03:42 PM.

  2. #2
    Join Date
    Oct 2006
    Posts
    817

    Default

    Looks like a failure to audit the execution of the report. Can you make sure that JNDI name specified in pentaho-solutions/system/audit_sql.xml is valid?

    However, there appear to be several bugs here:
    1. When an audit connection is attempted and fails, the root cause is never sent to the log. (AuditConnection:189)
    2. After all attempts to get an audit connection fail, the finally clause does not check for null. (AuditSQLEntry:151)

    I created a JIRA: http://jira.pentaho.com/browse/BISERVER-5517

  3. #3
    Join Date
    Oct 2010
    Posts
    8

    Default

    mlowery, thanks for helping!

    So, the JNDI name on the file audit_sql.xml was really Hibernate, however, when I created the metadata, I used the name SampleData. Any other name, it refused.

    This info may be useful... I'm using the database Teradata, I couldn't test with another one.

  4. #4
    Join Date
    Oct 2010
    Posts
    8

    Default

    I tried to configure a new JNDI with Administration Console, but there was no configuration for Teradata. Do anyone know how can I add a valid Teradata connection in Adhoc??

    Thanks!

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.