Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: With sql server

  1. #1
    Join Date
    Jun 2010
    Posts
    1

    Default With sql server

    We have the pentaho software setup and installed, and the sample solutions working correctly, but I am having trouble getting our datasets working. All of our data is on MS SQL Server 2005. I successfully created and published a meta deta model as stated in the documentation, and I get data back correctly in the pentaho metadata editor. I am using the simplest of setups just one table really to get a hello world example working.

    I created a report with one column name as output, simple as can be, but when I run the report I get:

    Error: Base.ERROR_0002 - Component execution failed - java.lang.NullPointerException (org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent)
    Debug: Starting execute of DRMTouchTest/Reporting/test.waqr.xaction (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.platform.engine.services.solution.SolutionEngine)
    Debug: audit: instanceId=91db4777-7991-11df-89ba-4bc3748182fd, objectId=org.pentaho.platform.engine.services.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Error: Base.ERROR_0002 - Component execution failed - java.lang.NullPointerException (org.pentaho.platform.plugin.action.pentahometadata.MQLRelationalDataComponent)
    Error: RuntimeContext.ERROR_0012 - ActionDefinition for MQLRelationalDataComponent did not execute successfully (org.pentaho.platform.engine.services.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0007 - Action sequence execution failed (org.pentaho.platform.engine.services.solution.SolutionEngine)

    Server Version: Pentaho Platform Core 3.6.0-RC1.41573

    We are really serious about getting the Pentaho enterprise product, but we need to get it working first to move forward with our evalution. Could you provide us with some assistance?

    Thanks,
    Nicholas Walker

  2. #2
    Join Date
    Apr 2008
    Posts
    4,685

    Default

    Do you have the right JDBC Jars in your BI-Server directories?
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

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.