Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Intermittent Table Input error: Couldn't close query: resultSet or prepared statement

  1. #1

    Default Intermittent Table Input error: Couldn't close query: resultSet or prepared statement

    I'm writing a transformation gets rows with Table Input, then does a stream lookup using data pulled from another Table Input.

    Intermittently, some of my Table Input steps throw error:

    Unexpected error closing query : org.pentaho.di.core.exception.KettleDatabaseException:
    Couln't close query: resultset or prepared statements
    Cancel has been invoked on this Statement

    My statement in Table Input is very simple:

    SELECT
    ticker
    , security_name
    , cusip8
    , cusip
    , price
    FROM universe_fs

    I turned on detailed logging and don't see anything useful.

    This is Pentaho 4.1.0, using SQL Server DB connection to SQL Server.

    Thanks for any pointers.

  2. #2
    Join Date
    May 2008
    Posts
    26

    Default

    Hi,

    I have sometimes the same problem with Pentaho 4.2.0 / MSSQL / JTDS jdbc driver. Same query works or don't work. I thing, it depends from the row count of the query.
    Try

    SELECT TOP 10 * FROM universe_fs

    Braeu

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.